Navigate To

Description

Total Inventory and Available Inventory summarized at SKU, QC Status and Reservation Pool level.

Fields

Fields Description This column can be null Sample Data
1 Client ID Internal Client ID NA 1234567
2 Client Name Name of the Client NA Increff
3 Fulfilment Location ID Internal Fulfilment Location ID NA 123456789
4 Fulfilment Location Name Name of the Fulfilment Location / warehouse NA wms_hsr
5 Increff SKU Id Increff’s Unique SKU ID NA 123456789
6 Client SKU ID / EAN client SKU ID/EAN NA abc123
7 Virtual SKU SKU is virtual or not(Yes/No) NA true/false
8 UOM SKU SKU is UOM or not(Yes/No) It can be null if the item is not part of any UOM. 123456789
9 Each Global SKU ID SKU ID of Each item if it is part of an UOM SKU It can be null if the item is not part of any UOM. 123456789
10 Each Client SKU ID Client SKU ID of Each item if it is part of an UOM SKU It can be null if the item is not part of any UOM. 123456789
11 Each Qty Quantity of Each if it is part of an UOM SKU It can be null if the item is not part of any UOM. 123
12 SKU Description Sku description NA abc345
13 Style Style NA acb345
14 color color NA abc13
15 Size Size NA abc433
16 MRP MRP NA 123.50
17 Brand Brand NA abc345
18 Category Category NA abc123
19 Reservation Pool Name of the Reservation Pool in which that item is present. NA abc123
20 Inventory QC Status QC Status of the item NA Pass/Fail
21 Total Quantity Total quantity [Qty in grn, available, recycle buckets]
Note: GRN bucket will be excluded if the location type is USP or STORE NA 123
22 Total GRN Quantity Total quantity of grned items. NA 123
23 Total Allocated Quantity Total quantity of allocated items. NA 123
24 Total Recycle + Offline Quantity Total quantity of recycled items. NA 123
25 Total Lost Quantity Total quantity of lost items. NA 123
26 Total Rejected Quantity Total rejected quantity NA 123
27 Total Available Quantity Total quantity of available items. NA 123
28 Total Permanently Lost Quantity Total quantity of permanently lost items. NA 123
29 Total Expired Quantity Total Expired quantity from the total quantity. NA 123
30 Total Each Reserved Quantity Total quantity of each reserved items. NA 123
31 Total Bulk Break Quantity Total quantity of bulk break items. NA 123
32 Total Fulfilled Quantity Total quantity fulfilled and lying the warehouse (manifested/packed) NA 123

Filters

Filters Description Limitation
1 Client Name of the client Mandatory
2 Time Zone To show data in the specified time zone Mandatory
3 Fulfilment Location Name of the Fulfilment Location Mandatory
4 QC Status Name of the QC Status Multi Select
5 Global SKU ID Global SKU ID Text
6 Style Style Text
7 EAN Client SKU ID Text
8 Virtual SKU Name of the QC Status Multi Select
9 QC Staus Name of the QC Status Multi Select

FAQs

  1. Why aren’t my all SKUs showing up in the report?
    1. All the SKUs with zero inventory in OMS (available + grn + recycle) i.e., zero in ‘Total Quantity’ column will not be shown in the report.