How can we achieve the system to combine qty for the same lot before it creates the move order?.
The Problem that we are facing currently: Multiple Lots reserved against the Ingredient line on the Batch cause Error = backflush for item xxx failed: "quantity must be less than or equal to available to transact".
In other words, if there are two reservation lines with the same batch number, item, subinv, and lot combination, we have to combine the quantities for the same lot, so that we do not get the error.
Workaround is to reserve all material manually on one lot number to ensure completion go through. How can we achieve the system to combine qty for the same lot when it creates the move order without manual intervention?