...
Provides Unfulfillable SKUs with their last unfulfillable Order details, Last Sync details and inventory stuck in Recycle, Offline and GRN state. Helps with the analysis of Unfulfillable orders.
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | Date | OMS Order Creation Date | NA | 2023-01-01 12:34:56 |
| 2 | Sales Channel | Channel through which order is placed |
| FLIPKARTV3 |
| 3 | Client Name | Name of the client | NA | Increff |
| 4 | Fulfilment Location Name | Name of fulfilment location | NA | wms_hosur |
| 5 | Channel Order ID | Order ID by channel | NA | aB12Pq34 |
| 6 | Parent Order Code | Parent Order ID from the Channel |
| abcd123 |
| 7 | CIMS Order ID | Order ID from CIMS | 212323 | |
| 8 | Global SKU ID | Increff’s unique SKU ID |
| 1234123 |
| 9 | Client SKU ID / EAN | SKU ID as per Client | NA | 1234123412 |
| 10 | Inventory Exposure Formula | 1231 | ||
| 11 | Enabled | Is enabled or not | NA | YES or NO |
| 12 | Last Unfulfillable Order | Recent Unfulfillable Order ID | NA | 1242131 |
| 13 | No of Unfulfillable Orders | Count of unfulfillable orders | NA | 432 |
| 14 | No of Unfulfillable Order Items | Number of order items unfulfillable | NA | 124 |
| 15 | No of Items in GRN Status | Distinct number of items in GRN | NA | 241 |
| 16 | No of Items in Recycle Status | Distinct number of items in RECYCLE | NA | 22 |
| 17 | Order Resolution | CUSTOMER_CANCELLED | ||
| 18 | Unfulfillable due to Bulk Break Pending | If Order is unfulfillable due to Bulk Break pending | NA | YES or NO |
| 19 | Unfulfillable Quantity | NA | 234 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Client | Name of the client | Mandatory |
| 2 | Fulfilment Locations | Name of the fulfilment locations | Mandatory |
| 3 | Sales Channel | Name of the Sales Channel | NA |
| 4 | Order Created From | Order created from the date |
|
| 5 | Order Created To | Order created till the date |