I’m trying to create a GI that shows when the quantity of an item ordered is more than available for the item.
What we currently have set up looks at individual line items and compares the line items to the qty available.
However, we have noticed that one stock item will be used for a 12 pack and a 6 pack non stock item, for example.
If someone orders both the 12 pack and the 6 pack, those show up as two separate lines items. We just experienced a situation where the whole order total should have been put on Back order, because there wasn’t enough of the single stock item, but it did not show up on this GI because neither line item by itself was more than the qty available.
Does anyone have any suggestions on how to get this condition to look at the whole order, but still specific items?