Inventory Available for Sales - OMS
- Prakash Nagulapati
Navigate To
- 1 Description
- 2 FieldsÂ
- 3 Filters
- 4 FAQs
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
Why aren’t my all SKUs showing up in the report?
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.
Â
Â