That is a good solution.  The month end process will purge the transactions
to the YTH file and resequence the sequence number in the ITH record and
reset the last sequence number in the IIM.

If you have more than 99,999 transactions in the file for the same item this
will cause a duplicate sequence number resulting in a looping of INV300.

Charlie Borill
Richmond, Va.

----- Original Message ----- 
From: "Rob Stagis" <stagis@xxxxxxxxxxxxxxxxxxxx>
To: "'SSA's BPCS ERP System'" <bpcs-l@xxxxxxxxxxxx>
Sent: Monday, June 30, 2003 9:46 AM
Subject: RE: ITH record purging


> My opinion - set the purge date on your SYS setup to 2 years' worth and
run
> month-end.  I'm almost positive that's when BPCS will clear you up.....
>
> -----Original Message-----
> From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]On
> Behalf Of ERP/BPCS
> Sent: Monday, June 30, 2003 9:18 AM
> To: bpcs-l@xxxxxxxxxxxx
> Subject: ITH record purging
>
>
> Hello All,
>
> We are on BPCS V 6.1.01 (mixed Mode), AS/400.
>
> Our ITH file is populated with the data of more than 5
> years. We want to keep only 2 years data in ITH.
>
> If i simply delete all ITH records with date more than
> 2 years old, will there be any problem for any program
> because transaction sequence# from 1 will be deleted.
> ?? Or any problem in the data ??
>
> Or Please suggest any better other way to clean ITH
> file.
>
> Thanks for your help.....
>
> Jim
>
>
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.