× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. BPCS-L
  3. March 2001

RE: Purging data from General Ledger files?


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


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.