This chapter contains the following topics:
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.
Decide whether to use currency restatement and, if so, which method.
Decide whether to maintain account balances by currency.
For each company in the organization, specify the currency code, the restatement method, and whether to 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 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 does 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.
|Load Domestic Curr Code - G/L (R11809)||Account Ledger (F0911)|
|Load Domestic Curr Code -A/P (R11804)||Accounts Payable Ledger (F0411)
Accounts Payable - Matching Document (F0413)
Accounts Payable Matching Document Detail (F0414)
|Load Domestic Curr Code - A/R (R11803)||Customer Ledger (F03B11)
Invoice Revisions (F03B112)
Receipts Header (F03B13)
Receipts Detail (F03B14)
Credit and Cash Management (F03B15)
Revenue Recognition (F03B116)
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)
|Load Domestic Curr Code - Tax (R11818)||Taxes (F0018)|
|Load Domestic Curr Code - Acct. Balances (R11802)||CRCX field in Account Balances (F0902)|
|Load Domestic Curr Code - System 48S/52 (R11848S)||Billing Detail Workfile (F4812)
Billing Workfile History (F4812H)
Invoice Summary Work File (F4822)
Contract Master (F5201)
Contract Billing Line Detail (F5202)
|Load Domestic Curr Code - Real Estate Mgmt (R11815)||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)
|Load Domestic Curr Code - Sales (R11842)||Sales Order Header (F4201)
Sales Order Detail (F4211)
|Load Domestic Curr Code - Procurement (R11843)||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 have to run the Update Display Decimals program.
Repost the account ledger to update the currency code fields in the F0902 table.
Close the fiscal year to update the balance forward fields in the F0902 table.