Hello Experts,
I created a Sales Order (SO0427422) with a quantity of 1. Based on the reservation setup, the quantity was automatically reserved. Then after created Production Order (PR1386409) directly from the sales order line.
Following this:
After run the Report as Finished (RAF) process for that production order. As expected, the inventory transactions reflected the completed quantity in both the Physical Inventory and Available Inventory on exact dimensions columns — indicating the inventory movement was correctly recorded up to the RAF process.
Inventory transaction after RAF as below : qty is reserved against the Batch number (combination of date and Production Order No).
However, upon running the Release to Warehouse process, the system picked the quantity based on FIFO logic, and from a different production order, instead of using the quantity produced by the production order (PR1386409) that was specifically created and marked against the sales order.
Why did the system not allocate or pick inventory from the production order (PR1386409) that was directly linked to the sales order line, even though the quantity was produced and available?
Picked qty from different Batch number (here different production order No is PR1386387)
Can anyone guide me on how to resolve this issue? I need to ensure that inventory is always picked from the production order that is specifically marked to the sales order, rather than from another available batch based on FIFO.