Inventory Status report

Use this report to review the current inventory allocation and receipt status of products in stock.

Options: SKUs, fulfillment centers

Sorted by: SKU

Grouped by: fulfillment center, SKU

Report Column Name	Table Name	Column Name
SKU	ITEMSPC	PARTNUMBER
Description	BASEITMDSC	SHORTDESCRIPTION
Fulfillment Center	FFMCENTDS	DISPLAYNAME
Qty Units	QTYUNITDSC	DESCRIPTION
Qty On Site	sum(RECEIPT.QTYONHAND + RECEIPT.QTYINKITS)
Qty In Process	sum(RECEIPT.QTYINPROCESS)
Qty Reserved	ITEMFFMCTR	QTYRESERVED
Qty Orderable	sum(RECEIPT.QTYONHAND - RECEIPT.QTYINPROCESS) - (ITEMFFMCTR.QTYRESERVED + ITEMFFMCTR.QTYALLOCBACKORDER)
Qty Allocated to Backorder	ITEMFFMCTR	QTYALLOCBACKORDER
Qty on Backorder	ITEMFFMCTR	QTYBACKORDERED
Last Receipt Date	max(RECEIPT.RECEIPTDATE)

Related concepts

Operational reports