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