Products on Backorder report
Use this report to determine which products, and how many of each, are on backorder.
Options: SKUs, fulfillment centers
Sorted by: fulfillment center, SKU
Grouped by: SKU, fulfillment center
| Report Column Name | Table Name | Column Name |
|---|---|---|
| Fulfillment Center | FFMCENTDS | DISPLAYNAME |
| SKU | ITEMSPC | PARTNUMBER |
| Description | BASEITMDSC | SHORTDESCRIPTION |
| Total Number of Backorders | count(ORDERITEMS.ORDERITEMS_ID) | |
| Total Quantity on Backorder | sum(ORDERITEMS.QUANTITY) | |
| Qty Units | QTYUNITDSC | DESCRIPTION |
| Earliest Backorder Date | min(ORDERITEMS.LASTCREATE) | |
| Earliest Promise Date | min(ORDERITEMS.PROMISEDAVAILTIME + ORDERITEMS.SHIPPINGOFFSET) | |
| Earliest Estimated Date | min(ORDERITEMS.ESTAVAILTIME + ORDERITEMS.SHIPPINGOFFSET) |