Ledger Report Currency Translation (ML196)

Run Ledger Report Currency Translation (ML196) to translate the company base currency balances to report currency balances.

This program compares the ending and period base currency amounts with the report currency amounts. If there are differences between the two amounts, report currency translation updates the balances for the report currencies. For example, if the translation rate increases from 5 to 8 percent, the base currency amount is multiplied by 3 (the percentage change) to update the report currency amount. The system creates a journal entry to record the adjustments.

Processing Effect

The company base currency is translated using the translation table rate defined in CU20.1 (Currency Table Translation Rates) and the translation code defined on CU05.1 (Translation Code).

The Rate Type you select for the translation code in CU05.1 affects how the base currency and report currency amounts are translated. If you selected Ending or Historical, the year-to-date amounts are updated. If you selected Average, the amount for the period you select in this form is updated.

If your company uses zone balancing, offset transactions are generated in your transaction gain and loss accounts. Offset transactions are the amount difference between the exchange rate amount and the translation rate amount. Company zone accounts are defined in GL30.1 (Interzone Relationships).