× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.