This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
start:utilities:serial_number_import [2021/07/22 11:24] – created Justin | start:utilities:serial_number_import [2021/07/22 13:47] (current) – [There are 3 parts in the serial numbers process.] Justin | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | **Excel File Import** | + | ====== Serial Number |
The ability to import an excel file of serial numbers to then be allocated to an order at a later date is possible with this utility. | The ability to import an excel file of serial numbers to then be allocated to an order at a later date is possible with this utility. | ||
Line 12: | Line 13: | ||
No header line | No header line | ||
- | Column A is the branch number its been assigned to. This would normally be the main warehouse | + | Column A is the branch number its been assigned to. This would normally be the main warehouse. Our example set at 001 |
- | Column B is the PLU or Product number | + | Column B is the PLU or Product number |
Column C is the serial number (Maximum character length has been set at 30) | Column C is the serial number (Maximum character length has been set at 30) | ||
- | Example Excel Format | + | Example Excel Format |
{{: | {{: | ||
+ | |||
+ | |||
+ | ====== There are 3 parts in the serial numbers process. ====== | ||
+ | |||
+ | |||
+ | Part 1: Serial Number Creation (As Shown in this section) | ||
+ | |||
+ | Part 2: Stock Picking (https:// | ||
+ | |||
+ | Part 3: Goods In (https:// | ||
+ | |||
+ | If any of these steps are missed, then the rest of the system will not work correctly |