By Serial tab
The By Serial tab is the register of serial numbers. It shows one row for each serial number the warehouse knows, with its status and where it is.
The form is inventory_balance_serial_list. The data object is inventory_balance_serial, over the table inventory_balances_serial. The list is read by list_inventory_balance_serial.
The list is read only. The tab has no button to change a serial: serials change only through the receiving, move, pick and ship commands (crates/services/app-server/src/web/rpcs/inventory_balance_serial_rpc.rs:1-12).
The same list form is the Serials tab of a receipt line. See Line serials tab.
Columns
| Label | Column | Type | Filter | Quick filter | Shown at first | What it shows |
|---|---|---|---|---|---|---|
Receipt | received_via | Whole number, shown as text | None | No | Yes | The number of the receipt on which the serial was received. When the receipt has an external number, that number is shown. |
ID | id | Whole number | Number | No | No | The id of the serial row. |
Serial # | serial_number | Text, up to 80 characters | Text | Yes | Yes | The serial number. |
SKU | sku_code | Text, up to 50 characters | Text | Yes | Yes | The SKU code. |
Lot | lot | Text, up to 10 characters | Text | No | Yes | The lot. |
Container | container_id | Whole number, shown as a container code | Number | No | Yes | The container that holds the unit. Empty for a loose unit. Drawn with a glyph for the container type. |
Location | location | Text, up to 20 characters | Text | No | Yes | The location of the unit. |
Status | status | Text | Text | No | Yes | The status of the serial. See below. |
Received | received_at | Date and time | Date | No | Yes | When the serial was received. |
Source: the table inventory_balances_serial and the view serial_received_receipt in crates/libs/wms-lib-sql/sql/wms-app/migrations/001_baseline.sql (lines 2554 and 5767). The lookup that turns received_via into a number is the formatter fk:serial_received_receipt:receipt_number.
Serial statuses
The column status holds one of these values (database type serial_status):
| Status | Meaning |
|---|---|
Active | In stock. The state of a received serial. |
Reserved | Promised to an order. |
Picked | Picked for an order. |
Packed | Packed into a carton. |
Shipped | Left the warehouse. |
Returned | Came back from a customer. |
Damaged | Reported damaged. |
Held | Under a hold. |
Disposed | Written off. Final. |
Not confirmed by code: the exact moves between these statuses. They are decided by the serial commands (
serial_commands_rpc.rs), which this section does not describe. To verify: read the serial tracking pages of the inbound section, then follow one serial from receipt to shipment on a test warehouse.
Related pages
- Balances screen
- Open Episodes tab
- Line serials tab
- Capturing serial numbers
- API:
list_inventory_balance_serial,get_inventory_balance_serial,count_inventory_balance_serial - RF terminal:
ReceivingscreensRCSN01(serial capture). Move screenINVMOV_SNscans serials for a partial move.