Translating actual amounts using Currency Translation (Intercompany)

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).