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