If the inventory item type is specified as Serialized, an additional Serial Numbers tab is available to display the serial numbers assigned to quantity on hand and historical transactions. You also can see transactions related to specific serial numbers.
The Serial Numbers screen is divided into two sections, which can be resized by dragging the splitter bar between them. The top section lists all quantity on hand and each serial number and related information. The bottom section lists the dispositions of a highlighted serial number to see related transactions.
Serial number list
In addition to the standard toolbar buttons such as Filters or reports, there are some key processes related to serial numbers.
- Hold – Highlight one or more serial numbers and toggle the Hold button to mark the hold status on each number. This prevents these serial numbers from being selected on sales orders, adjustment reductions, stock transfers or production order consumption.
- Update Sell Prices – Highlight one or more serial numbers and click the button to enter a new Sell price to apply. Choosing this serial number on a sales order will adjust the Unit Price of the item.
- UDF – If user defined fields (UDFs) are configured for serial numbers, they can be entered here.
Serial number grid:
- Number – The serial number, which must be unique across all items.
- Hold – The on hold status, identifying that these serial numbers are not available for transaction entry.
- Pending Receipt Qty – Quantity on a receipt or adjustment transaction that is entered but not yet posted.
- On Hand – If this is one then it is not yet been sold or consumed, and is either still available or committed. If zero then it is no longer on stock.
- Available Qty – If this is one then it is still available to sell or use for production. If zero then it is not. This value is calculated from internally stored On Hand and Committed quantity for each serial number, to better match the overall inventory quantities.
- Committed Qty – If this is one then it has been sold or used for production. If zero then it has not.
- Unit Cost – The unit cost of the item for this serial number when it was purchased or produced.
- Sell Price – The unit price of the item for this serial number when it is sold to a customer, which is independently maintained from the unit price levels on the item.
- Received Date – Date the items for this serial number was received. If this field is blank then the transaction with this serial number has not yet been posted and is still pending.
- Expiry Date – Not used for serial numbers.
- UDF – If user defined fields (UDFs) are configured for serial numbers, they can be displayed here.
Serial number transactions
You can highlight one or more serial numbers and see dispositions in this lower grid.
- Number – The serial number associated with the transaction.
- Type – Type of movement. There are many different types of transactions that create or deplete serial-numbered items.
- No – The document number from the transaction.
- Receipt No – A unique internal number from the transaction that added qty on hand for the item, which could be from a PO receipt but could also have come from many other transaction types. If it is blank, then the transaction is either pending and not posted, or a transaction that sold or used the serial number.
- Date – Date of the transaction.
- Unit Cost – Unit cost of the item on the transaction. It will be zero for pending or depleting-type transactions.
- Received Qty – The net movement quantity of the transaction. It could be negative for inventory adjustments or transfers or consumed in production orders, or zero for Invoices.
- Sales Qty – The quantity of items sold on an Invoice. This will be zero for other transaction types.