Proposal summary
This proposal covers the WMS customization – Phase 2 solutions(Remove Hyperlink , bulk printing of shipping labels, Manifest generation ) for XSEED and its proposed solution.
Requirement 1
Remove Hyperlink
When picking through SCM App, the bin locations and Item also came as hyperlinks. Can we remove the hyperlink to force the picker to scan/ manually type? Screenshot below
Our Solution
We can remove hyperlink of bin locations and item to pick, by customizing the mobile page. We will remove the hyperlink on both single order picking and multi-order picking. We are considering sales order picking only. We are attaching the screenshot of bin location hyperlink.
Requirement 2
Bulk printing of Shipping labels –
Bulk printing of Shipping labels happens. The shipping labels to be sorted by the following
1. TRANSPORTER
2. COURIER DETAIL
3. ITEM
Our Solution
- We will create a custom suitelet page in the XSEED account.
- In suitelet page we will add a list field to enter the wave number.
- User can enter the wave and click the print button.
- We will create three saved searches in script to get the sales order and its related IF generated from wave. Sorting of shipping label will be done in the search itself.
- We will generate shipping label in real time sorted in the priority transporter, courier details, item in the IF record. Here each shipping label will be in a separate page, first we show all the shipping label in which transporter is same. Then we again sort it by the transporter who have same courier details. And the shipping label is again sorted by the items in it.
- We believe that the existing shipping label template is used for bulk shipping label. The shipping label template used by XSEED is “JJ Custom Shipping Label PDF Template XEPL-81″.
- The page size of the shipping label template is 4.00 x 6.00 inches(A6-Landscape), which will have only 1 shipping label per page.
- The suitelet page will be available to all WMS roles who have access to the NetSuite. This page will not be available for external users.
Risk
- If there is large number of shipping label are to be processed in real time (greater than 100), then there can be performance issues and maximum suitelet execution time is 5 minutes. The correct count will get during the development stage only.
- If generating shipping label count is greater than the maximum count (correct count will get during the development stage), we need to create the shipping label by scheduling process (map-reduce script). It may require additional effort.
Requirement 3
Manifest Generation:
At the time of loading, barcode for transporter waybill for all boxes/ option of adding total boxes to be scanned. This should generate a manifest with time stamp, Order details, Carton Box Details, Weight, and Waybill Number. Option to also rescan box item labels to be available.
Our Solution
- We will create an icon for Manifest in the WMS page and when we click on the icon, we will enter to suitelet page.
- In the suitelet page first scan the Waybill barcode from the shipping label and will show sublist contain the inputted waybill number.
- When we scan the same waybill number on the different carton box in the IF we will show an alert “waybill already scanned”.
- Click the submit button.
- We will show a success message and generate a custom record id or number in real-time. This record id will be shown to the user who did the scanning.
- In the custom record we will set two fields starting index and ending index for the unique manifest number. When the custom record created, we will create a search of custom record in the script to get the starting index of manifest number (unique number) from the ending index of last generated custom record entry.
- We will create an IF search in script to get all the details to generate the manifest as an object. If the waybill has multiple IF, and manifest already generated for any IF, we will not consider that IF in the search.
- To take the print, go to custom record entry, that we have created through WMS manifest scanning in the NetSuite account.
- There is a custom button for printing the manifest in the custom record.
- The page size of the manifest template is A4-Landscape, which will have only 1 manifest per page.
- After we print the manifest, we will set the ending index field in the custom record with the last number of the manifest print.
- We will link the custom record entry with Item fulfilment record.
- If the user prints the same custom record entry multiple times, the print will be the same manifest with its unique number.
- The custom record entries should not delete from the NetSuite. If it is deleted, it is not possible to set the unique number.
- A separate manifest page will be generated for each TRANSPORTER & COURIER DETAIL combination.
- The manifest created will be stored in Netsuite as custom record entries with a unique Manifest number
The manifest print will be look like below.
Assumption
- We believe that the existing shipping label template is used for bulk shipping label.
- The shipping label page size is A6. Please confirm
- We assume that we can scan approximately 100 waybill at a time using the suite let page. We will get the correct count of possible scan during the development stage.
- We assume that the items in the carton are inventory item or assembly item.
- The proposal is based on camera scanning. We will use camera scanning for manifest waybill scanning. RFID scanning can be incorporated only after checking its possibility from our end and it may require additional effort.
Risk
- There will be scanning limitation for number of items to be scanned using the suitelet page. We will share the correct count of possible scan during the development stage.
- There will be slow performance in scanning the waybill barcode using camera based. It require more time to scan using the camera based.
- The custom record entry for manifest generation should not delete from the XSEED account. If it is deleted, it is not possible to set the unique number.
Time & budget
76 Hours