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)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| ACMXVAL | AC Trans Attribute Values | AC |
| ACTRANS | Activity Transaction | AC |
| ADAMOUNTSX | Daily GL Amounts for ADB | AD |
| ADDRDATA | Address Code | IF |
| AUMXVALUAU | AU Attribute Value Audit | IF |
| AUMXVLDTAU | AU Attribute Value Edate Audit | 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 |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBBATRANS | No description in the Lawson data dictionary | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBCONTROL | Budget Journal Control | GL |
| FBDETAIL | Budget Detail | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBFUNDAMT | Budget Fund Balance | 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 |
| FBTRANS | Budget Transactions | GL |
| FBTRANSAU | Budget Transactions Audit | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLAMOUNTSX | General Ledger Amounts Daily | GL |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLCNTRLAU | Journal Control Audit | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLCONSOL | General Ledger Consolidation | GL |
| GLCONTROL | General Ledger Control | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GLJELOG | Journal Entry Log | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSEGBLOCK | General Ledger Segment Block | GL |
| GLSYSJE | GL Company Journal Entry | 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 |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| GTMXVALUE | Attribute Template Value | IF |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLSTDTLAU | Attribute List Detail Audit | IF |
| MXLSTHDRAU | Attribute List Header Audit | IF |
| MXOBJCAT | Attribute Object | 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 |
| RJBRIDGE | Recurring Journal Bridge | IF |
| RJCNTRLAU | Recurring Journal Ctrl Audit | GL |
| RJCONTROL | Recurring Journal Control | GL |
| RJMXVALUAU | Recurring JE Attr Value Audit | IF |
| RJSCHEDULE | Recurring Journal Schedule | IF |
| SLMXVALUE | PL Attribute Value | SL |
| SLTRANDTL | No description in the Lawson data dictionary | SL |
| SLTRANS | PL Transaction | SL |
| SLTRANSERR | PL Transaction Error | SL |
| SUBCKPOINT | Subledger Check Point | IF |
| SYSTEMCODE | System Code | IF |
Referenced files (76)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCOMMIT | Activity Commitments | AC |
| ACCONSOL | Activity Consolidation | AC |
| ACDETAIL | Cost Allocation Detail | GL |
| ACHEADER | Cost Allocation Header | GL |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| 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 |
| AUMXVALDT | This file is used to store the effective date values for attribute unit attributes. | IF |
| AUMXVALUE | Acct Unit Attribute Value | 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 |
| FBADJCODE | No description in the Lawson data dictionary | GL |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBFUNDHDR | Budget Fund Header | GL |
| FBHISTHDR | Budget History Header | GL |
| FBINTBU | Interbudget Relationship | GL |
| FBSPREAD | Budgeting Spread Code | GL |
| GLACCMXVAL | GL Account Attribute Value | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAUTMPMXV | GL AU Attribute Template | GL |
| GLCBOD | No description in the Lawson data dictionary | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLESACCT | General Ledger Error Suspense | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLNAMES | General Ledger Names | IF |
| GLSRCCODE | General Ledger Source Code | IF |
| GLZONE | General Ledger Zone | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXTMPLDTL | Attribute Template Detail | IF |
| MXTMPLEFDT | Attr Template Effective Date | IF |
| MXTMPLHDR | Attribute Template Header | IF |
| MXTMPLHEDT | Attr Template Header Detail | IF |
| MXVALIDATE | Attribute Validation | IF |
| MXVIEWDTL | Attribute View Detail | IF |
| MXVIEWHDR | Attribute View Header | IF |
| RJMXVALUE | Recurring Journal Matrix Value | IF |
| RWGRPDET | Report Writer Group Detail | GL |
| RWUSER | Report Writer User | GL |
| WFSETUP | No description in the Lawson data dictionary | WF |
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