There have been changes with respect to inventory exposure history. The following reports related to inventory exposure in Jasper have been affected.
Outwards : Outward Unfulfillable Orders Detail - OMS Standard Report - Affected
Following columns will be removed from this report :Last Synced Quantity,Last Sync Updated TimeandExcess Order.Outwards : Order Exposure History - CIMS Report - Removed
In order to compensate the above reports, new UI screen has been added in CIMS module named Inventory Exposure History.
Inventory Exposure History Order Wise
This report provides support to fetch last successful exposure details for the SKUs of the orders mentioned. This screen can be used by the user which is similart to Outward Unfulfillbale Orders Detail - OMS report in Jasper.
The screen takes CSV file as an input with the following details.
Parameter name | Type | Remarks |
|---|---|---|
cimsOrderId | Integer | CIMS Order ID of the order will takes as input |
Max limit of the CSV file is 500
Upon uploading, a downloadable CSV file will be returned as a response which contains the following details.
Parameter | Remarks |
|---|---|
Client ID | |
CIMS Order ID | |
Channel Order ID | |
Channel SKU ID | |
INCREFF SKU ID | |
Order Item Code | |
CIMS Order Item ID | |
Exposed Quantity | |
Consolidated Exposed Quantity | |
Expiry Date | |
Consolidated Expiry Date | |
Buffer | |
Last Synced At | |
Channel Name | |
Channel Fulfillment Location Code | |
OMS Fulfillment Location ID | |
CIMS Location ID | |
Listing ID | |
Order Creation Time | |
Excess Order |
Inventory Exposure History SKU Wise
This report provides support to fetch inventory exposure details of an SKU within the timerange mentioned across the locations chosen. This screen can be used by the user which is similar to Outwards : Order Exposure History - CIMS report in Jasper.
The screen takes CSV file as an input with the following details.
Parameter | Remarks |
|---|---|
Start Time | Time from which the exposure details are required |
End Time | Time upto which the exposure details are required |
Fulfillment Locations | |
Increff SKU ID |
The start time cannot be older than 30 days.
The difference between start time and end time must be less than or equals to 7 days.
For splittable orders, the exposure details will be shown irrespective of the location chosen.
Upon uploading, a downloadable CSV file will be returned as a response which contains the following details.
Parameter | Remarks |
|---|---|
Type | Order or Exposure |
OMS Fulfillment Location ID | |
Order / Exposure Time | |
Channel Name | |
CIMS Order Status | |
Increff SKU ID | |
Channel SKU ID | |
Exposed Quantity | |
Consolidated Exposed Quantity | |
Sync Status | |
Last Synced At | |
Buffer | |
Expiry Date | |
Consolidated Expiry Date | |
Ordered Quantity | |
Channel Order ID | |
Channel Fulfillment Location Code |