GL195 – Translation Calculation
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 15 tables
- References
- 61 tables
GL195 (Translation Calculation) is a Lawson General Ledger batch program. It updates ADDRDATA, CKPOINT, CUACCTAU, CUCODESAU, CUCONVAU, CURELATAU, CUTABLEAU, CUTRNSLAU and 7 more and references ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 53 more.
About GL195
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 EndingHistorical, 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 thedifference 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 (15)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUACCTAU | CU Account Audit | IF |
| CUCODESAU | Currency Codes Audit | IF |
| CUCONVAU | Currency Exchange Rate Audit | IF |
| CURELATAU | Currency Relation Audit | IF |
| CUTABLEAU | Currency Table Audit | IF |
| CUTRNSLAU | Currency Translation Audit | IF |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLCONDRILL | GL Drill Around | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSYSTEMAU | GL Company Audit | IF |
| SYSTEMCODE | System Code | IF |
Referenced files (61)
| Table | Description | System |
|---|---|---|
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| AMACCTAU | Asset Account Audit | AM |
| AMACCTGPAU | Asset Account Group Audit | AM |
| AMASTTYPAU | Asset Type Audit | AM |
| AMAUGRPAU | AM Accounting Unit Group Audit | AM |
| AMDICT2 | No description in the Lawson data dictionary | AM |
| AMDIVISNAU | AM Division Audit | AM |
| AMSYSOPTAU | No description in the Lawson data dictionary | AM |
| AUMXVALUAU | AU Attribute Value Audit | IF |
| AUMXVLDTAU | AU Attribute Value Edate Audit | IF |
| CAALOCGPAU | Allocation Group Audit | GL |
| CADETAILAU | Allocation Detail Audit | GL |
| CAHEADERAU | Allocation Header Audit | GL |
| CUACCT | Currency Gain and Loss Account | IF |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUTABLE | Currency Table | IF |
| CUTRANSL | Currency Translation | IF |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBHEADERAU | Budget Header Audit | GL |
| FBHSTHDRAU | Budget Version Audit | GL |
| FBINTBUAU | Budget Interbudget Rel Audit | GL |
| FBSPREADAU | Budget Spread Code Audit | GL |
| FBTRANSAU | Budget Transactions Audit | GL |
| GLACCTREL | GL Account Relationships | IF |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCOMPREL | GL Organization Relationships | IF |
| GLCONSOL | General Ledger Consolidation | GL |
| GLESACCT | General Ledger Error Suspense | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLUNITS | General Ledger Units | GL |
| GLZONE | General Ledger Zone | GL |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLSTDTLAU | Attribute List Detail Audit | IF |
| MXLSTHDRAU | Attribute List Header Audit | IF |
| MXOBJCATAU | Attribute Object Audit | IF |
| MXTMPDTLAU | Attribute Template Dtl Audit | IF |
| MXTMPHDRAU | Attribute Template Hdr Audit | IF |
| MXTPEFDTAU | Attr Template EDate Dtl Audit | IF |
| MXTPHEDTAU | Attr Template EDate Hdr Audit | IF |
| MXVALIDAU | Attribute Validation Audit | IF |
| MXVEWDTLAU | Attribute View Detail Audit | IF |
| MXVEWHDRAU | Attribute View Header Audit | IF |
| RJMXVALUAU | Recurring JE Attr Value Audit | IF |
| TRCODES | Translation Codes | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (22)
ACAC, ACTA, API4, GLCC, GLCT, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU