Re: Problem transferring account balances for new year

Wayne brings up a great point here.  The GSB file contains summary debits 
and credits for the period only.  Therefore, you can delete any whole years 
you want without affecting any other year.

Of course, you have to be careful not to delete partial years.  If you 
delete certain periods within a year, the entire year will be inaccurate.

I assumed by your previous post that you would purge out data for an entire 
fiscal year.

--Paul Holstein
iWork Software, L.L.C.


----Original Message Follows----
From: "Wayne Sheehan" <wayne.sheehan@powerbar.com>
Reply-To: BPCS-L@midrange.com
To: BPCS-L@midrange.com
Subject: Re: Problem transferring account balances for new year
Date: Wed, 02 Feb 2000 06:50:00 -0800

You will need to be careful when purging these records from the GHH/GLH/GLA
tables as these are summed up in the Balances table (GSB). You can certainly
delete the old records, but you will have a problem if you ever want to get
detail to old account balances or use account inquiry to drill down on old
balances, etc.

Regards,
Wayne Sheehan

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---