How do I work with serial numbers?
A serial number identifies one specific unit of an item: an appliance, a machine, a piece of IT equipment. With serial numbers switched on, the ERP always knows where each unit is and which customer it was sold to.
What do I need before I start?
You need serial number management to be switched on in your company. It is a company decision, not a user preference. If you don’t have it, you won’t see anything described here.
It is switched on in Settings → Warehouse and production → Warehouse, Control, batches and serial numbers block, Serial number management drop-down. That screen is handled by whoever administers the ERP; if you can’t get to it, ask them.
With management switched on, mark the items that use it: open the item, General tab, Traceability field, By serial number option.
Bear in mind that for these items quantities are always whole numbers: each unit is one serial number, and half a serial number doesn’t exist.
How do I enter serial numbers when buying?
In the purchase document, the line has a Serial/Batch column. Click its button or press F9 to open the breakdown window, and type the serial numbers one by one:
- Type the serial number in the field at the top.
- Click Add or press Enter.
- Repeat until Pending reaches zero.
- Click OK, or Ctrl+Enter.
The serial numbers of incoming stock have to be typed in: they are the physical detail of each appliance and the ERP can’t make them up. If you try to issue without them, the document isn’t issued.
How do I enter many consecutive serial numbers in one go?
Type the range in the same field, with the two ends separated by a hyphen or by ‘ - ’. For example, A-0098 - A-0102 adds five serial numbers: A-0098, A-0099, A-0100, A-0101 and A-0102.
There are three rules for the range:
- Both ends have to end in a number and share the same beginning.
- Leading zeros are kept:
A-0098givesA-0099, notA-99. - The range goes from lowest to highest and produces at most 10.000 serial numbers.
As a serial number can contain hyphens, the ERP reads the text carefully: if it can’t find a valid reading as a range, it takes it as a single literal serial number. So A-0098 on its own is added as it is. If you want to be sure it is read as a range, use the separator with spaces: - .
When the line is for a single unit, the text is always taken as a literal serial number: there, reading ranges would break legitimate serial numbers with hyphens.
How does the ERP choose the serial numbers when selling?
The ERP suggests the oldest ones in that warehouse, by date in. There is no configurable criterion: for serial numbers it is always like this.
If the line is for one unit, it assigns it without opening anything. If there are several, it opens the breakdown window so you can check or change which ones go out. You can remove a serial number from the list and add another from the Available panel, by double-clicking or with Enter.
If there aren’t as many serial numbers available as the line asks for, the ERP warns you: ‘Only N serial numbers are available out of the M requested.’
Which rules won’t it let me skip?
Serial numbers have three hard rules, and none of them gives way even if the company allows selling without stock:
- A serial number doesn’t come in twice. If it is already live in any warehouse, it can’t come in again.
- A serial number doesn’t go out if it isn’t there. It has to be available in the line’s warehouse.
- A serial number isn’t repeated within the same line, and each one is worth exactly one unit.
They are hard rules because a serial number is a unique physical object: if the ERP let two receipts of the same serial number through, the traceability of that appliance would stop meaning anything.
Where do I see the status of each serial number?
On the item record, Serial numbers tab. It only appears for items set to By serial number.
The table lists each serial number with its Status —In stock or Out—, the Warehouse where it is if it is still in house, the In date, the Last document that moved it and the Business partner on that document.
This answers at a glance the most frequent after-sales question: ‘this serial number, who did we sell it to and when?’. At the top there is a filter by serial number, and clicking a row opens its full traceability below.
Where is the serial numbers report?
In the Warehouse → Serial numbers menu, separate from the batch reports. The Serial numbers by item option lists the serial numbers in stock, with their warehouse and entry date. It appears in the menu if your company has the Serial numbers module, even if it doesn’t work with batches.
On the printed delivery note and invoice, serial numbers appear below the description and in full: ‘Serial no.: A1’ with one, ‘Serial numbers: A1, A2, A3’ with several. They aren’t abbreviated: the customer needs each number.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| The Serial/Batch column doesn’t appear | Serial number management is switched off in the company | Ask whoever administers the ERP |
| ‘Serial numbers already in stock (they cannot come in twice): …’ | That serial number is already live in some warehouse | Check on the Serial numbers tab whether the receipt was already recorded |
| ‘Serial numbers not available in the warehouse: …’ | The serial number isn’t in the line’s warehouse | Check the line’s warehouse, or record its receipt first |
| ‘Serial number ‘X’ is repeated on line N.’ | The same serial number appears twice in the split | Remove the duplicate row |
| ‘Serial number ‘X’ on line N must be split into exactly one unit’ | A serial number split with a quantity other than 1 | A serial number is always one unit; add another serial number for the extra unit |
| ‘Units with a serial number must be whole (quantity …)’ | The line has decimals | Enter a whole quantity |
| ‘The text produces N serial numbers and the line requires M units.’ | The range doesn’t match the line’s quantity | Correct the range or the quantity |
| ‘Descending range: 'X' is greater than 'Y'.’ | The ends are the wrong way round | Type the lower one first |
| ‘Ambiguous range: '…' contains more than one ' - ' separator.’ | There are two separators in the text | Leave a single ‘ - ’ |
| ‘The range produces N serial numbers; the maximum allowed is 10000.’ | The range is too large | Split it into several |
| ‘Only N serial numbers are available out of the M requested.’ | There aren’t enough units in that warehouse | Reduce the quantity or record the missing receipt |
See also: Work with batches and expiry dates · Follow the traceability of a batch or a serial number
More about Warehouse
- How do I raise or lower the prices of many items at once?
- How do I view and correct an item’s stock?
- How do I count the warehouse and balance the stock?
- How do I add a warehouse?
- Managing the warehouse
- What batch and traceability reports do I have?
- How do I move stock from one warehouse to another?
- How do I run the stock report?
- How do I follow the traceability of a batch or a serial number?
- How do I work with batches and expiry dates?
- How do I work with sizes and colours?