This chapter provides an overview of non-currency and multicurrency environments and discusses how to update domestic currency codes.
If you have been using JD Edwards EnterpriseOne software without multicurrency activated and are now changing to multicurrency processing, review and complete the items in the Prerequisites. Upon completing them, complete the task Updating Domestic Currency Codes to update all existing transactions from a blank currency code to a valid currency code. Finally, after updating the domestic currency codes, you must complete three additional tasks. Then you can begin working in a multicurrency environment.
Before you complete the tasks in this chapter:
Select a method for converting amounts from one currency to another, and specify that you allow journal entries between companies that have different base currencies.
Specify the currency code for each currency that you want to use.
Decide whether you will use currency restatement and, if so, which method you will use.
Decide whether you will maintain account balances by currency.
For each company in the organization, specify the currency code, the restatement method, and whether you will maintain account balances by currency.
Review the ledger types in user-defined code (UDC) tables 09/LT and 09/LA.
Decide whether you want to set up any additional ledgers and whether the additional ledger should contain only one currency.
Specify the general ledger accounts that will accept only transactions in a specific currency and assign the currency code to the accounts.
Set up multicurrency AAIs.
Enter the initial exchange rate between the company domestic currency and all other currencies that you have defined.
Create an exchange rate that is not quoted in a financial publication.
Assign currency codes to the customers and suppliers to specify the currency of their invoices and vouchers.
This section provides an overview of domestic currency code updates and discusses:
How to run the Load Domestic Currency Code programs.
After you run the Load Domestic Currency Code programs.
To change to multicurrency processing, you must run the Load Domestic Currency Code programs to update all existing transactions with a valid (not blank) currency code. Prior to running these programs, all records must have a blank currency code. The program will not finish if any records have a currency code.
To update existing transactions with a currency code, you run the Load Domestic Currency Code program for each system that you use. These batch programs also update the mode for each transaction and print an error report if either of these situations exist:
A company does not exist in the Company Constants table (F0010).
A company does not have a domestic currency code.
To assign a currency code to a company, use the Company Names & Numbers program (P0010).
Note. Do not run the Load Domestic Currency Code programs if you activated multicurrency processing when you initially set up JD Edwards EnterpriseOne software.
Select Multi-Currency Advanced Operations (G1131), Load Domestic Currency Code.
This table lists the Load Domestic Currency Code programs and the tables that they update:
Program |
Tables Updated |
Account Ledger (F0911) |
|
Accounts Payable Ledger (F0411) Accounts Payable - Matching Document (F0413) Accounts Payable Matching Document Detail (F0414) |
|
Customer Ledger (F03B11) Invoice Revisions (F03B112) Receipts Header (F03B13) Receipts Detail (F03B14) Credit and Cash Management (F03B15) A/R Statistical History (F03B16) A/R Statistical Summary (F03B16S) A/R Notification History (F03B20) A/R Notification History Detail (F03B21) A/R Fee Journal History (F03B22) A/R Fee Journal History Detail (F03B23) A/R Deduction Management (F03B40) A/R Deduction Activity (F03B41) |
|
Taxes (F0018) |
|
CRCX field in Account Balances (F0902) |
|
Billing Detail Workfile (F4812) Billing Workfile History (F4812H) Invoice Summary Work File (F4822) Contract Master (F5201) Contract Billing Line Detail (F5202) |
|
Tenant/Lease Billings Detail (F1511B) Recurring Billings Master (F1502B) Sales Overage Master (F15013B) Tenant E.P. Class Master (F15012B) Tenant Escalation Master (F15016B) Security Deposit Master (F1565) |
|
Sales Order Header (F4201) Sales Order Detail (F4211) |
|
Purchase Order Header (F4301) Purchase Order Header (F4311) Purchase Order Ledger Detail (F43199) Purchase Order Receiver (F43121) |
After you run the Load Domestic Currency Code programs to update transactions with valid currency codes, you must:
Determine whether you need to run the Update Display Decimals program.
See JD Edwards EnterpriseOne Tools 8.98: System Administration Guide
Repost the account ledger to update the currency code fields in the F0902 table.
See Reposting the Account Ledger and Recalculating a Fiscal Year.
Close the fiscal year to update the balance forward fields in the F0902 table.