Re: MONTH END INVENTORY CLOSE -- SYSTEM21

Can you define "...appropriate logical file..."???
Thank you.




"Bruce Stern" <sternb@home.com> on 04/08/2001 11:13:46 AM

Please respond to JBAUSERS-L@midrange.com
                                                              
                                                              
                                                              
  To:          JBAUSERS-L@midrange.com                        
                                                              
  cc:          (bcc: Jeff Klipa/Harvard)                      
                                                              
                                                              
                                                              
  Subject      Re: MONTH END INVENTORY CLOSE                  
  :                                                           
                                                              






We had a similar problem crop up suddenly where what was a 30-45 minute
process suddenly took hours.  We discovered that by recompiling the
appropriate logical file (which the SQL query "finds" if it is available)
we
were able to get back to more normal processing times.  After that worked
we
then cleaned up INP95 itself by SQLing out old records and doing a reorg.
These actions put month end processing time back into an acceptable (read
short) range.

Best,

Bruce Stern
sternb@home.com

----- Original Message -----
From: "Heffner, Art" <AHeffne@PTS-TOOLS.COM>
To: "jbausers" <jbausers-l@midrange.com>
Sent: Thursday, March 15, 2001 3:02 PM
Subject: MONTH END INVENTORY CLOSE


Our month end inventory run is extremely slow.  I was looking at program
IN024 to see if I could speed it up.  I noticed that it runs a subroutine
named BAKOUT for each item/stockroom.  This executes an SQL open of INP95,
reads all postings made for that item/stockroom after the month end, backs
them out of the starting period balance, and closes INP95.

Since we have to run the month end close the last day of the month because
of G/L considerations,  I don't see any purpose in doing this routine.
Also, opening and closing the file for each item seems extremely
inefficient.

Having been burned before when I thought there was no good reason for
something,  I would like the groups comments in case my analysis is wrong.

Art Heffner
Production Tool Supply


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

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



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