Re: ITH record purging

[Lisa.Abney@xxxxxxxxxxxxxxxxx]

While this is probably the "right" solution, I would be cautious about how
long it will take this job to run.  We just found that some "bugs" in the
purge program (version 4.05, non-CD) were keeping a large number of things
from purging correctly.  (Some of these were program problems, and some
were data problems we had introduced when we converted to BPCS 8 years
ago.)  We have modified the program so that we do our purge separate from
the month end close, so that we can do it on the weekend following close,
and still have had to break our clean-up into many weekends, to get all the
data purged that should be.  If you have a lot of records to purge, and you
are running this with users off the system at month end (as we do), your
users might not be very happy with how long this takes!  I would suggest
doing this in a test environment first, to get an idea how long it will
take.

Lisa Abney
Sensient Flavors
Indianapolis, IN



                                                                                
                                                       
                      "Charlie Borill"                                          
                                                       
                      <zborill@xxxxxxx         To:      "SSA's BPCS ERP System" 
<bpcs-l@xxxxxxxxxxxx>                                  
                      .net>                    cc:                              
                                                       
                      Sent by:                 Subject: Re: ITH record purging  
                                                       
                      bpcs-l-bounces@x                                          
                                                       
                      idrange.com                                               
                                                       
                                                                                
                                                       
                                                                                
                                                       
                      06/30/2003 09:10                                          
                                                       
                      AM                                                        
                                                       
                      Please respond                                            
                                                       
                      to "SSA's BPCS                                            
                                                       
                      ERP System"                                               
                                                       
                                                                                
                                                       
                                                                                
                                                       




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


_______________________________________________
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.