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) |