Deleting General Ledger history

Note: You cannot inquire or report on information you delete.

You can delete historical journal entry transactions, comments, consolidation records, budgets and historical commitment records for a fiscal year. Deleted records are removed from General Ledger database files and are archived to a comma-separated value (CSV) file if the Archive Records field is set to Yes. General Ledger history must be at least two years old before you can delete it. Use this procedure to delete all record types at the same time or to delete each record type separately.

Note: For faster report run times, run GL300 with only one delete option at a time.

Run General Ledger History Delete (GL300). Use these guidelines to specify the field values:

Fiscal Year: Specify the fiscal year for which you are deleting journal entry transactions and comments, consolidations and balances, budgets, or historical commitments. You cannot delete current year or future year transactions. You also cannot delete last year transactions until last year is final closed.
Archive Records: Select whether to archive records in a CSV file. The default setting is No.
Budgets: Specify the range of budgets that you want to delete, or leave the Budgets fields blank to delete all budgets within the fiscal year selected.

Note: GL300 creates a report showing the total number of header, transaction, and budget lines deleted.

Files updated by General Ledger History Delete (GL300)

These files are updated when you delete General Ledger history using General Ledger History Delete (GL300).


File	File name
Currency Amount	CUAMOUNT (for UNIX/Windows) DBGLCAM (for IBMi)
Budgeting Detail	FBDETAIL (for UNIX/Windows) DBGLFBD (for IBMi)
Budgeting Header	FBHEADER (for UNIX/Windows) DBGLFBH (for IBMi)
FB Control Records	FBCONTROL (for UNIX/Windows) DBGLFLC (for IBMi)
FB Transaction Records	FBTRANS (for UNIX/Windows) DBGLFLT (for IBMi)
General Ledger Amounts	GLAMOUNTS (for UNIX/Windows) DBGLGAM (for IBMi)
General Ledger Consolidation	GLCONSOL (for UNIX/Windows) DBGLGCN (for IBMi)
General Ledger Control	GLCONTROL (for UNIX/Windows) DBGLGLC (for IBMi)
General Ledger Transactions	GLTRANS (for UNIX/Windows) DBGLGLT (for IBMi)
General Ledger Units	GLUNITS (for UNIX/Windows) DBGLGLU (for IBMi)
Attribute Template Value	GTMXVALUE (for UNIX/Windows) DBIFGMV (for IBMi)
Attribute Object	MXOBJCAT (for UNIX/Windows) DBIFMOC (for IBMi)
Historical Commitment Records	GLHISCOMX