GL167 – Balance Interface
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 36 tables
- References
- 63 tables
GL167 (Balance Interface) is a Lawson General Ledger batch program. It updates ACDETAILAU, ACHEADERAU, ADDRDATA, CAALOCGPAU, CADETAILAU, CAHEADERAU, CKPOINT, CUACCTAU and 28 more and references ACDETAIL, ACHEADER, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 55 more.
About GL167
Run Balance Interface (GL167) to import the balance interface file for use inthe Lawson system. **Processing Effect During the conversion process, all records are edited for errors. When a record is moved from the General Ledger Balance Interface (GLMASTREL) (UNIX/Windows) or (DBGLGMR) (System i) file to the General Ledger Amounts (GLAMOUNTS) (UNIX/Windows) or (DBGLGAM) (System i) file, the interface file is deleted, unless errors are found. Non-base currency balances of all types (transaction, amount, report currency 1 or report currency 2) are moved to the CUAMOUNT (UNIX/Windows) or DBGLCAM (System i) file. Once the program is run successfully in update mode, all periods, up to (but not including) the last period, that contain account balance amounts, will be changed to a Limited Closed status. **Troubleshooting Use GL67.1 to correct errors and rerun this program.
More information: Run Balance Interface Listing (GL267) to list data in the General Ledger Balance Interface file before running GL167.
Updated files (36)
| 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 |
| CUAMOUNT | Currency Amount | GL |
| CUAMOUNTX | Currency Amount-Daily | GL |
| 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 |
| FBFUNDAMT | Budget Fund Balance | GL |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLAMOUNTSX | General Ledger Amounts Daily | GL |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLCNTRLAU | Journal Control Audit | GL |
| GLCODES | General Ledger Codes | IF |
| GLCONSOL | General Ledger Consolidation | GL |
| GLCONTROL | General Ledger Control | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLMASTREL | GL Balance Conversion | GL |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSRCCODE | General Ledger Source Code | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLSYSTEMAU | GL Company Audit | IF |
| GLTRANS | General Ledger Transactions | GL |
| GLUNITS | General Ledger Units | GL |
| GLUNITSX | General Ledger Units-Daily | GL |
| RJCNTRLAU | Recurring Journal Ctrl Audit | GL |
| ULPOST | This file is used to store the last posting date and time. | IF |
Referenced files (63)
| 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 |
| 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 |
| FBDETAIL | Budget Detail | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | 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 |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCOMPREL | GL Organization Relationships | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLESACCT | General Ledger Error Suspense | IF |
| GLNAMES | General Ledger Names | 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 |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, IFAC, IFAU, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU