GL500 – Fiscal Year Change
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 72 tables
- References
- 49 tables
GL500 (Fiscal Year Change) is a Lawson General Ledger batch program. It updates ACDETAILAU, ACHEADERAU, ADAMOUNTSX, ADAVGBAL, ADCFBAL, ADDRDATA, CAALOCGPAU, CADETAILAU and 64 more and references ACDETAIL, ACHEADER, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 41 more.
About GL500
Run Fiscal Year Change (GL500) to change the value of the current accounting period and fiscal year for your Lawson General Ledger company. All account balances, transaction history, and budget information are adjusted to correspond with the new accounting period and fiscal year. IMPORTANT You should run all financial statements and back up the database before you run this program. If your Company Budget Edit Type is Summary Group (GL10), you will have to run Budget Edit Group Rebuild (FB111) after running GL500. NOTE This program does NOT include those entries in the new Retained Earnings amount for the beginning balance. You must run GLAMOUNTS, GLUNITS (UNIX/Windows) or DBGLGAM, DBGLGLU (System i) File Rebuild (GL325) for each year to include those transaction amounts.
Updated files (72)
| Table | Description | System |
|---|---|---|
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| ADAMOUNTSX | Daily GL Amounts for ADB | AD |
| ADAVGBAL | Average Daily Balance by Date | AD |
| ADCFBAL | Cost of Funds by Date | AD |
| ADDRDATA | Address Code | IF |
| CAALOCGPAU | Allocation Group Audit | GL |
| CADETAILAU | Allocation Detail Audit | GL |
| CAHEADER | Allocation Header | GL |
| CAHEADERAU | Allocation Header Audit | GL |
| CATRANS | Allocation Transactions | 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 |
| CUTRANSL | Currency Translation | 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 |
| FBDTLHIST | Budget Detail History | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBHEADER | Budget Header | GL |
| FBHEADERAU | Budget Header Audit | GL |
| FBHISTHDR | Budget History Header | GL |
| FBHSTHDRAU | Budget Version Audit | GL |
| FBINTBUAU | Budget Interbudget Rel Audit | GL |
| FBSPREAD | Budgeting Spread Code | GL |
| FBSPREADAU | Budget Spread Code Audit | GL |
| FBTRANS | Budget Transactions | GL |
| FBTRANSAU | Budget Transactions Audit | GL |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLAMOUNTSX | General Ledger Amounts Daily | GL |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLCLSAUDIT | GL Closing Audit | GL |
| GLCNTRLAU | Journal Control Audit | GL |
| GLCODES | General Ledger Codes | IF |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLCONDRILL | GL Drill Around | GL |
| GLCONSOL | General Ledger Consolidation | GL |
| GLCONTROL | General Ledger Control | 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 |
| GLMONITOR | GL Monitor | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSYSJE | GL Company Journal Entry | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLSYSTEMAU | GL Company Audit | IF |
| GLTRANS | General Ledger Transactions | GL |
| GLTRANSFY | No description in the Lawson data dictionary | GL |
| GLUNITS | General Ledger Units | GL |
| GLUNITSX | General Ledger Units-Daily | GL |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| RJCNTRLAU | Recurring Journal Ctrl Audit | GL |
| RJCONTROL | Recurring Journal Control | GL |
| RJSCHEDULE | Recurring Journal Schedule | IF |
| SLTRANS | PL Transaction | SL |
| SLTRANSERR | PL Transaction Error | SL |
| ULPOST | This file is used to store the last posting date and time. | IF |
Referenced files (49)
| Table | Description | System |
|---|---|---|
| ACDETAIL | Cost Allocation Detail | GL |
| ACHEADER | Cost Allocation Header | GL |
| 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 |
| AUMXVALUAU | AU Attribute Value Audit | IF |
| AUMXVLDTAU | AU Attribute Value Edate Audit | IF |
| CAALLOCGRP | Allocation Group | GL |
| CADETAIL | Allocation Detail | 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 |
| FBADJCODE | No description in the Lawson data dictionary | GL |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBFUNDHDR | Budget Fund Header | GL |
| FBINTBU | Interbudget Relationship | GL |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLESACCT | General Ledger Error Suspense | IF |
| GLNAMES | General Ledger Names | IF |
| GLZONE | General Ledger Zone | GL |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLSTDTLAU | Attribute List Detail Audit | IF |
| MXLSTHDRAU | Attribute List Header Audit | 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 |
| RJMXVALUAU | Recurring JE Attr Value Audit | IF |
| SYSTEMCODE | System Code | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU