Re: Limitation to lot/location

[MacWheel99@xxxxxxx]

>  From:    MAX.Jiang@AlliedSignal.com (Jiang, Max (Suzhou Laminate))
>  
>  Dear all,
>                I'm new in BPCS world. Does anyone can tell me how to add a
>  rule to  inventory transactions:  No any Inventory transaction can make on
>  hand quantity of a  item/lot/location negative.  In BPCS my warehouse is
>  non-manage warehouse and all item have lot control.
>               Very appreciate your comments!
>  
>  Max

>From Al Macintyre

I think this is a BAD idea & in my last e-mail tried to explain why this was 
a bad idea before exploring some ideas regarding how you could deal with this 
problem ... I continue here with some more ideas.

We usually do not bother to print our JIT500 audit trail, but when we do (due 
to end user not having WS defaults set to block automatic printing), I notice 
an ocasional error message line
** Above issue for this Item causes "Negative" Location inventory 
I suggest you look at your JIT500 audit trails to see if you also have this 
pattern.
There is a PR transaction for the JIT Production Post of whatever was being 
made, then a string of CI JIT Component Issues & sometimes right after the PR 
before the CIs there is RJ JIT Production Reject ... each real transaction is 
generating a cluster of computer transactions, posting to each of the items 
involved & some of them are driven negative.

You might want to copy that report to a PC which has the slice & dice machine 
tool kit mentioned in the thread on spool downloads, in which you extract 
every PR to next PR cluster that contains one of those error messages about 
something being driven negative, or just the 2 lines immediately above the 
error message.

The 2 lines gives us the item operation date labor quantity triggers to 
explore but the  PR does a better job of pegging to where this came from.

Do you know what your company's % accuracy inventory is.  If it is not 100% 
then for the computer to occasionally show a negative is not a bug or human 
error but a reflection of other things in your system that are not 100% 
accurate, such as BOM or reporting & if you fix them, instead of the 
symptoms, then the symptoms will also go away.

Central Industries inventory is close to 99% accurate in the stock room & 
close to 90% accuracy for work-in-process.  Several years ago I had an 
employer who thought they were doing good to hit close to 50% inventory 
accuracy.

Hope you find my thoughts constructive

Al Macintyre
+---
| 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
+---