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).
GL195 also lets you consolidate units.
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.
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.
GLNAMES - Used to validate accounting units.
GLSYSTEM - Used to validate companies.
GLUNITS -
GLZONE - Used to validate zones.
TRCODES - Used to validate translation codes.
WFSETUP -
INVOKED Programs
IFAC
ACAC
ACCL
IFCU
IFSG
IFAU
SLSE
SLSU
IFFC
IFGT
GLCC
IFOB
IFRS
IFSC
SLSB
SLFD
|
