There have been internal architectural changes with respect to storing inventory exposure history. The following reports related to inventory exposure in Jasper Omni Reporting have been affectedupdated.
Outwards : Outward Unfulfillable Orders Detail - OMS Standard Report - Affected
Following columns will be The following columns have been removed from this report:Last Synced Quantity,Last Sync Updated TimeandExcess Order.Outwards : Order Exposure History - CIMS Report - Removed
...
This report has been removed.
Instead of using the above reports, a new UI screen has been added in the CIMS module named Inventory Exposure History.
...
Inventory exposure history screens will have below tabs:
Order Wise
SKU Wise
Inventory Exposure History Order Wise
This report screen provides support to fetch the 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 Jasperset of orders.
...
The screen takes a CSV file as an input with the following details.
...
| Info |
|---|
Max limit of the CSV file is 500 |
- How to get the Cims Order Id to upload in this file? Ganesh KVKS (Unlicensed) Please suggest.
Upon uploading, a downloadable CSV file will be returned as a response which contains the following details. This data can be used by the user as a substitute for the removed data from the Outward Unfulfillbale Orders Detail - OMS report in the Omni Reporting tool.
Parameter | Remarks |
|---|---|
Client ID | Client Id for the client entity for which order is received. |
CIMS Order ID | Order Id for CIMS module |
Channel Order ID | Channel Order ID represents the Order Id present at marketplace/ ERP. |
Channel SKU IDINCREFF SKU ID | Channel SKU ID represents the SKU Id present at marketplace/ ERP. |
Increff SKU ID | Increff SKU ID represents the unique ID generated at Increff against the Client SKU during master upload. |
Order Item Code | It represents the unique identifier for the order line items(Order and SKU). |
CIMS Order Item ID | It represents the unique identifier for the order line items(Order and SKU) at CIMS module. |
Exposed Quantity | The inventory quantity exposed to marketplace/ ERP. |
Consolidated Exposed Quantity | Ganesh KVKS (Unlicensed) Please elaborate. |
Expiry Date | If SKU is perishable, the expiry date would be present. |
Consolidated Expiry Date | Ganesh KVKS (Unlicensed) Please elaborate this. |
Buffer | It represents the inventory buffer used against the client channel pair in CIMS. |
Last Synced At | The time when last inventory update was synced. |
Channel Name | The name of the channel added at Increff CIMS for marketplace/ ERP. |
Channel Fulfillment Location Code | It represents the fulfillment location Id which marketplace/ ERP uses in API calls with Increff. |
OMS Fulfillment Location ID | It represents the fulfillment location Id for OMS module. |
CIMS Location ID | Unique identifier for fulfillment location at CIMS module. |
Listing ID | Listing ID is a unique identifier for the mapping of a client SKU with Channel SKU against a client channel pair. |
Order Creation Time | The time when order was created. |
Excess Order | Excess order shows if the order was Excess or not. Excess order is the order placed by marketplace even after receiving the successful zero inventory sync against SKU of any order line Item from Increff. |
Inventory Exposure History SKU Wise
This report screen provides support to fetch inventory exposure details of an SKU within the timerange time range mentioned across the locations chosen. This screen can be used by the user which is similar to as a substitute for Outwards : Order Exposure History - CIMS report in Jasperthe Omni Reporting tool.
...
The screen takes CSV file the below fields 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 | We can choose the multiple fulfillment locations against which exposure details are required. |
Increff SKU ID | Increff SKU ID represents the unique ID generated at Increff against the Client SKU during master upload. The exposure data can be searched against this SKU. |
| Info |
|---|
|
Upon uploadingchoosing the options, a downloadable CSV file will be returned as a response can be downloaded which contains the following details.
Parameter | Remarks |
|---|---|
Type | Type represents to either Order or Exposure(ie, Order Creation or the inventory exposure). The data in complete row follows the Type column. |
OMS Fulfillment Location ID | It represents the fulfillment location Id for OMS module. |
Order / Exposure Time | It represents either the order creation time or the inventory exposure time based on the Type column. |
Channel Name | The name of the marketplace/ ERP for which either inventory got exposed(when Type is Exposure) or an order is created(when Type is Order). |
CIMS Order Status | If Type is order, the Order status at CIMS module will be populated here. |
Increff SKU ID | Increff SKU ID represents the unique ID generated at Increff against the Client SKU. |
Channel SKU ID | Channel SKU ID represents the SKU Id present at marketplace/ ERP. |
Exposed Quantity | In case of Exposure, the quantity being exposed to marketplace will come here. |
Consolidated Exposed Quantity | Ganesh KVKS (Unlicensed) Please elaborate |
Sync Status | Sync Status shows whether the inventory exposure was successful or not. |
Last Synced At | The time when last inventory update was synced. |
Buffer | It represents the inventory buffer used against the client channel pair in CIMS. |
Expiry Date | If SKU is perishable, the expiry date would be present. |
Consolidated Expiry Date | Ganesh KVKS (Unlicensed) Please elaborate this. |
Ordered Quantity | If Type is Order, this field shows the quantity ordered for the certain SKU. |
Channel Order ID | Channel Order ID represents the Order Id present at marketplace/ ERP. |
Channel Fulfillment Location Code | It represents the fulfillment location Id which marketplace/ ERP uses in API calls with Increff. |