This chapter contains the topic:
From General Accounting (G09), choose Revaluation and Restatement
From Multi-Currency Processing (G11), choose Financial Restatement
From Multi-Currency Financial Restatement (G1122), choose Compute Restated Balances
Based on the exchange rates and calculations you defined, you can use the Compute Restated Balances program to:
Restate a selected period, a range of periods, or all periods in the current year
Apply an individual rate to each period you are restating, or apply a single rate to all periods
Apply a different exchange rate for a specific range of accounts
Restate up to three source ledger types to a single destination ledger type
This program restates balances for the defined range of accounts from a source ledger type into the AC (consolidation) ledger type. Although the AC ledger type is commonly used, the consolidation ledger type can be any user-specified ledger type except AA, CA, XA, YA, ZA, or AZ.
Compute Restated Balances is a DREAM Writer program.
You can run this program as often as necessary. Rerunning the program overwrites existing balances, unless you specify a different destination ledger type. You can run this program in three modes, as follows:
Mode | Description |
---|---|
Proof mode with report | The system prints a report, but does not create balances in the destination ledger type. |
Final mode with report | The system creates balances in the destination ledger type and prints a detailed audit trail. |
Final mode without report | The system creates balances in the destination ledger type and does not print a detailed audit trail. |
This program uses information from the Account Balances (F0902), Company Conversion Parameters (F1114), and Currency Restatement Rates (F1113) tables.
Set up the consolidation ledger type (usually AC) in the user defined code list 11/TL to define the ledger type as a restatement ledger type. See Set Up User Defined Codes in the JD Edwards World Accounts Receivable Guide.
Enter the currency code (designating the consolidation currency) in the Special Handling field for the AC ledger type in the user defined code list 09/LT. This code must be left justified to work correctly. See Set Up User Defined Codes in the JD Edwards World Accounts Receivable Guide.
Enter the computation ID to use for specific companies on Company Numbers and Names. See Section 35.3, "Setting Up Companies for Detailed Currency Restatement."
Verify that you have the correct rate types and calculation methods associated with account ranges. See Chapter 32, "Work with Calculations for Balance Restatement."
Topic | Description |
---|---|
Exchange rates | It is important that you update the exchange rates used to restate balances.
If rates do not exist, the Currency Restatement report has blanks in the exchange rate and restated balance columns. If you do not print zero restated balances, all accounts in that range are omitted from the report. |
Decimal placement | The Compute Restated Balances program determines currency decimals by the currency code for the destination ledger type.
If you do not associate a currency code with the consolidation ledger type in the user defined code list 09/LT, decimals might appear incorrectly on some inquiry programs and reports. |
Journal entries directly to the restated ledger | When you create a journal entry directly to the restated ledger, the system calculates the period postings or period balances (depending on what calculation method you are using) as usual and then adds in the additional amount. On the report you will see an asterisk (*) next to the restated current balance. Additionally, each subsequent balance will have the amount added to it. |
Annual close for ledgers with balance restatement | To perform an annual close on the AC or other user-defined ledgers used for balance restatement, set them up in the retained Earnings ledger list (09/LA). On the retained earnings ledger list, the first position of the Special Handling field must be an X for each of these ledger codes. |