GL300 – General Ledger History Delete

System
General Ledger (GL)
Type
Batch program
Updates
37 tables
References
21 tables

GL300 (General Ledger History Delete) is a Lawson General Ledger batch program. It updates ACDETAILAU, ACHEADERAU, ADDRDATA, CAALOCGPAU, CADETAILAU, CAHEADERAU, CKPOINT, CUAMOUNT and 29 more and references ACDETAIL, ACHEADER, CAALLOCGRP, CADETAIL, CAHEADER, CUCONTROL, FBADJCODE, FBFUNDHDR and 13 more.

About GL300

Run General Ledger History Delete (GL300) to delete historical journal entry transactions, comments, consolidation records, and budgets for a fiscal year. General Ledger history must be at least two years old before this program deletes it. You can delete all budgets for a year, or a range of budgets. This program creates a report showing the total number of header, transaction, and budget lines deleted. If the Archive Records is Yes, deleted records are removed from the General Ledger database and archived in a comma separated value (CSV) file as follows: For UNIX/Windows platforms: - JE Transactions and Comments are saved in file GLTRANS - Consolidations and Balances are saved in files GLAMOUNTS, GLUNITS,CUAMOUNT, GLCONSOL, GLAMOUNTSX, and CUAMOUNTX - Budgets are saved in files FBDETAIL and FBDTLHIST WARNING This program permanently deletes data. Before you run this program, back up your data according to your organization's procedures. Before you submit the report, carefully review the parameters. For System i platform: - JE Transactions and Comments are saved in file DBGLGLT - Consolidations and Balances are saved in files DBGLGAM, DBGLGLU, DBGLCAM,DBGLGCN, DBGLGAX, and DBGLCAX - Budgets are saved in files DBGLFBD and DBGLFDH WARNING This program permanently deletes data. Before you run this program, back up your data according to your organization's procedures. Before you submit the report, carefully review the parameters.

Updated files (37)

TableDescriptionSystem
ACDETAILAUCA Alloc Code Detail AuditGL
ACHEADERAUCA Alloc Code Definition AuditGL
ADDRDATAAddress CodeIF
CAALOCGPAUAllocation Group AuditGL
CADETAILAUAllocation Detail AuditGL
CAHEADERAUAllocation Header AuditGL
CKPOINTNo description in the Lawson data dictionary
CUAMOUNTCurrency AmountGL
CUAMOUNTXCurrency Amount-DailyGL
CUCONTROLCurrency ControlGL
FBADJCODAUBudget Adjustment Code AuditGL
FBBATRANSNo description in the Lawson data dictionaryGL
FBCNTRLAUBudget Journal Control AuditGL
FBCONTROLBudget Journal ControlGL
FBDETAILBudget DetailGL
FBDETAILAUBudget Detail AuditGL
FBDTLHISTBudget Detail HistoryGL
FBFNDHDRAUBudget Edit Group AuditGL
FBHEADERBudget HeaderGL
FBHEADERAUBudget Header AuditGL
FBHISTHDRBudget History HeaderGL
FBHSTHDRAUBudget Version AuditGL
FBINTBUAUBudget Interbudget Rel AuditGL
FBSPREADAUBudget Spread Code AuditGL
FBTRANSBudget TransactionsGL
FBTRANSAUBudget Transactions AuditGL
GLAMOUNTSGeneral Ledger AmountsGL
GLAMOUNTSXGeneral Ledger Amounts DailyGL
GLCNTRLAUJournal Control AuditGL
GLCONSOLGeneral Ledger ConsolidationGL
GLCONTROLGeneral Ledger ControlGL
GLHISCOMXNo description in the Lawson data dictionaryGL
GLSEGBLOCKGeneral Ledger Segment BlockGL
GLUNITSGeneral Ledger UnitsGL
GTMXVALUEAttribute Template ValueIF
MXOBJCATAttribute ObjectIF
RJCNTRLAURecurring Journal Ctrl AuditGL

Referenced files (21)

TableDescriptionSystem
ACDETAILCost Allocation DetailGL
ACHEADERCost Allocation HeaderGL
CAALLOCGRPAllocation GroupGL
CADETAILAllocation DetailGL
CAHEADERAllocation HeaderGL
CUCONTROLCurrency ControlGL
FBADJCODENo description in the Lawson data dictionaryGL
FBFUNDHDRBudget Fund HeaderGL
FBINTBUInterbudget RelationshipGL
FBSPREADBudgeting Spread CodeGL
GLADDRESSGeneral Ledger Company AddressIF
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCPYGRPGeneral Ledger Company GroupIF
GLSEGBLOCKGeneral Ledger Segment BlockGL
GLSYSTEMGeneral Ledger CompanyIF
GLTRANSGeneral Ledger TransactionsGL
INSTCTRYCDIntrastat Country CodesTX
RJCONTROLRecurring Journal ControlGL
SYSTEMCODESystem CodeIF
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (2)

IFOB, IFSG