Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

GL300


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 record types at once or each type separately.

This program creates a report showing the total number of header,
transaction, and budget lines deleted.

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:

- JE Transactions and Comments are saved in file GLTRANS

- Consolidations and Balances are saved in files GLAMOUNTS, GLUNITS,
CUAMOUNT, GLCONSOL, GLAMOUNTSX, and CUAMOUNTSX

- 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.




Updated Files

    CKPOINT    - Used for restart capability.

    CUAMOUNT   - Posting account period currency balances are deleted by this
                 program.


    CUAMOUNTX  - Updates daily report currency account balances.

    CUCONTROL  -

    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.

    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.

    GLTRANS    - Journal entry transactions are deleted by this program.

    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

    GLADDRESS  - Used by common library; not referenced in this program.

    GLCGCPY    -

    GLCHART    - Used by common library; not referenced in this program.

    GLCPYGRP   -

    GLSYSTEM   - Used to validate the company.

    WFSETUP    -


INVOKED Programs

    IFSG
    SLSB