Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL195


GL195 - Translation Calculation

**Form Purpose
Run Translation Calculation (GL195) to translate one company's base currency
balance to the base currency of another company for reporting and
consolidation. You can also use GL195 to consolidate units.

**Processing Effect
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 Currency Table Translation Rates (CU20.1) and the translation code
defined in Translation Code (CU05.1).

The Rate Type you select for the translation code in CU05.1 affects how the
base currency amounts are translated. If you selected Ending Historical, or
Historical Balance, 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
difference in amounts between the exchange rate and the translation rate.
Company zone accounts are defined in Interzone Relationships (GL30.1).

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

    ADDRDATA   -

    CKPOINT    - Used for restart capability.

    GLCONDRILL -

    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.


    GLESACCT   -

    GLNAMES    - Used to validate accounting units.

    GLSYSTEM   - Used to validate companies.

    GLUNITS    -

    GLZONE     - Used to validate zones.

    INSTCTRYCD -

    TRCODES    - Used to validate translation codes.

    WFSETUP    -


INVOKED Programs

    GLCT
    IFAC
    ACAC
    ACCL
    ACTA
    API4
    IFCU
    IFOB
    IFSG
    IFLU
    IFAU
    SLSE
    SLSU
    IFFC
    IFGT
    GLCC
    IFRS
    IFSC
    SLSB
    SLSS
    SLFD