Jeremy Dean
11/17/2022, 2:53 PMDavid B
11/17/2022, 8:30 PMsalesorder, from which you can use quantityfulfilled to calculate the backordered quantity.
The trick is match the fulfillment line's orderline to the sales order's lineDavid B
11/17/2022, 8:44 PMDavid B
11/17/2022, 9:00 PMorderline and the "salesorder" line.
Fulfillments and Invoices originating from Sales Orders will have their orderline match the SO's line.
However if you're using Transfer Orders, the resulting Fulfillment and Receipt will have a 1-2-3, 4-5-6 pattern. See table/screenshotJeremy Dean
11/17/2022, 9:50 PMsuitemike
11/17/2022, 10:32 PMsuitemike
11/17/2022, 10:32 PMsuitemike
11/17/2022, 10:32 PMDavid B
11/17/2022, 10:32 PM