GL299 – GL and AC History commitment
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 9 tables
- References
- 60 tables
GL299 (GL and AC History commitment) is a Lawson General Ledger batch program. It updates ACASNROLE, ADDRDATA, CKPOINT, FBTRANS, GLTRANS, MXLISTHDR, MXLISTMBR, RATOTALS and 1 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE and 52 more.
About GL299
Run GL Commitment Analysis Report (GL299) to print a report that summarizes accounting unit commitments and encumbrances and to view remaining budget amounts or to view detailed encumbrance and actualinformation. Commitments and encumbrances are transactions released in other Lawson applications, but not yet posted to General Ledger. They include purchase orders and payables not yet distributed among General Ledger accounts and unposted General Ledger and subledger transactions. Use the Main page to select the company, company group, or budget edit groupand the year and period you wish to report on. You may choose a specific system code to include in the Commitment Detail (B) and Actuals Detail (C) report types. Use the Organization Options page to further define the organization andaccount parameters for the report. Use the Output Options page to define the print parameters for the report andto indicate whether to include company and report totals.
Updated files (9)
| Table | Description | System |
|---|---|---|
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| FBTRANS | Budget Transactions | GL |
| GLTRANS | General Ledger Transactions | GL |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| RATOTALS | Ratio Totals | GL |
| ULTOTALS | No description in the Lawson data dictionary | GL |
Referenced files (60)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACACTMXVAL | Activity List Attribute Values | AC |
| ACADDLCNTR | Additional Contract Info | BR |
| ACAMCODE | Activity Asset | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACASSIGN | Activity Resource Assignment | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATMXVAL | No description in the Lawson data dictionary | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSTATUS | Activity Status | AC |
| CUCODES | Currency Codes | IF |
| FBBATRANS | No description in the Lawson data dictionary | GL |
| FBCONTROL | Budget Journal Control | GL |
| FBDETAIL | Budget Detail | GL |
| FBFUNDHDR | Budget Fund Header | GL |
| FBHEADER | Budget Header | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCOMMITX | GL commitment Detail | GL |
| GLCONTROL | General Ledger Control | GL |
| GLCPYGRP | General Ledger Company Group | IF |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMAWARD | Grant Management Award | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| MXVIEWDTL | Attribute View Detail | IF |
| MXVIEWHDR | Attribute View Header | IF |
| RWGRPDET | Report Writer Group Detail | GL |
| RWHEADER | Report Writer Header | GL |
| RWROWDET | RW Row File Detail | GL |
| STRUCTURE | Category Structure | AC |
| ULPOST | This file is used to store the last posting date and time. | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (10)
ACSR, GLAC, GLBL, GLRV, GLSC, GLSR, IFOB, IFSG, IFUP, MLRV