Summary
Box and Item code mapping details will be required by WMS to support box-wise inwards and crossdocking functionality.
Box and Item Code mapping can be created using CIMS UI or through APIs.
Below validations are present in the system to accept the box item code mapping.
Box and Item code mapping can be done against an ASN only after the ASN is approved. Note: Without using ASN functionality, Box and Item code mapping can’t be added in the system which is crucial for boxwise inwards and crossdocking.
SKU-wise total items in all the boxes that are provided in the CSV file/ API request, should not exceed the approved qty for each SKU in the ASN.
ASN-BOX-Item mapping can be requested multiple times (paginated) until gate entry is created for the ASN. For a box, the user should provide all item information at the same request.
After the ASN approval the following details can be provided.
BoxCode, purpose (CROSS_DOCK, STORAGE) and list of (ItemCode, Channel SKU, External Batch Code (if the SKU is perishable), Mfg Date (if the SKU is perishable) , Expiry Date (if the SKU is perishable)).
Map Box Code - Item Code for approved ASN screen in CIMS
CIMS UI: Provide a mechanism to upload Box - Item Code mapping for an approved ASN
Input client-channel pair, fulfilment location id, channel order id, asn code to fetch the asn: refer Approve ASN screen
Show an error if ASN with given details doesn’t exist, or if the asn is not in APPROVED / PARTIALLY_APPROVED
Then give an option to upload a CSV consisting of details : cims_asn_id, box_code, item_code,global_sku_id, external_batch_code,mfg_date,expiry_date
Note: External Batch Code, Mfg Date and Expiry Date to be filled by the user if the SKU is perishable. No need to handle it on UI, BE will throw error on CSV Upload
Note: Users should be able to upload box-item level details for the same ASN and different boxes multiple times.
Box Item Code Mapping
While receiving, if some boxes are received and the Box Item code mapping is not present, this screen can be used to map the box with barcodes and Items.
...
...
ASN, Box and Item Code Mapping for Approved ASN
Box and Item Code mapping can be created using CIMS UI or through APIs. Please follow the below steps to map the ASN, Box codes and Item Codes at CIMS UI:
Go to CIMS-> Box Item Code Mapping
Select the Client Channel Pair, and Fulfillment location. Enter Channel Order Id and ASN Code against which Box Item Code mapping is required to be added.
ASN details will be displayed as shown below.
Download the CSV file.
Add the Box Code, Item Code, Channel SKU ID, Purpose(Storage/ Crossdock), external Batch code, manufacturing date and expiry date in CSV file.
External Batch code, manufacturing date and expiry date are required if the SKU is perishable.Upload the CSV file.
APIs for ASN, Box and Itemcode Mapping
New APIs | Description | Reference Links |
|---|---|---|
ASN-Box-Item Code Mapping API | To streamline Bulk inward operations without taking out the items, now we offer the capability of sending the Box-Items mapping which are expected in an ASN shipment. |