Re: Problem transferring account balances for new year

["Paul Holstein" <holstein13@xxxxxxxxxxx>]

Anthony,

CEA971 will not work in his case.  CEA971 first looks at GLH and sums up the 
debits and credits per IAN.  If there are no records in GLH for a particular 
year and period, there will be no IANs and consequently, no change to GSB.

Therefore, GSB will have to be selectively purged manually.

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


----Original Message Follows----
From: ANTHONY_JACKSON@dcsgroup.co.uk
Reply-To: BPCS-L@midrange.com
To: BPCS-L@midrange.com
Subject: Re: Problem transferring account balances for new year



you will also need to run cea970 after records archived/deleted..
pgm will read glh ect...and update gsb with correct totals.




"Wayne Sheehan" <wayne.sheehan@powerbar.com> on 02022000 14:50:00

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:    (bcc: Anthony Jackson/North/CSI)

Subject:  Re: Problem transferring account balances for new year




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

TONY JACKSON
BPCS Support
DCS Industry Solutions
Caledonia  House,          Office  :         +44  (0) 113 2043300        
Email :
          ANTHONY_JACKSON@dcsgroup.co.uk
Lawnswood  Business  Park,  Facsimile  :    +44  (0)  113 2043333     Web 
Site :
www.dcsgroup.co.uk
Leeds, LS16 6QY          Mobile :
United Kingdom.
The information contained in this electronic mail message is confidential. 
It is
intended  solely for the use of the individual or entity to whom it is 
addressed
and  others  authorised  to receive it. If the reader of this message is not 
the
intended recipient, you are hereby notified that any use, copying, 
dissemination
or disclosure of this information is strictly prohibited.







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