RE: MONTH END INVENTORY CLOSE

[Chris Tringham <chris.tringham@xxxxxxxxxxx>]

The logic of reading INP95 records after the month-end to reverse them out
does make sense, but I agree that it may not be very efficient.
Unfortunately a lot of SQL was put into System21 without anyone considering
the performance implications, and some has subsequently been taken out
again.  

If you did make any changes to this routine, then the month-end report
(IN056?) may not work properly if you run the inventory month-end after
entering any transactions for the following month (based on the inventory
calendar).  I am not sure what else uses the starting period balance. 

> -----Original Message-----
> From: Heffner, Art [SMTP:AHeffne@PTS-TOOLS.COM]
> Sent: Friday, March 16, 2001 3:03 AM
> 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.
+---