I have multiple product codes that need to be used up in production, but i need to use them up by batch first.
So...
Raw Material X all of same type (substitutable)
Code QTY
001 100
002 300
003 100
004 500
005 700 etc.
WIP Usage of material X
W1011 Uses 120 X, therefore needs 100 of Code 001 and 20 of code 002
W1012 Uses 20 x, therefore needs 20 of code 002 since code 001 has been used
W1013 Uses 300 X, therefore need balance of 002 (280) and 20 of 003...
I need something that can compute this usage.
Bookmarks