RE: MONTH END INVENTORY CLOSE

We had a similar problem here due to the processing time of month end, We
found out that the report that runs before processing is not used by our
users (IN056) so we removed it from the month end routine. We also changed
the jobq when XA902 is called so that this job gets more prioritized
execution.
These changes helped us a lot in reducing the processing time. This is
something you can also look into. We have not made any changes to IN024 at
this time.


Ram S. Hari
Sr. Programmer/Analyst
mailto:ramhari@wasserstrom.com
Voice 614.228.6525 Ext. 8392
Fax    253.484.5806

 -----Original Message-----
From:   Heffner, Art [mailto:AHeffne@PTS-TOOLS.COM] 
Sent:   Thursday, March 15, 2001 2:03 PM
To:     jbausers
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.
+---