Detail Fields

Enter the beginning account in the range of accounts on which you want the computation performed. You must enter this number in the object.subsidiary format.

This program verifies that the from account is less than or equal to the thru account.

Enter the ending account in the range of accounts on which you want the computation performed. You must enter this number in the object.subsidiary format.

This program verifies that the beginning (from) account is less than or equal to the ending (thru) account. For the Thru Account, you should enter a subsidiary of 99999999 or ZZZZZZZZ (depending on the operating system) to ensure that all subsidiaries are included in the account range.

Enter the calculation method to use for balance currency restatement. Values are:

0: Period calculations. This method uses the net posting amounts for a specific period and is typically used to restate profit and loss accounts and equity accounts.

1: Balance calculations. This method uses year-to-date account balance amounts and is typically used to restate balance sheet accounts.

The value entered in this field must be 1 (balance calculation) for the system to perform a translation adjustment calculation for the range of accounts. If the value of this field is0 (period calculation), the system does not allow a translation adjustment calculation.

Enter the ledger from which the balances are to be converted. The most commonly used ledger type is AA. This field is optional.

Enter the override ledger type to be used for this detail line of business unit/account range selection. The system uses this ledger type for this detail instead of the From Ledgers types listed in the header area of the form. For example, CA ledger type for monetary accounts or XA ledger type for historical balances from a company's alternate ledger type, such as fixed assets.

Enter the override exchange rate to use in place of the active rate to calculate the currency restatement, if applicable. If you leave this field blank, the system uses the exchange rate in the Currency Restatement Rates table (F1113).

Enter a value in this field only if you do not expect the exchange rate to change over time. If you expect the rate to change, use the Currency Restatement Rates table to define the rates. When you use an override exchange rate and the rate changes over time, any audit history of how the rate changed is lost. Because the audit history is not available, the Balance Currency Restatement program cannot accurately calculate the restated balances.

The number in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

Enter the account to use for the currency translation gain or loss amount. The system uses the account in this field (detail area) to create a translation gain or loss amount due to a change in the exchange rate within a fiscal period. This entry is used only for analysis and is not a balancing entry.

If you specify an account in this field, the system uses this field in combination with the C M field. The value in the C M field must be 1 for the system to accept a value in this field.

If you do not specify a translation adjustment account in either the header or detail area field, the system does not calculate currency translation adjustments. Use the translation adjustment account to ensure a balanced chart of accounts in the destination ledger.

Note:

If you specify an account in this field that is assigned to a different company, the system issues an error message.

If you enter the same account in this field as the Translation Adjustment Account field in the header area, the system issues an error message. The accounts cannot be the same.