Re: Erroneous Opening Balances in ILI

From Al Macintyre 405 CD 

We occasionally get data in the different files that add up on-hand to add up 
differently, so we run some stuff on the reorg menu to get them back in sync 
with each other.  If you have out-of-sync then different inquries produce 
different results or pictures which could be misleading. 

For example, if you have a modification that writes transactions to inventory 
history that is not updating IIM last seq correctly, some inventory history 
goes invisible from INV300.  Out-of-sync most often seems to occur when 
something is driven negative, because not all BPCS software supports totals 
being driven negative.  Thus we also have some periodic queries to list what 
has gone negative & is in need of clean-up.

We also had a case of some locations being discontinued & users discovered 
BPCS will let you soft-delete a warehouse location combination which has 
inventory there, but the fact that it is soft-deleted means that other 
software does not process that inventory "correctly."

I realize this is not very helpful ... just some places to look.

>  From:    Dick_Bailey@MCFA.COM (Bailey, Dick)
>  
>   We're on 6.1 BPCS - and are finding this problem. Can anybody help
>  us figure out what to do?
>  
>   At the end of each month after running the month end summarizing of
>  inventory balances, we see erroneous opening balances. For example, on a
>  part that had no inventory (ILI) records on 1/1, and had only these
>  transactions during January:
>  
>   B transaction -1 from location P04E
>   = transaction  +1 to location P04E
>   B transaction -1 from location PICK
>   = transaction +1 to location PICK
>  
>  on 2/1 we got ILI records like these:
>  
>   Location P04E    -98
>   Location PICK    -194
>  
>  Most of the cases we have identified so far are associated with allocated
>  kit transactions like these, but there others that have taken place when
>  there is no intervening transaction at all.
>  
>   Dick Bailey
>   MCFA, Inc

Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---