This is an old revision of the document!
does not match a serial number in the system a message will appear alerting you to this.
The ability to import an excel file of serial numbers to then be allocated to an order as part of the picking process is as follows.
You can download the template below to start creating your import file
picking_serial_number_format_sample.zip
The format of the file you create must be saved as a csv and the columns in the file are as follows.
No header line
Column A is the PLU or Product number you have created in your product file.
Column B is the serial number (Maximum character length has been set at 30)
Example Excel Format that would be saved as a csv format.
Part 1: Serial Number Creation (As Shown in this section)
Part 2: Stock Picking (allocation of serial number to an order)
Part 3: Goods In (confirmation of serial number received)
If any of these steps are missed, then the rest of the system will not work correctly