Navigate To:

Description

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

Fields

Fields Description This column can be null Sample Data
1 Client ID Internal Client ID NA 7948592145
2 Fulfillment Location ID Internal ID of Fulfillment Location NA 8765432265
3 Internal Batch ID Internal Batch ID NA 5678969634
4 External Batch ID External Batch ID NA abcd123
5 Increff SKU ID Increff’s Unique SKU ID NA 8978674657
6 Client SKU ID / EAN Client’s SKU ID / EAN NA abcd123
7 Manufacturing Date Timestamp of Manufacture NA 2023-01-01 00:00:00
8 Expiry Date Timestamp of Expiry NA 2023-01-01 00:00:00
9 Virtual SKU Where the SKU is Virtual or Not NA 0 or 1
10 UOM SKU Whether the SKU is a UOM or Not It can be null if the item is not part of any UOM. 0 or 1
11 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. 7648765786
12 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
13 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
14 Style Style of the SKU If not defined or mapped acb345
15 Color Color of the SKU If not defined or mapped Black
16 Size Size of the item If not defined or mapped XL
17 MRP MRP of the SKU If not defined or mapped 999
18 Brand Brand of the SKU If not defined or mapped abcd
19 SKU Description Description of the SKU If not provided Custom Input
20 Inventory QC Status QC Status of the Inventory NA PASS or FAIL
21 Reservation Pool Name of the Reservation Pool NA abcd123
22 Total Quantity Total Quantity
[Available + GRN + Recycle] NA 6345
23 Total Available Quantity Total Available Quantity
[Available - Lost - Allocated] NA 459
24 Total Allocated Quantity Total Allocated Quantity NA 634
25 Total GRN Quantity Total GRN Quantity NA 634
26 Total Recycle + Offline Quantity Total Recycle + Offline Quantity NA 634
27 Total Lost Quantity Total Lost Quantity NA 634
28 Total Permanently Lost Quantity Total Permanently Lost Quantity NA 634
29 Total Each Reserved Quantity Total Each Reserved Quantity NA 634
30 Total Bulk Break Quantity Total Bulk Break Quantity NA 634

Filters

Filters Description Limitation
1 Fulfilment Locations Name of the fulfilment locations Mandatory
2 Client Name of the client Mandatory
3 Reservation Pool Reservation Pool NA
4 QC Status QC Status of the Item NA
5 Global SKU ID Increff’s Unique SKU ID NA
6 Style Style of the SKU NA
7 EAN Client SKU ID / EAN NA
8 Batch ID Internal Batch ID NA
9 External Batch ID External Batch ID NA