AM-I  Consolidate General Ledger Detail

Purpose of Program

Use this program to condense ranges of GL transaction records into single, summarized records.  This is used typically for certain GL accounts, such as payroll postings, in which several GL accounts are typically posted to for each employee.  A large payroll could generate thousands of detail records.  If you don't want this much detail showing up in your Detailed Trial Balance or GL journals, use this program to consolidate the detail.

You can also use AM-I to rid the General Ledger transaction file (BKGLTRAN.B*) of needless detail without actually purging valuable information.  For example, if you no longer need detail beyond two years, run this program and consolidate your two years and older detail into summary data.  It is strongly suggested you make a backup of your system before running this program.

The consolidation will result in a single record per GL account for each journal type within each fiscal month (as defined in AM-N Maintain GL Fiscal Periods within the date range specified.

General Program Operation

Enter a from/thru date range and from/thru ranges of GL accounts to consolidate.  Finally, you can limit by Journal type such as PR (payroll) or WO (Work Order).   The consolidation could take a while to run, depending on how many records are involved.

Audit Data

Beginning with the IS Tech Support July 16, 2004 update, each GL Transaction is saved with a time stamp and, for users running Evo-ERP, the User login ID of the person generating the transaction.  Running this program to consolidate the transaction detail will delete this audit detail as well.