RE: Purging data from General Ledger files?

[bob.young@xxxxxxxxxxxx]

The same SSA Product Knowledge FAQ (OGS) entry suggests:

The files of interest would be 
GHH (Journal Entry Header file), 
GLH (Journal Entry Detail file), 
GLA (Journal Entry Analysis file), 
GNH (Journal Entry Notes file), 
GSB (General Ledger Summary Balance file), and 
GXR (Journal Entry Subsystem Cross Reference file). 

Also of note would be the 
GBH (Batch Transaction Header file), 
GBL (Batch Transaction Detail file), 
GHX (YTD Rollup Header file for FRW), and 
GSX (YTD Rollup Detail file). 

I wouldn't normally consider GCR a candidate for purge unless the chart of accounts has been completely redone.  It's not a transaction file and not normally very large.

"Wilson, Cindy" <cwilson@badgermeter.com> 03/14/2001 12:14 PM

To:        Bob Young/U/Givaudan@givaudan         cc:                 Subject:        RE: Purging data from General Ledger files?

I am currently in the process of writing a program to purge history data out of the ledger files.  My client only wants to keep last years data plus the current year.  The files that I am purging are the following:

GHH – Journal History

GLH – Journal History Line

GLA – Journal Line Analysis History File

GNH – Journal Header/Line Notes

GXR – Subsystem Cross Reference

GBH – Batch Header

GBL – Batch Line

GSB – Account Balances

GCR – Account Cross Reference

GSX – Report year-to-date Account balances

So far the only file that I am having problems with is the GCR file since I can only use the internal account number and this number is used accross periods and years which is not in the GCR file.

 -----Original Message-----
From: bob.young@givaudan.com [mailto:bob.young@givaudan.com]
Sent: Wednesday, March 14, 2001 10:46 AM
To: BPCS-L@midrange.com
Subject: Purging data from General Ledger files?


As our GXR file is approaching 3 gig and we've only been on BPCS 18 months, our system administrator is asking what can be done to reduce this size of this.

SSA Product Knowledge FAQ says "There is no reference material available as there are no programs to purge data from the CEA General Ledger files."

Does anyone have any experience with this or know a third party application that would purge or archive general ledger data?


Best Regards,

Bob Young
Givaudan
bob.young@givaudan.com