|
|
GL300 - General Ledger History Delete
**Form Purpose
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 your Company Budget Edit Type is Summary Group (GL10), you will have to
run Budget Edit Group Rebuild (FB111) after running GL300.
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 iSeries 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
ADDRDATA -
CKPOINT - Used for restart capability.
CUAMOUNT - Posting account period currency balances are deleted by this
program.
CUAMOUNTX - Updates daily report currency account balances.
CUCONTROL -
FBCONTROL -
FBDETAIL - Posting account budget period balances are deleted by this
program.
FBDTLHIST - This file stores the budget detail version information.
FBHEADER - Year budgets are deleted by this program
FBHISTHDR - This file stores the budget header information for a version.
FBTRANS -
GLAMOUNTS - Posting account period balances are deleted by this program.
GLAMOUNTSX - The General Ledger Amounts-Daily file contains daily account
balances by accounting unit, account, and subaccount for the
date specified.
GLCONSOL - Consolidated account period balances are deleted by this
program.
GLCONTROL - Journal entries are deleted by this program.
GLSEGBLOCK -
GLUNITS - Posting account period unit balances are deleted by this
program.
GTMXVALUE - Journal entry transaction attribute values are deleted by this
program.
MXOBJCAT - Attribute usage counts are updated to reflect deleted
attribute values.
Referenced Files
CUCONTROL -
GLADDRESS - Used by common library; not referenced in this program.
GLCGCPY -
GLCHART - Used by common library; not referenced in this program.
GLCPYGRP -
GLSEGBLOCK -
GLSYSTEM - Used to validate the company.
GLTRANS - Journal entry transactions are deleted by this program.
INSTCTRYCD -
WFSETUP -
INVOKED Programs
IFOB
IFSG
|
