GL197 – Period, Year End GL Commitments Processing

System
General Ledger (GL)
Type
Batch program
Updates
88 tables
References
76 tables

GL197 (Period, Year End GL Commitments Processing) is a Lawson General Ledger batch program. It updates ACCOMMIT, ACDETAILAU, ACHEADERAU, ACMXVAL, ACTRANS, ADAMOUNTSX, ADDRDATA, AUMXVALUAU and 80 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 68 more.

About GL197

Run Period, Year End GL Commitments Processing (GL197) to roll commitment andencumbrance detail records (GLCOMMITX (UNIX/Windows) or DBGLGOX (System i)) forward to a future period. You can also run Period, Year End GL Commitments Processing (GL197) at yearend to accrue commitment and encumbrance expenses, roll the commitments and budget forward, or use the Budget Actual method. The following items explain the processing of rolling commitments andencumbrances forward: - If "As of Year" is Current and the Roll to Period is blank, all recordsfor the current year, current period and prior will roll forward to the next period. - If "As of Year" is Current and Roll to Period is specified (01-13), allrecords for the current year through the prior period will roll in the period specified. The period cannot be greater than the current period. - If "As of Year" is Prior Years and Roll to Period is blank, all recordsfor the prior years will roll forward to the next period of the current year. - If "As of Year" is Prior Years and Roll to Period is specified (01-13),all records for the prior year will roll forward to the period specified. The period cannot be greater than the current period. If your company is setup to use the Budget Actual encumbrance method (GL10),you must use GL197 for the Budget Actual method to process your year-end encumbrances. A budget journal is created that must be posted using Budget Journal Control(FB45) or Budget Double Entry Posting (FB190). NOTE: Before you run Period, Year End GL Commitment Processing (GL197) toaccrue commitment and encumbrances, you must define a commitment accrual system account on the Chart of Accounts (GL00.7). If you choose to accrue commitments and encumbrances, the system will use theaccrual account to offset the expenses from the commitment and encumbrance records and create an auto-reversing entry in the current period that debits expenditures and credits the commitment accrual account. Record dates are updated to move the amount forward and record balances are updated for the current and next year. If you choose to update the next year commitment budget, the current periodfor your company must be the last period in the year and a valid posting account must be entered in the Account field. Record dates are updated to movethe amount forward and record balances are updated for the current and next year. The budget journal must be posted using Budget Journal Control (FB45) orBudget double entry Positng (FB190). IMPORTANT You cannot accrue commitments and encumbrances and update the next year budget. In other words, you cannot choose Yes in both the Accrue Commitments, Encumbrances and Update Next Year Commitment Budget fields.

Updated files (88)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACDETAILAUCA Alloc Code Detail AuditGL
ACHEADERAUCA Alloc Code Definition AuditGL
ACMXVALAC Trans Attribute ValuesAC
ACTRANSActivity TransactionAC
ADAMOUNTSXDaily GL Amounts for ADBAD
ADDRDATAAddress CodeIF
AUMXVALUAUAU Attribute Value AuditIF
AUMXVLDTAUAU Attribute Value Edate AuditIF
CAALOCGPAUAllocation Group AuditGL
CADETAILAUAllocation Detail AuditGL
CAHEADERAUAllocation Header AuditGL
CKPOINTNo description in the Lawson data dictionary
CUACCTAUCU Account AuditIF
CUAMOUNTCurrency AmountGL
CUAMOUNTXCurrency Amount-DailyGL
CUCODESAUCurrency Codes AuditIF
CUCONTROLCurrency ControlGL
CUCONVAUCurrency Exchange Rate AuditIF
CURELATAUCurrency Relation AuditIF
CUTABLEAUCurrency Table AuditIF
CUTRNSLAUCurrency Translation AuditIF
FBADJCODAUBudget Adjustment Code AuditGL
FBBATRANSNo description in the Lawson data dictionaryGL
FBCNTRLAUBudget Journal Control AuditGL
FBCONTROLBudget Journal ControlGL
FBDETAILBudget DetailGL
FBDETAILAUBudget Detail AuditGL
FBFNDHDRAUBudget Edit Group AuditGL
FBFUNDAMTBudget Fund BalanceGL
FBHEADERBudget HeaderGL
FBHEADERAUBudget Header AuditGL
FBHSTHDRAUBudget Version AuditGL
FBINTBUAUBudget Interbudget Rel AuditGL
FBSPREADAUBudget Spread Code AuditGL
FBTRANSBudget TransactionsGL
FBTRANSAUBudget Transactions AuditGL
FBYETRNo description in the Lawson data dictionaryGL
GLACMXVLAUGL Acct Attribute Value AuditIF
GLAMOUNTSGeneral Ledger AmountsGL
GLAMOUNTSXGeneral Ledger Amounts DailyGL
GLAUTMXVAUGL AU Attribute Template AuditGL
GLCHTDTLAUChart Detail AuditIF
GLCNTRLAUJournal Control AuditGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLCONSOLGeneral Ledger ConsolidationGL
GLCONTROLGeneral Ledger ControlGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
GLJELOGJournal Entry LogIF
GLMASTERGeneral Ledger Account MasterIF
GLMASTERAUAccount Master AuditIF
GLNAMESAUGeneral Ledger Names AuditIF
GLSEGBLOCKGeneral Ledger Segment BlockGL
GLSYSJEGL Company Journal EntryIF
GLSYSTEMGeneral Ledger CompanyIF
GLSYSTEMAUGL Company AuditIF
GLTRANSGeneral Ledger TransactionsGL
GLUNITSGeneral Ledger UnitsGL
GLUNITSXGeneral Ledger Units-DailyGL
GTMXVALUAUJE Attribute Value AuditIF
GTMXVALUEAttribute Template ValueIF
JBKSEQNBRJournal Book Sequence NumberGL
MXCATDEFAUAttribute Definition AuditIF
MXELEMNTAUAttribute Element AuditIF
MXLSTDTLAUAttribute List Detail AuditIF
MXLSTHDRAUAttribute List Header AuditIF
MXOBJCATAttribute ObjectIF
MXOBJCATAUAttribute Object AuditIF
MXTMPDTLAUAttribute Template Dtl AuditIF
MXTMPHDRAUAttribute Template Hdr AuditIF
MXTPEFDTAUAttr Template EDate Dtl AuditIF
MXTPHEDTAUAttr Template EDate Hdr AuditIF
MXVALIDAUAttribute Validation AuditIF
MXVEWDTLAUAttribute View Detail AuditIF
MXVEWHDRAUAttribute View Header AuditIF
RJBRIDGERecurring Journal BridgeIF
RJCNTRLAURecurring Journal Ctrl AuditGL
RJCONTROLRecurring Journal ControlGL
RJMXVALUAURecurring JE Attr Value AuditIF
RJSCHEDULERecurring Journal ScheduleIF
SLMXVALUEPL Attribute ValueSL
SLTRANDTLNo description in the Lawson data dictionarySL
SLTRANSPL TransactionSL
SLTRANSERRPL Transaction ErrorSL
SUBCKPOINTSubledger Check PointIF
SYSTEMCODESystem CodeIF

Referenced files (76)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACBILLActivity BillingBR
ACBILLXActivity Billing DetailBR
ACBUDHDRActivity Budget HeaderAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATGRPAccount Category GroupAC
ACCATGRPXAccount Category Group DetailAC
ACCATSUMAccount Category SummaryAC
ACCATSUMXAccount Category Summ DetailAC
ACCNTRACTActivity ContractBR
ACCOMMITActivity CommitmentsAC
ACCONSOLActivity ConsolidationAC
ACDETAILCost Allocation DetailGL
ACHEADERCost Allocation HeaderGL
ACIFACTVThis file contains activity import information from AC500 (Activity Import).AC
AMACCTAUAsset Account AuditAM
AMACCTGPAUAsset Account Group AuditAM
AMASTTYPAUAsset Type AuditAM
AMAUGRPAUAM Accounting Unit Group AuditAM
AMDICT2No description in the Lawson data dictionaryAM
AMDIVISNAUAM Division AuditAM
AMSYSOPTAUNo description in the Lawson data dictionaryAM
AUMXVALDTThis file is used to store the effective date values for attribute unit attributes.IF
AUMXVALUEAcct Unit Attribute ValueIF
CAALLOCGRPAllocation GroupGL
CADETAILAllocation DetailGL
CAHEADERAllocation HeaderGL
CUACCTCurrency Gain and Loss AccountIF
CUCODESCurrency CodesIF
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
CUTABLECurrency TableIF
CUTRANSLCurrency TranslationIF
FBADJCODENo description in the Lawson data dictionaryGL
FBFUNDDTLBudget Fund DetailGL
FBFUNDHDRBudget Fund HeaderGL
FBHISTHDRBudget History HeaderGL
FBINTBUInterbudget RelationshipGL
FBSPREADBudgeting Spread CodeGL
GLACCMXVALGL Account Attribute ValueIF
GLADDRESSGeneral Ledger Company AddressIF
GLAUTMPMXVGL AU Attribute TemplateGL
GLCBODNo description in the Lawson data dictionaryGL
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCHARTSUMGeneral Ledger Chart SummaryIF
GLCODESGeneral Ledger CodesIF
GLCPYGRPGeneral Ledger Company GroupIF
GLESACCTGeneral Ledger Error SuspenseIF
GLINTCOGeneral Ledger IntercompanyIF
GLNAMESGeneral Ledger NamesIF
GLSRCCODEGeneral Ledger Source CodeIF
GLZONEGeneral Ledger ZoneGL
GMFNDACTGrant Eligible ActivitiesGM
INSTCTRYCDIntrastat Country CodesTX
MACAPDTLInvoice Distrib ConversionMA
MXCATDEFAttribute DefinitionIF
MXELEMENTAttribute ElementIF
MXLISTDTLAttribute List DetailIF
MXLISTHDRAttribute List HeaderIF
MXTMPLDTLAttribute Template DetailIF
MXTMPLEFDTAttr Template Effective DateIF
MXTMPLHDRAttribute Template HeaderIF
MXTMPLHEDTAttr Template Header DetailIF
MXVALIDATEAttribute ValidationIF
MXVIEWDTLAttribute View DetailIF
MXVIEWHDRAttribute View HeaderIF
RJMXVALUERecurring Journal Matrix ValueIF
RWGRPDETReport Writer Group DetailGL
RWUSERReport Writer UserGL
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (21)

ACAC, ACTA, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU