Feature - Warehouse Receiving Serial Number Validation

Feature - Warehouse Receiving Serial Number Validation

Release Date: 7/26/2016

When processing receipts through PO -> Processing -> Warehouse Receiving, the new feature will validate serial numbers that are entered/scanned for the item and prevent invalid serial numbers from being received into Elliott inventory. 

In recent years, we noticed a phenomenon of an increasing number of bad serial numbers being received into Elliott inventory through the scanning process. This mostly takes place through the PO Warehouse Receiving process, which is designed to support scanning. Generally speaking, if there's a bad scan of a UPC code, Elliott has an internal mechanism to validate the UPC code to prevent this scenario.  But when you receive a serial number, if there's a bad scan -- such as one that is missing a single digit or one that contains an invalid character -- it is not caught because Elliott assumes that the receiving serial number is simply not on file.  Thus, a bad serial number can be received into Elliott inventory and is only discovered later on when you try to sell that serial number or perform a physical/cycle count.

To address bad serial number scanning, we introduced two new Global Setup flags into Global Setup -> System -> Serial No. tracking control. See sample screen below:



If field 17 is set to "Y,"  the program will validate the scanned serial number in the PO Warehouse Receiving Add Mode. All characters must be 0-9, A-Z, "-" or "." If invalid characters are entered, the following message will appear and the user must enter "DONE" to continue.


If the special character happens to be a valid entry, the user may press F1 to Allow Special Characters.  This will turn off the validation until the user presses F1 again to Reject Special Characters. See sample screen below:


In Global Setup, if field 18 is "Y" and the second or later serial numbers are not the same length as the first serial number, the following message will appear and the user must enter "DONE" to continue. See sample screen below. 


These validations will also be done if F3 is pressed to enter a range of serial numbers.
  


The technical reasons that cause the invalid serial number to be scanned are not completely clear.  Based on our observations, there are a few possible reasons why this might happen:
  • Scanner Issue: We found scanners from Symbol are most reliable. A linear, one-dimension laser scanner is more reliable than a two-dimensional image scanner. Symbol was later sold to Motorola.  As of this writing, their current owner is Zebra.
  • Bar Code Label Issue: We found the bar code created though a laser printer is not as good as the one created through a ribbon printer. Bar code ribbon printers produce high quality bar code images.  But the ribbon cannot be reused, so it can be costly if you have a large number of bar code labels to produce.  That is the reason why some manufacturers choose to use laser printers.  But sometimes the laser printer can't print the thin line of the bar code clearly, and that results in broken lines in the bar code that can be missed during scanning. 
  • Network Issue: Your wireless network in the warehouse may not be reliable.  If you are running from a remote warehouse that is some distance away from your Elliott server, the wide area network reliability may also play a role. Do a ping test between your remote warehouse and your Elliott server and measure your packet lost ratio.
Modified programs: NSCTLFIL.FD, NSCTLFIL.W30, NSCTLINI, NSCTLMN1, SERMNTP
DLM



    • Related Articles

    • Feature - Minimum Serial Number Length in PO Warehouse Receiving

      Release Date: 8/5/24 Version: 8.5 and Above A new option is available in Global Setup-> System-> Serial Number Tracking that allows the user to specify the minimum length of the serial number that is accepted when entering Purchase Order Warehouse ...
    • Feature - Add Serial Number Support to PO Warehouse Receiving Import

      Release Date - 6/25/18 In Elliott, the PO -> Processing -> Utility -> Warehouse Recv Import application supports receiving through CSV file import. The CSV file currently supports the following columns: Vessel ID Vessel Comment Vessel Receiving ...
    • Presales Warehouse Receiving

      Release Date: 3/1/24 Revised: 10/16/24 Version: 8.6 and Above PO Warehouse Receiving Add Mode If running the Presales Interface, the application will show the first vessel number attached to a purchase order when searching for a purchase order. The ...
    • Feature - Use PO Warehouse Receiving CSV Import for Validation & Creating Another CSV File

      Release date: 4/30/2021 Version 8.5 & Up Generally speaking, P/O Warehouse Receiving CSV Import ( PO -> Utility -> Warehouse Recv Import) is used to create warehouse receiving transactions. In some unique situations, the user may not want to create ...
    • Feature - Warehouse Receiving Posting to Optionally Create a CSV File

      Release date: 5/1/2021 Version 8.5 & Up In PO -> Processing -> Warehouse Receiving Process, the user can now optionally create a CSV file upon the posting of PO Warehouse Receiving. To enable this feature, you need to go to Global Setup --> Dist --> ...