GL141 – Consolidation Unload
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 2 tables
- References
- 13 tables
GL141 (Consolidation Unload) is a Lawson General Ledger batch program. It updates ADDRDATA and CKPOINT and references CUAMOUNT, GLADDRESS, GLAMOUNTS, GLCGCPY, GLCHART, GLCONSOL, GLCPYGRP, GLMASTER and 5 more.
About GL141
Run Consolidation Unload (GL141) to consolidate financial information for a general ledger company that processes General Ledger transactions on more than one machine by transferring balances and transaction data. This process creates summarized balance information on the target machine for each posting account for a fiscal year. **Processing Effect UNIX platform: This program creates a work file of balance data. Balances come from the General Ledger Consolidation (GLCONSOL) file. Transaction data comes from the Currency Amounts (CUAMOUNT) file, General Ledger Units (GLUNITS) file, or both. If you are transferring Balance information, GL141 creates the following work file: $LAWDIR/productline/work/mastrel.csv If you are transferring Transaction information, GL141 create the following work file: $LAWDIR/productline/work/transrel.csv IMPORTANT If you choose to summarize data using GLCONSOL and you have non-base transaction amounts, these values will NOT be maintained. The transaction amount and the transaction currency will default to the base amount and base currency. If the data contains transaction currency amounts, you will want to use the level 5 posting option in the Consolidate Level field to maintain the integrity of the amounts. System i platform: This program creates a work file of balance data. Balances come from the General Ledger Consolidation (DBGLGCN) file. Transaction data comes from the Currency Amounts (DBGLCAM) file, General Ledger Units (DBGLGLU) file, or both. If you are transferring Balance information, GL141 creates the following work file: LAWDIR/productline/work/mastrel.csv If you are transferring Transaction information, GL141 create the following work file: LAWDIR/productline/work/transrel.csv IMPORTANT If you choose to summarize data using DBGLGCN and you have non-base transaction amounts, these values will NOT be maintained. The transaction amount and the transaction currency will default to the base amount and base currency. If the data contains transaction currency amounts, you will want to use the level 5 posting option in the Consolidate Level field to maintain the integrity of the amounts.
Updated files (2)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
Referenced files (13)
| Table | Description | System |
|---|---|---|
| CUAMOUNT | Currency Amount | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCONSOL | General Ledger Consolidation | GL |
| GLCPYGRP | General Ledger Company Group | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLUNITS | General Ledger Units | GL |
| INSTCTRYCD | Intrastat Country Codes | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (2)
IFOB, IFSG