RE: INV300 History Delay

["Lacelle, Marc" <LACELLE@xxxxxxxxx>]

Hi Ho.

        Installed the pool last weekend. Got 8 inches of rain in one day.
Pool almost broke. Has not snowed in three months, so can't complain.

        Al talked about SYS800 (System settings). To be precise go to
SYS824D. 

Inventory Transactions                          500
Labor Ticket                                    90
Accounts Receivable History Transactions        90
Customer Invoice History Transactions           90

You will notice Inventory transactions set to 500 or 500 days. When running
INV903D and setting flags to delete ITH records the program will count back
500 days and purge all records greater than 500 days. Run month ends and
re-orgs where applicable. 

We have about 800,000 records in our ITH file and the response time is not
bad.  

Please note: We generate about 50,000 transactions a MONTH. Some companies
generate 50,000 in a couple of days. The setting is set to 500 for fiscal
and audit reasons. Depending on your companies needs for the history, you
could set the parm lower than 500 days.

Creating logicals is an option, but keeping base BPCS is a good idea,
specially when thinking of moving to a higher release. 

    

> ----------
> From:         Staunton,Wade[SMTP:WStaunton@burco.com]
> Reply To:     BPCS-L@midrange.com
> Sent:         Friday, June 23, 2000 11:17 AM
> To:   'bpcs-l@midrange.com'
> Subject:      INV300 History Delay
> 
> We are running v602 MM on the AS/400 v4r4.  Just in the last week or so we
> have experienced a very long delay when trying to get the history of an
> item
> when in INV300.  Each new item that we search for has the delay.  Does
> anyone have an idea as to what may have happened? What file could the
> problem be in and what could the problem be?  
> This problem has just began and no changes have been made to the BPCS
> configuration.
> 
> Thanks in advance for any assistance you can give.
> 
> Wade Staunton
> Burlington Chemical Company
> Burlington, NC  
> +---
> | 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
> +---
> 
+---
| 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
+---