Consolidating Company Balances

You can transfer balances from more than one general ledger company to a designated consolidation company to consolidate financial information for an organization.

The consolidation company must have a status of Consolidation.

Note: To consolidate at a level below company, select the consolidation level in the Translation Level field.

To consolidate company balances

  1. Access Translation Calculation (GL195).

    To view the Translation Code and Rate Type, select the Translation Code Link. Translation Code (CU05.1) is displayed.

  2. Run Translation Calculation (GL195) for each general ledger company from which you want to transfer balances to the general ledger company designated for consolidation. Use the following guidelines to enter field values:
    From Company

    Type or select the company number you are transferring amounts from.

    To Company

    Type or select the company number you are transferring amounts to.

    Fiscal Year

    Type or select the fiscal year you are transferring actual amounts in.

    Post Date

    Type the post date of the translation journal.

    Units

    Select whether or not to consolidate units.

    Report

    Select whether the report prints.

    Translation Level

    The level at which level you want to consolidate and transfer amounts.

    levels:

    • Level 0, Company: Consolidates at a company level, An Accounting Unit must exist in the To company.

    • Level 1-4, Consolidated at a specific level

    • Level 5: Actuals are transfered from one company/accounting unit/account to the To company/accounting unit/account.

    Accounting Unit

    The To Company accounting unit that must be selected when using Translation Level=0. The consolidated translated account amounts will be posted to this accounting unit.

    Account Detail

    Use to indicate that amounts are consolidated at the account level or at the subaccount level. Valid values are S=Subaccount or A=Account.

    Periods

    The period range of translation.

    Percent

    The percentage of the actual balance that you want translated.

    Update

    Select to update the To company, without running the report.

    Note: If you need to run GL195 again for the same period, you should delete the journal entry created from the first run of GL195 and then run GL195 again for each source company.