Our customer places multiple orders for multiple SKUs, through the year. An SKU may appear in more than one order.
The quantities produced of each SKU, do not match the ordered quantities (whether from a single order, or cumulated from 2 or more orders). We may produce more or less than ordered quantities, depending on other production related issues.
As a result, the quantities dispatched do not necessarily match the total quantities due on each SKU (i.e. quantities due from previous orders + quantities in new order).
How do I automatically reduce the “yet to be fulfilled” quantity of each SKU in each order, as and when SKUs are dispatched? I have tried to illustrate this through the image below.
Please note that, production quantities are only shown to illustrate the differences between ordered quantities and produced quantities… ultimately, only the dispatched quantities are compared with the reducing balance of orders, to determine, what quantities are still due for fulfillment.