Inventory Status report

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

The Inventory Status report does not support the non-ATP inventory system in the HCL Commerce Accelerator tool.

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)