Requirement
AMVOP would like to implement a new solution for fulfilling the sales orders by truck and a single fulfilment record should be created for one truck. The fulfillment of the sales order will be done only by scanning each pallet which are created from the work order completion record.
The sales order sales type will be either truck, 20 DC Capacity, 40 DC Capacity and one fulfillment will be created for all item lines in one sales type.
We have attached the screenshot of the sales order with item lines that can be grouped by sale type field value.
Following notes should be considered while updating the solution
- User need to scan each pallet and there will be a fulfillment per sales type for the sales order.
- Work order will be created from sales order and created as stand-alone.
- Sales order UOM will varies and the item quantity calculation is based on the primary sales unit.
- The carton should be fulfilled completely, there will be no partial case for a carton (Whole number).
- Outbound staging bin is used as a workaround bin and after that directly deliver to the customer.
Solution
Current Development
We have created a custom icon in WMS mobile page called “Custom SO Fulfilment” in the main menu.
Once the user clicks the icon will navigate to the custom page called “Select Sales Order”.
The user needs to select the sales order, and on selecting the sales order the user will forward to the next custom page called “Scan QR Code” which has a scan button. The scanning window will appear on clicking the scan QR code button.
Once the user scans the QR code, the item fulfilment will be created for each pallet
The item fulfillment for the sales order will be created in shipped status upon clicking the “create item fulfilment” button.
Note:
- The inventory details should be completed manually through NetSuite for the sales order.
- The work orders which are created from the sales order have a connection link and can identify the sales order while scanning. But for the stand-alone work orders have no link between the pallet and the sales order, so the user needs to click the related sales order for each pallet for scanning.
New Development
Custom Record set up
We will be creating a custom record in the NetSuite called the “Custom Item Fulfilment” record. All instances related to one sales order will be attached in the “WMS Customization” subtab in the sales order
Custom Fulfilment Option in NetSuite WMS App
Users must select the sales order in the “Enter Order” page in NetSuite WMS and the user will be navigated to the Scan QR code page.
Once the QR code is scanned, the user will be navigated to see the details scanned in the QR code. Then the user can confirm the details on the page by clicking the “Create custom fulfillment” button on the custom page. Once it is clicked with the entered details, we will create an instance for the custom fulfillment record.
The quantity for the sales order is calculated by considering the primary sale unit and stock unit defined in each item record. The conversion rate will be calculated from the unit of measure record.
Note:
- Any pallets can be scanned and their quantities in the QR code will be considered only in the fulfilment
Real-time script for item fulfilment record creation
We will be adding a script to create an item fulfilment record for the sales orders in NetSuite once all the item lines corresponding to one sale type have been fulfilled. The item fulfilment record will be created in the picked status.
Queries
- If a sales order line items sales type is the truck and has multiple line items for the sales order, is one truck containing the same item, or multiple items are fulfilled through the same truck for a sales order?
Assumption
- Inventory details for the sales order need to be configured from the NetSuite side manually as we cannot get bin details from the pallet label QR code.
Risks
- Suppose all the item lines are not fulfilled completely, the item fulfilment record creation will be pending
- The inventory stock count or GL impact will only come into action once the item fulfillment record is created and not be affected when the custom record is created
Time and Effort
Total Effort: 30 Hours