Hello community!
we are seeking for some advice in the problem description below. Hoping that some of you could potentially lead us to a solution on how we can build in this requirement.
Purpose:
We need to be able to secure a full traceability on all our products down to the raw material (business requirement). Therefore, a production order must never be manufactured from two raw material batches, otherwise we lose traceability.
Problem: Currently there is a conflict here with the current inventory model FIFO.
2. Problem description
The inventory model FIFO should as long apply as the amount of the oldest batch number in the inventory is sufficient for the requested production order request.
As soon as a batch number is no longer quantitatively sufficient for a production order, the system should automatically choose a batch number that is sufficient.→Thus, the FIFO principle is omitted here.
If there is not any batch number on storage with enough material to manufacture the production order out of one batch number, the system should automatically create a new planned purchase order with the estimated amount. (if not defined differently in item coverage / default order settings)
Example:
How it is set up today:
When we start a production order for 50 pcs, the BOM item of the raw material creates an estimated quantity for 5.4 meters of raw material that is needed. As soon as we create a picking list for the raw material it automatically supposed to take 1.2 meters out of the batch number 620720 and 4.2 meters out of the batch number 37429. (based on the inventory model FIFO)
Our goal:
What we need is a setting that allows us to oversteer the inventory model, as soon as there is not enough material on inventory out of one batch number for a single production order. As long as we have several batches with enough inventory the system should apply the FIFO rule.
Any idea if this requirement can be fullfilled within the standard configuration?
thanks a lot for your support!
best Regards
joel
