GL195 - Translation Calculation

Run GL195 (Translation Calculation) to translate one company's 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, the account balances are
translated to the consolidation company's base currency based on the
translation rate defined in CU20.1 (Currency Table Translation Rates) and the
translation code defined in CU05.1 (Translation Code).

The Rate Type you select for the translation code in CU05.1 affects how the
base currency amounts are translated. If you selected Ending or Historical,
amounts are reversed. If you selected Average, amounts are not reversed.

If the To 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).

This program processes the account balance actual amount in the From Company
and creates transactions in the To Company. The Translation Level field
determines the consolidated level at which the From Company translates to the
To Company.

If you run this program for a range of periods, 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. You must post these journal entries before you close the
accounting period for the consolidation period.

Updated Files

    CKPOINT    - Used for restart capability.

    GLMASTER   - Used to validate posting accounts.  This file is updated if
                 dynamic account generation is used.


    SYSTEMCODE - This file is updated with the last remote site transaction
                 identification number assigned.



Referenced Files

    CUCODES    - Used to validate a currency code.

    CUCONV     - Used to access currency exchange rates.

    CURELAT    - Used to validate currency relationships.

    CUTRANSL   - Used to access currency translation rates.

    GLACCTREL  - Used to validate account relationships.

    GLADDRESS  - Used by common library; not referenced in this program.

    GLAMOUNTS  - Used to access posting account period balances.

    GLCHART    - Used by common library; not referenced in this program.

    GLCHARTDTL - Used to validate a detail account.

    GLCOMPREL  - Used to validate organization relationships.

    GLCONSOL   - Consolidation file balances are used when processing higher
                 than the lowest level in the  company.


    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLZONE     - Used to validate zones.

    TRCODES    - Used to validate translation codes.


INVOKED Programs

    IFCC
    IFCR
    IFSG
    IFCU
    IFFC
    IFGT
    ACAC
    IFAC
    IFAU
    SLSE
    SLSU
    IFOB
    IFRS
    IFSC
    SLSB
    SLTV
    SLFD