GL196 – Report Currency Translation
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 25 tables
- References
- 62 tables
GL196 (Report Currency Translation) is a Lawson General Ledger batch program. It updates ACDETAILAU, ACHEADERAU, ADDRDATA, CAALOCGPAU, CADETAILAU, CAHEADERAU, CKPOINT, CUACCTAU and 17 more and references ACDETAIL, ACHEADER, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 54 more.
About GL196
Run Report Currency Translation (GL196) to translate the company basecurrency and report currencies. This program compares the ending and period base currency amounts with thereport currency amounts. If there are differences between the two amounts, report currency translation updates the balances for the report currencies. For example, if the translation rate increases from 5 to 8 percent, the base currency amount is multiplied by 3 (the percentage change) to update the report currency amount. The system creates a journal entry to record the adjustments. For more information, see the Currency User Guide. **Process at a Glance The company base currency is translated using the translation table ratedefined 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 thebase currency and report currency amounts are translated. If you selected Ending or Historical, the year-to-date amounts are updated. If you selected Average, the amount for the period you select in this form is updated. If your company uses zone balancing, offset transactions are generated inyour 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 Interzone Relationships (GL30.1).
Updated files (25)
| Table | Description | System |
|---|---|---|
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| ADDRDATA | Address Code | IF |
| CAALOCGPAU | Allocation Group Audit | GL |
| CADETAILAU | Allocation Detail Audit | GL |
| CAHEADERAU | Allocation Header Audit | GL |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUACCTAU | CU Account Audit | IF |
| CUCODESAU | Currency Codes Audit | IF |
| CUCONTROL | Currency Control | GL |
| 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 |
| GLCNTRLAU | Journal Control Audit | GL |
| GLCONTROL | General Ledger Control | GL |
| GLJELOG | Journal Entry Log | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSYSJE | GL Company Journal Entry | IF |
| GLSYSTEMAU | GL Company Audit | IF |
| GLTRANS | General Ledger Transactions | GL |
| RJCNTRLAU | Recurring Journal Ctrl Audit | GL |
Referenced files (62)
| Table | Description | System |
|---|---|---|
| ACDETAIL | Cost Allocation Detail | GL |
| ACHEADER | Cost Allocation Header | 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 |
| CAALLOCGRP | Allocation Group | GL |
| CADETAIL | Allocation Detail | GL |
| CAHEADER | Allocation Header | GL |
| CUACCT | Currency Gain and Loss Account | IF |
| CUAMOUNT | Currency Amount | GL |
| 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 |
| 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 |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLESACCT | General Ledger Error Suspense | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| 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 |
| RJCONTROL | Recurring Journal Control | GL |
| RJMXVALUAU | Recurring JE Attr Value Audit | IF |
| SYSTEMCODE | System Code | IF |
| TRCODES | Translation Codes | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU