GL191 – Currency Revaluation
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 23 tables
- References
- 36 tables
GL191 (Currency Revaluation) is a Lawson General Ledger batch program. It updates ACDETAILAU, ACHEADERAU, ADDRDATA, CAALOCGPAU, CADETAILAU, CAHEADERAU, CKPOINT, CUCONTROL and 15 more and references ACDETAIL, ACHEADER, AUMXVALUE, CAALLOCGRP, CADETAIL, CAHEADER, CUACCT, CUAMOUNT and 28 more.
About GL191
Run Currency Revaluation (GL191) to calculate a new Lawson General Ledger company base currency, report currency one, and report currency two balance using transaction amounts. Any difference in the current balance vs.calculated balance is posted to the unrealized gain or loss account. This program revalues amounts for all posting accounts that are defined for revaluation based on the currency exchange rates in effect. You canrevalue currency at any time, or multiple times, during a specific accounting period or within an accounting period range. An accounting period range uses the sum of multiple periods in the adjustment. For more information, see the Currency User Guide. **Processing Effect GL191 creates journal entries for the currency gain and loss accounts defined in Currency Gain Loss Accounts (CU03.1) for the transaction currency codes (From) and the company base (To) currency code.
More information: If you want to revalue report currency balances, the Currency Ledger field on Company (GL10.1) must be set to Yes during all transaction creation. If the Currency Ledger field was set to No while you used report currencies, run Currency File Rebuild (GL327) before using GL191.
Updated files (23)
| 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 | — |
| CUCONTROL | Currency Control | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| GLCNTRLAU | Journal Control Audit | GL |
| GLCONTROL | General Ledger Control | GL |
| GLJELOG | Journal Entry Log | IF |
| GLSYSJE | GL Company Journal Entry | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| MXOBJCAT | Attribute Object | IF |
| RJCNTRLAU | Recurring Journal Ctrl Audit | GL |
| SLMXVALUE | PL Attribute Value | SL |
| SLTRANDTL | No description in the Lawson data dictionary | SL |
| SLTRANS | PL Transaction | SL |
| SLTRANSERR | PL Transaction Error | SL |
Referenced files (36)
| Table | Description | System |
|---|---|---|
| ACDETAIL | Cost Allocation Detail | GL |
| ACHEADER | Cost Allocation Header | GL |
| AUMXVALUE | Acct Unit Attribute Value | 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 |
| CUTRANSL | Currency Translation | IF |
| FBDETAIL | Budget Detail | GL |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLZONE | General Ledger Zone | GL |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXVALIDATE | Attribute Validation | IF |
| RJCONTROL | Recurring Journal Control | GL |
| RWGRPDET | Report Writer Group Detail | GL |
| SYSTEMCODE | System Code | IF |
| TRCODES | Translation Codes | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (13)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSC, IFSG, IFUP, SLSE, SLSS, SLSU