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

...

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:

1. Go to CIMS-> Box Item Code Mapping

   Image Added

2. 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.

   Image Added

3. ASN details will be displayed as shown below.

   Image Added

4. Download the CSV file.

   Image Added

5. 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.

6. Upload the CSV file.

Box Item Code Mapping(Boxes received in warehouse without Box Item mapping present)

While receiving, if any 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.

Follow the below steps:

1. In WMS, Go to Box Item Code Mapping screen.

   Image Modified

...

...

2. Choose the scannable field in Configuration(By clicking the Configuration button) as Barcode or Custom SKU Attribute as per the requirement. SKU Attribute should be searchable attribute and is usually used when barcodes are not present.

   Image Added

3. Box-Item mapping using Barcode

   1. Scan box code and barcode

      Image Added

   2. Scan the Item Code

   3. Repeat the same steps from 1 if there are more items to be mapped to the box.

4. Box-Item mapping using Custom SKU Attribute

   1. Scan box code and SKU Attribute

   2. If there are multiple SKUs in master data against the same searchable SKU attribute, all the options are shown. Users can decide to choose one based on the available info displayed in screen and physical characteristics.

      Image Added

   3. Select and then scan the item code

      Image Added

   4. Repeat the same steps from 1 if there are more items to be mapped to the box.

Image Added

APIs for ASN, Box and Itemcode Mapping

Raghav Mehta Rahul Singh To add public document link.