Proposal summary
This proposal describes the showing an alert and auto selecting items in item receipt on barcode scanning.
Requirement
The client would like to complete the following requirements:
- The item may have one UPC code and multiple barcodes using custom record “Product multi units”. Currently the user can auto select the items in item receipt by entering only the Item UPC code (in item record) in the “SELECT ITEM” field in item receipt.
- Now the client would like to auto-select the items using the UPC code and barcodes in the Item receipt.
- And show an alert when Items do not match with the UPC code and barcode.
Our Solution
Field Customization:
We will add the following 3 custom fields in the Item receipt:
- UPC code: This field will show the UPC code from the item record in the item line in the item receipt.
- Barcodes: This field will show the barcodes from the custom record “Product multi units” of the item record in the item line in the item receipt. If the items contain multiple barcodes, the barcodes will be separated by a comma.
- SELECT BARCODE: New field will be added under the items & Expense tab to enter the barcodes to auto-select the items.
UPC and Barcode value setup in Item receipt:
We will deploy one script which will set values in the UPC code and Barcode fields in item lines when opening the item receipt record.
Auto selection of items in item receipt
Users must scan or enter the barcode value in the “SELECT BARCODE” field. When the user enters the UPC/Barcode value in the “SELECT BARCODE” field, the script will auto select the items if there are items with matching UPC/barcode values.
- The Script will first check the scanned barcode is a valid barcode in all the custom records “Product Multi-Units” or UPC field value in the item record. If it is a valid barcode, the corresponding item field will be automatically selected by our script
- We will show alerts if there are no items with the same UPC / Barcode.
- If there are no items with matching UPC/Barcode values, then the script will show the alert “No items available with matching UPC/Barcode”.
- When the user enters the UPC code in the standard field “SELECT ITEM”, the items with the same UPC code will be selected by the standard feature.
Assumptions:
- The UPC code and barcode of one item will not be used in another item
- The functionality will work only on the create context of item receipt, it will not work on the edit context.
- The new “SELECT BARCODE” field will work only for selecting items based on UPC and Barcode.
- NetSuite User will be properly managing the “Products Multi-units” custom record
- Multiple units of measure of the item are not considered in this scope
- Any other related fields such as the quantity field will not be achieved by multiple scanning of UPC
- Freeform text custom field in NetSuite is scannable
- This customization is applicable only to inventory items
Risk
- The warehouse will have its own scanners and we will not be conducting testing on scanners.
- When the user scans or enters a new barcode in the custom field, we will not uncheck the checkbox for the existing item or update the quantity of any item.