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