Translating actual amounts using Currency Translation (Intercompany)

Note: To translate a Multi-Book Ledger company balances using currency translation, use Ledger Translation Calculation Translation (ML195). Follow the same procedure described here. For more information, see the Multi-Book Ledger User Guide.

Use this procedure to translate one company base currency balance to the base currency of another company for reporting and consolidation. Information is translated based on the From Company parameters. If the company base currencies are different, then the account balances are translated to the consolidation company base currency based on the translation rate defined on Currency Table Translation Rates (CU20.1) and the translation code defined on Translation Code (CU05.1).

  1. Access Translation Calculation (GL195).

    Note: The rate type you select in Translation Code (CU05.1) affects how the base currency amounts are translated. If you select a rate type of Ending or Historical, then the year-to-date amounts are updated. If you select a rate type of Average, then the amount for the period you select in this form is updated.
  2. Run the program. Use these guidelines to specify the field values:

    From Company

    The From Company is the source company. The account balances in the From company will be multiplied or divided by the period translation rates to arrive at the translated account balances.

    To Company

    The To Company is the consolidation company. The program processes the account balances in the From Company and creates transactions in the To Company.

    Translation Level

    The Translation Level field determines the consolidated level at which the From Company translates to the To Company. If company level 0 is selected, then an accounting unit is required to store the amounts in the To Company.

    If the company base currencies are different, then the account balances are translated to the consolidation company base currency based on the translation rate in effect for the period.

    Periods

    If you run GL195 for a range of periods, then the resulting journal entries are created for the last period in the range, or to the current period if the last period is closed. The journal entries have a CT source code and a Released status.

    Update

    Select No to get an edit listing of the entries that will be created. When you are satisfied with the results, select Yes to create journal entries.

    Accounting Unit

    This field identifies the accounting unit that is used with the Translation Level of Company. The consolidated amounts will be stored in this posting accounting unit.

    Account Detail

    This field determines the level of account detail included. The default setting is Subaccount, which consolidates at the sub-account level. You can select account, which consolidates at the account level.

    Fiscal Year

    You can specify or select the fiscal year you are transferring actual amounts in. If you leave this field blank, then the current year becomes the default value.

    Post Date

    Select the post date of the translation journal. This field is not required, but is helpful if the From Company and To Company have different fiscal years or period end dates.

    Percent

    You can consolidate a percentage of the actual balance by specifying a percentage in this field. If you leave this field blank, then all of the actual balance is consolidated.

    Unit

    You can consolidate units by typing or selecting Y (Yes) in this field. The default setting is N (No).

    Report

    You can indicate if the report prints. The default setting is Yes.

  3. Post journal entries using Journal Posting (GL190).

Impact on General Ledger

GL195 creates a released journal entry in the consolidation company with:

Note: Journal entries for balance sheet accounts ending balances are flagged to auto-reverse, except in the last period of the year.
  • Transactions for balance sheet account ending balances

  • Transactions for income statement account period balances

  • A balancing translation gain or loss journal transaction if the base currencies are different and the translated amounts do not net to zero

Translation gain and loss accounts defined on System Accounts (GL00.7) are used to create balancing journal entries. Translation balance sheet transactions are reversed in the next period when Period Closing (GL199) is run in the consolidation company.

Other procedure related to Currency Intercompany Translation (Intercompany)

If you want to Then
Run this program again for the same period
  1. Delete the translation journal entries using Journal Control (GL45.1).

  2. Run GL195 again for each source company.