GL320 – Consolidation File Creation

System
General Ledger (GL)
Type
Batch program
Updates
4 tables
References
12 tables

GL320 (Consolidation File Creation) is a Lawson General Ledger batch program. It updates ADDRDATA, CKPOINT, GLCONSOL and ULPOST and references CUAMOUNT, FBDETAIL, FBHEADER, GLADDRESS, GLAMOUNTS, GLCGCPY, GLCHART, GLCPYGRP and 4 more.

About GL320

Run Consolidation File Creation (GL320) to build the consolidation file that is used by General Ledger Report Writer and other related modules. The GLCONSOL (UNIX/Windows) or DBGLGCN (System i) file is maintained automatically by the Lawson General Ledger system. This program is provided for use in the event of unusual circumstances. This program prints a report giving you the following: - The total GLMASTER (UNIX/Windows) or DBIFGLM (System i) records processed,the total GLCONSOL (UNIX/Windows) or DBGLGCN (System i) records created. - The total GLUNITS (UNIX/Windows) or DBGLGLU (System i) records processed,the total GLCONSOL (UNIX/Windows) or DBGLGCN (System i) records created. - The total FBDETAIL (UNIX/Windows) or DBGLFBD (System i) records processed,the total GLCONSOL (UNIX/Windows) or DBGLGCN (System i) records created. - The total CUAMOUNT (UNIX/Windows) or DBGLCAM (System i) records processed,and number resulting GLCONSOL (UNIX/Windows) or DBGLGCN (System i) records. You must have at least one detail account set up within the company you enter. The time needed to run this program depends on the number of accounts and budgets a company has. The program runs faster if you run it for a budget or amount type.

Updated files (4)

TableDescriptionSystem
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary—
GLCONSOLGeneral Ledger ConsolidationGL
ULPOSTThis file is used to store the last posting date and time.IF

Referenced files (12)

TableDescriptionSystem
CUAMOUNTCurrency AmountGL
FBDETAILBudget DetailGL
FBHEADERBudget HeaderGL
GLADDRESSGeneral Ledger Company AddressIF
GLAMOUNTSGeneral Ledger AmountsGL
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCPYGRPGeneral Ledger Company GroupIF
GLSYSTEMGeneral Ledger CompanyIF
GLUNITSGeneral Ledger UnitsGL
INSTCTRYCDIntrastat Country CodesTX
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (2)

IFOB, IFSG