Completing the General Accounting Preconversion Checklist

This checklist discusses the preconversion tasks that apply to the JD Edwards EnterpriseOne General Accounting system:

Preconversion Task	Description	√
Determine whether to run multiple versions of the Convert F0911 Base Currency program (R890911E). See Running Multiple Versions of the F0911 Conversion Program.	Run the Convert F0911 Base Currency program. To reduce the processing time when converting the records from the F0911 table, you can run multiple versions of this program from different workstations.
Verify that currency codes in the CRCD and CRCX fields exist in certain tables and that they are accurate. See Verifying the CRCD and CRCX Currency Code Fields.	The base currency conversion does not convert amounts without a currency code, that is, it does not convert amounts when the associated CRCD and CRCX fields are blank.
Process all batch journal entries.	Upload all journal entry batch transactions to create records in the F0911Z1 table, and then process them to create transactions in the F0911 table.
Reconcile all bank statements.	Complete bank statement processing and reconciliations for all companies that you are going to convert to a new base currency.
Delete the WF - Account Ledger Reconciliation workfile (F0911R).	The base currency conversion does not convert records in the F0911R workfile. Delete the workfile before the conversion so that you do not inadvertently try to reconcile unconverted records after the conversion. After the conversion, regenerate the workfile so that the records are based on the new base currency amounts.
Review a list of the model journal entries.	Review a list of the model journal entries and determine whether you need to manually change them after the conversion. The base currency conversion does not convert model journal entry amounts in the F0911 table. Run a query or batch program over the F0911 table for journal entries with a posted code M (model). Review the list and, after the conversion, revise the model journal entries, as needed.
(Optional) Enter budget amounts in the current base currency for the upcoming year.	Complete this task if you want the base currency conversion programs to convert the budget amounts in the BA ledger to the new base currency. The conversion programs convert budget amounts in the BA ledger only. The conversion programs do not convert amounts in currency-specific ledgers. If you do not want to convert the budget amounts, create a new ledger type (such as BX), assign a currency code to the ledger, and enter the budget amounts. The amounts do not convert as long as the ledger type has a currency code assigned to it.
(Optional) Run allocations.	Complete allocations for the current period or year, depending on when you run the base currency conversion.
Review a list of the allocations.	Review a list of the recurring journal entries for the allocations and determine whether you want to manually change fixed amounts after the base currency conversion. The conversion does not convert amounts in the Cost Allocations/Flex Budgeting table (F0912). Run a query or batch program over the F0912 table for journal entries with a batch type of D. Review the list and, after the conversion, revise the recurring journal entries for the allocations, as needed.
Run the annual close.	Complete this task only if you run the base currency conversion at the end of a fiscal year. You should run the annual close before you run the base currency conversion. The advantages to doing this include: The data that the company converts is likely to contain fewer errors because most companies ensure that all accounts are reconciled and balanced as part of their year-end procedures. By running the annual close before you run the conversion, you should have fewer integrity issues after the conversion. You can provide the auditors with year-end reports in one currency instead of two currencies.
Complete fiscal date pattern steps.	Complete this task only if you change a company's fiscal date pattern before running the base currency conversion. Make sure that you complete all steps for changing a company's fiscal date pattern before you run the conversion programs. The steps include running the repost, annual close, and all integrity reports.
(Optional) If XA and AC ledgers are not used, retain amounts in the domestic currency.	If you want to retain amounts in the existing base currency of the company, restate the domestic currency ledger to a currency-specific ledger before you run the conversion. The amounts do not convert because amounts in currency-specific ledgers, such as XA and AC, are not converted. For example, suppose that a Canadian company wants to be able to review their original balances in the Canadian dollar (CAD) after they run the conversion to convert to the Japanese yen (JPY). To do this, the company restates the AA ledger to the AC ledger before the conversion. The original domestic balances (CAD) reside in the AC ledger and, after the conversion, the JPY balances reside in the AA ledger. You should run balance currency restatement instead of detailed restatement to retain the domestic currency amounts. If you run detailed restatement, be aware that the size of the F0911 table increases significantly. This might create serious performance and disk space problems during the base currency conversion.
Set up currency relationships for the new base currency. See "Setting Up Currency Codes" in the JD Edwards EnterpriseOne Applications Multicurrency Processing Implementation Guide. See "Setting Up Exchange Rates" in the JD Edwards EnterpriseOne Applications Multicurrency Processing Implementation Guide.	Verify that you have set up this information before you run the base currency conversion: Currency code for the new base currency. Exchange rates and currency relationships between the currencies that you are converting from and the new base currency that you are converting to.
Set up exchange rates for previous years.	If the company plans to convert transactions that are dated in a previous year, set up exchange rates for the currency relationships with an appropriate effective date. For example, a Canadian company that wants to convert historical data for year 2010 to their new base currency (JPY) must set up a CAD to JPY exchange rate with an effective date of January 1, 2010. The effective date must include the general ledger date of the oldest transaction.
Verify an option in General Accounting Constants.	If the company does not create multicurrency intercompany transactions, make sure that the Allow MultiCurrency Intercompany Transaction option in the General Accounting Constants program (P0000) is not selected. The conversion takes longer to process when the option is selected.
Compile a list of batches posted out of balance. See Running Preconversion Integrity Reports.	Run the Batch to Detail report (R007031) and compile a list of accounts receivable, accounts payable, and general ledger batches that were intentionally posted out-of-balance. Use this list to compare the results after the conversion. The Batch to Detail report indicates batches in which the Post Out of Balance option and the Include Batch on Integrity option are set to Y.
Post all journal entry transactions to the general ledger. See Completing the Final Post Preconversion Checklist.	Run all active batches through to completion and verify the posting edit reports.
Run all financial reports.	Consult the auditors to find out which financial reports are required and then run the reports.