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)

Related concepts

Operational reports