|
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. +---
As an Amazon Associate we earn from qualifying purchases.
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.