This chapter contains the following topics:
The system-level prerequisites include tasks that affect the overall JD Edwards EnterpriseOne systems and are not specific to any one system. The tasks include compiling lists of the companies that you plan to convert, determining the amount of historical data to convert, archiving data tables, and so on.
The system-level prerequisites are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete.
Note: Complete the system-level prerequisites and all remaining tasks in this guide in the test environment first, correcting any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live. |
This checklist discusses the prerequisite tasks that you must perform before you run the base currency conversion:
Prerequisite | Description | Complete |
---|---|---|
Install JD Edwards EnterpriseOne Multicurrency (11). | This prerequisite is required for clients who have not installed system 11. | |
Activate multicurrency. | This prerequisite is required for clients who have not activated multicurrency. | |
Update currency code fields that contain a blank. | This prerequisite is for new multicurrency clients only. The programs for the base currency conversion do not convert transactions without a currency code. To assign a currency code to transactions with a blank currency code, you must run update programs for the systems that you use. | |
Compile a list of the JD Edwards EnterpriseOne systems used at your site. | The programs for the base currency conversion and many of the preconversion and postconversion tasks apply to specific systems. Determine which systems you use and compile a list. You can save time by running the conversion programs and by completing preconversion and postconversion tasks for only the systems that you use. | |
Compile a list of the companies that you plan to convert to a new base currency. | You must determine which companies you are going to convert to a new base currency and compile a list. You convert companies by environment. Within an environment, you can convert individual companies one at a time, multiple companies with the same base currency at the same time, or multiple companies with different base currencies at the same time.
You do not have to convert companies with multicurrency intercompany transactions in the same plan or at the same time. However, you must convert all companies in all plans before you run the MultiCurr Interco Conversion (R890911EB) and the MultiCurr Interco Conversion Post (R8909801EB) programs, which make the necessary adjustments and keep the multicurrency intercompany transactions in balance. |
|
Determine how much historical data to convert to the new base currency. | You should consult the Finance and Administration department to determine how many years of historical data to convert to the new base currency. This depends on the company audit requirements, local government requirements (if applicable), and any disk space considerations. Some companies convert one or two years of historical data, while others convert opening balances only.
If you convert historical data, verify that exchange rates exist in the F0015 table for the effective dates that you convert. Remember to archive any historical data that is needed for fiscal audit reporting purposes. |
|
Compile a list of custom programs and third-party software used at the site.
See Base Currency Conversion and Non-JD Edwards EnterpriseOne Records. |
The conversion programs convert records that are created and maintained using JD Edwards EnterpriseOne software. They do not convert non-JD Edwards EnterpriseOne records that you entered through custom programs or third-party software unless required fields and tables are identical to those in the JD Edwards EnterpriseOne software.
To convert non-JD Edwards EnterpriseOne records using a specific conversion program, you must research and determine which fields in the non-JD Edwards EnterpriseOne records must be completed. |
|
Identify which currency amounts round to zero after the base currency conversion.
See JD Edwards EnterpriseOne Base Currency Conversion Tables. |
(Optional) Identify any currency amounts that the base currency conversion rounds to zero. To identify these amounts, create and run a query or batch program using the tables in the JD Edwards EnterpriseOne systems that you use.
For example, if you use the JD Edwards EnterpriseOne Sales Order Management system, you might create and run a query or batch program using:
When you run the base currency conversion, amounts that round to zero appear as a warning on the table conversion reports. By identifying these amounts before the conversion, you can:
|
|
Summarize and purge outdated data tables. | Summarize and purge outdated data in tables. | |
Defragment tables and rebuild table indexes. | Prerequisite: (Optional) Summarize and purge outdated data tables.
After purging outdated data tables, defragment the affected tables and rebuild the table indexes. Contact the database administrator for information about this process. |
|
Archive data tables. | You must summarize and purge outdated data tables.
Consult the Finance and Administration department to determine how many years of historical data to archive for company audit and government legal requirements. Based on those requirements, archive:
Be aware that you cannot restore archived data tables to the production environment after the conversion because the conversion programs change the base currency. You can, of course, restore archived tables to an environment that is not the production environment. |
|
Verify company currency. | Verify the currency code of each company that you are going to convert by accessing the Company Names & Numbers program (P0010). The currency code must be set to the existing base company currency (that is, the currency that you convert) for the conversion programs to run. | |
Compile a list of special circumstances. | Compile a list of any special circumstances to monitor. Use the list to verify results after the conversion. |