Appearance
Serial numbers on hand
The Serial numbers on hand report lists every serial number that is currently in stock, with the bin location and container it is in, and its lot and expiry date. Use it to answer "do we still have serial number X, and where is it?" or to export a full list of serial numbers per account.
Open it from the sidebar: Reporting › Serial numbers on hand.
What is included
The report contains one row per inventory item that has a serial number, in a location you have access to, for products of accounts you have access to. Like Inventory on hand, it leaves out items that are retired (no longer in stock, for example shipped) or expected (announced but not yet received). Items that are allocated, being picked, picked, packed but not yet shipped, or expired are included.
Units without a serial number are not shown. For those, use Inventory on hand.
Refreshed nightly
Unlike most reports, this report is refreshed once a night (at midnight, Amsterdam time), not every four hours. Serial numbers received or shipped today appear or disappear the next day. To check a single serial number right now, search for it under Inventory.
Columns
| Column | Meaning |
|---|---|
| Account | The account that owns the product. |
| Product number | The product's number (SKU). |
| Bin location | The bin location where the unit is stored. |
| Container | The outermost container the unit is in, for example the pallet, even when it is in a box on that pallet. Click it to open the container. Empty when the unit is not in a container. |
| Serial number | The unit's serial number. |
| Lot | The lot (batch) number, if the product is lot-tracked. |
| Expires on | The expiry date, if the product has expiry tracking. |
The report deliberately has few columns. It does not show the unit's location, state or status; use Inventory on hand and filter on Serial number if you need those.
Filters
All columns can be filtered with the operators for their type (see Filters). None of the columns has a list of values; you type the value. Useful filters:
- Account is a specific account, to list one customer's serial numbers.
- Serial number matches part of a serial number, for example a prefix that identifies a production batch.
- Serial number is duplicate, to find serial numbers that occur more than once in stock, which usually means a scanning or receiving mistake.
- Expires on less than a date, to find serialized stock that is about to expire.
- Container is a pallet name, to list the serial numbers on that pallet.
Sorting and search
The report is sorted by Product number, A to Z. Search looks in all columns, so typing (part of) a serial number is the quickest way to find a unit.
Exporting
Use the export button to download the list as CSV: all rows matching your filters or the current page only. See Exporting.
Typical use
- Customer serial number list: filter on Account, export, and send the file to the customer, for example for their asset administration or insurance.
- Finding a unit: a customer asks whether a specific device is still in the warehouse. Search for the serial number to see whether it is in stock and on which bin location and pallet.
- Data quality check: use is duplicate on Serial number to find duplicates.
- Matching with shipped units: together with Shipped serial numbers this gives a complete picture of which serial numbers are still in stock and which have left.
Who can see it
Admins, Warehouse associates, Account owners, Shopify account owners and users with the Reporting role. See Who can see reports.