Program: License Plate Number Query
This program lets you query and review License Plate Number(s) (LPNs) in a warehouse using a review criteria pane to filter the LPNs you want to see, and a results pane to drill into LPN details and history.
Exploring
Things you can do in this program include:
-
Query and review LPNs.
-
View LPN movements, content (stock codes) and history
This program is accessed from the Program List of the Syspro menu:
Program List > Warehouse Management > License Plate Numbering and Containerization System
An LPN refer to an unique identifier assigned to a container that holds stock (e.g., pallet, carton, bin) for tracking through receiving, storage, movement, allocation/picking, dispatch, and counting.
An LPN may hold a single or multiple stock codes/lots depending on the setup options, Multiple stock codes per LPN, Multiple lots per LPN). Core metadata includes warehouse, bin, container, created date/by, and statuses (On Hold, Archived, Awaiting Put-away, In Transit, In Stock Take)
This refers to the physical type of container or storage (e.g., Pallet, Box, Cage) associated with an LPN, configured with dimensions, capacity, and label templates. Container Types are maintained in the Container Maintenance program and LPN Container Setup business object, which include the description, dimensions, maximum weight/volume, flags (default, stacking allowed, flexible volume), and associated label format.
This refers to an LPN that represents a larger container holding multiple child LPNs (e.g., a pallet holding boxes)
A Full LPN is one where the system expects the LPN to be processed as a single unit (for example, full-LPN picking/allocations), while an LPN that is not full is typically treated as 'open', meaning its contents may be partially allocated/picked (for example, by selecting specific lots/serials or quantities within the LPN)
Starting
-
LPN processing must be enabled and LPN master data must exist for the warehouse/bins you want to browse.
The following configuration options in Syspro may affect processing within this program or feature, including whether certain fields and options are accessible.
The Setup Options program lets you configure how Syspro behaves across all modules. These settings can affect processing within this program.
Setup Options > Configuration > Distribution > Inventory
-
Multiple bins
This requires entry of bins upon the receipt, issue or transfer of items and when capturing stock take information. The Purge and Archive program runs to ensure the default bin is inserted into existing lot records and their associated transactions against your traceable or ECC-controlled items. Run the Balance function of the Order Purge and Inventory Period End programs to ensure there are no quantities in ship without bin allocations and to transfer any qty on hand to the default bin.
-
Fixed bins
Only available in a SQL environment and if multiple bins is in use. Initially, all warehouses using multiple bins are flagged as fixed bin warehouses. The Show Warehouses hyperlink lets you switch off this facility selectively for warehouses. Fixed bins requires a bin to exist in the WhmBin table before you can transact against it. If the Create bins at inventory transaction option is switched on, bins can only be created at transaction time for warehouses not using fixed bins.
The Show Warehouses hyperlink is also used to maintain the WMS control options against the warehouse (Warehouse Maintenance).
-
Use license plate numbers
This indicates that WMS License Plate Numbering is required. When enabled, existing stock items in bins are placed in LPNs.
When this setup option is enabled, stock must be received into a warehouse and the Associate serials by bin setup option must be enabled. Run the License Plate Number Conversion or Stock Take LPN Conversion program to ensure all stock items that are currently in bins are placed into LPNs. Transactions can't be posted if the conversion wasn't done.
This setup option can't be disabled after the conversion was done or a license plate number was created.
-
:
-
Multiple stock codes per LPN
This indicates whether multiple stock codes can be allocated to one license plate number.
This setup option can't be disabled if multiple stock codes have been placed in an LPN.
-
Multiple lots per LPN
This indicates whether multiple lots can be allocated to one license plate number.
This setup option can't be disabled if multiple stock codes have been placed in an LPN.
-
Perform full LPN stock count
This indicates whether a stock count at license plate number level is required.
-
Solving
Why don't you drop us a line with some useful information we can add here?
Using
-
Columns in a listview are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the listview). Select and drag the required column to a position in the listview header.
-
Fields on a pane are sometimes removed by default. You can reinstate them using the Field Selector option from the context-sensitive menu (displayed by right-clicking any field in the pane). Select and drag the required fields onto the pane.
The captions for fields are also sometimes hidden. You can select the Show Captions option from the context-sensitive menu to see a list of them. Click on the relevant caption to reinstate it to the form.
If the Show Captions option is grayed out, it means no captions are hidden for that form.
-
Press Ctrl+F1 within a listview or form to view a complete list of functions available.
The License Plate Number Query process is as follows:
-
Select the Browse icon to open the License Plate Numbers Browse program or select an License Plate Number (LPN).
-
Additional criteria can be set using the available review fields to narrow the results set.
-
The results listview shows the LPNs that match your criteria.
-
Select an License Plate Number (LPN) and press Select to update the detail area and enables the related tabs:
-
Movements: Display the movement transactions recorded against the selected LPN, including the transaction type (e.g. receipt, bin transfer, warehouse transfer, pick, adjustment), transaction date, and the relevant source and destination locations (warehouse/bin). Use this tab to audit how the LPN changed location and troubleshoot discrepancies by tracing the sequence of movements.
-
Stock Code: Displays the current contents of the selected LPN at stock code level, including stock code, description, quantity (and available quantity), and the associated lot and serial details. Use this tab to verify what is physically expected in the container and to support downstream processes such as allocations, picking, and stock verification.
-
Container History: Displays the container activity history for the selected LPN, providing an end-to-end view of container-related events that affected the LPNs contents and lifecycle (for example, receipts into the container, content adjustments, picks, etc). Use this tab to review container usage over time and to confirm when and why the container's composition changed.
-
The following indicates the possible status codes that can be assigned to a License Plate Number (LPN). These statuses are implemented on header-level flags on the LPN record (i.e. the field used to control whether an LPN can be selected/processed in receipts, movements, allocations, picking, and stock take)
| Status | Description |
|---|---|
|
On Hold |
This indicates that the LPN is temporarily blocked from operational processing. It is used to restrict processing until the relevant action/task is completed or the hold is cleared (e.g., it cannot be moved/allocated/picked while on hold) |
|
Awaiting Put-away |
This indicates the LPN has been created/received and is pending put-away. |
|
In Transit |
This status indicates that the LPN is in a transfer state (e.g., Goods-In-Transit processing) and is not available for normal selection until it is received/confirmed at the destination. |
|
In Stock Take |
This indicates the LPN is currently part of an active stock take process, and operations on an LPN are not allowed when this flag is set. |
|
Archived |
This indicates the LPN is no longer operationally active and is retained for audit/history purposes. Setup option LPN archiving (Setup Options > History > Distribution > Inventory) must be configured. |
Referencing
This lets you enter or select a unique License Plate Number(s) (LPNs)code.
This returns to the previous screen or selection.
This proceeds to the next screen or selection.
| Field | Description |
|---|---|
|
License plate number |
Indicates the unique identifier of the stock code being queried. |
|
Warehouse |
Indicates the warehouse in which the LPN is currently recorded. |
|
Bin |
Indicates the bin location in which the LPN is currently recorded. |
|
Container |
This indicates the container type code used to identify the container definition (for example, a pallet, box, cage or tote type) |
|
Date created |
Indicated the date on which the LPN has been created. |
|
On hold |
Indicate that the LPN is in a On Hold status. |
|
On hold reason |
Indicate the On hold reason code. |
| Full | Indicates whether the selected License Plate Number (LPN) is considered a full container (i.e., the LPN is being treated as a complete, closed container for processing purposes). |
| In stock take | Indicate that the LPN is in a In Stock Take status. |
| In transit | Indicate that the LPN is in a In Transit status. |
| Awaiting putaway | Indicate that the LPN is in a Awaiting Put-away status. |
| Archived |
Indicate that the LPN is in a Archived status. |
| Parent LPN | Indicate the Parent LPN number. This is not compulsory, and not all LPNs will have a Parent LPN. |
The License Plate Number (LPN) listview consist of three tabs:
Movements: Display the movement transactions recorded against the selected LPN, including the transaction type (e.g. receipt, bin transfer, warehouse transfer, pick, adjustment), transaction date, and the relevant source and destination locations (warehouse/bin). Use this tab to audit how the LPN changed location and troubleshoot discrepancies by tracing the sequence of movements.
| Field | Description |
|---|---|
|
License plate number |
Indicates the unique identifier of the stock code being queried. |
|
Container |
This indicates the container type code used to identify the container definition (for example, a pallet, box, cage or tote type) |
|
Line |
Indicates the line number. |
|
Stock code |
Indicates the stock item contained in the LPN. |
|
Warehouse |
Indicates the warehouse in which the LPN is currently recorded. |
|
Bin |
Indicates the bin location in which the LPN is currently recorded. |
|
Transaction |
Indicates the type of movement recorded against the LPN (e.g., receipt, bin transfer, warehouse transfer, adjustment, pick, issue) |
| Transaction date | Indicates when the movement was recorded. |
| Operator | Indicates the operator name who performed the action. |
| To warehouse | Indicates the destination warehouse for the movement. |
| To bin |
Indicates the destination bin for the movement. This field might be hidden from the listview. Use the Field Chooser to display any columns that are hidden by default.
|
Stock Code: Displays the current contents of the selected LPN at stock code level, including stock code, description, quantity (and available quantity), and the associated lot and serial details. Use this tab to verify what is physically expected in the container and to support downstream processes such as allocations, picking, and stock verification.
| Field | Description |
|---|---|
|
License plate number |
Indicates the unique identifier of the stock code being queried. |
|
Content ID |
Indicates the content ID. |
|
Stock code |
Indicates the stock item contained in the LPN. |
|
Stock code description |
Indicates the stock code description. |
|
Serial |
Indicates the serial number(s) of the stock contained in the LPN (the serialized item) |
|
Lot |
Indicates the lot number of the stock contained in the LPN (for lot traceable items) |
|
Quantity |
Indicates the quantity of the stock item, sourced from the WhmLpnDetail table. |
| Available quantity | Indicates the uncommitted quantity available for allocation/processing. |
| Bin |
Indicates the bin location in which the LPN is currently recorded. This field might be hidden from the listview. Use the Field Chooser to display any columns that are hidden by default.
|
| Warehouse |
Indicates the warehouse in which the LPN is currently recorded. This field might be hidden from the listview. Use the Field Chooser to display any columns that are hidden by default.
|
Container History: Displays the container activity history for the selected LPN, providing an end-to-end view of container-related events that affected the LPNs contents and lifecycle (for example, receipts into the container, content adjustments, picks, etc). Use this tab to review container usage over time and to confirm when and why the container's composition changed.
| Field | Description |
|---|---|
|
Container |
This indicates the container type code used to identify the container definition (for example, a pallet, box, cage or tote type) |
|
Line |
Indicates the line number. |
|
Stock code |
Indicates the stock item contained in the LPN. |
|
Warehouse |
Indicates the warehouse in which the LPN is currently recorded. |
|
Bin |
Indicates the bin location in which the LPN is currently recorded. |
|
Transaction type |
Indicates the type of movement recorded against the LPN (e.g., receipt, bin transfer, warehouse transfer, adjustment, pick, issue) |
|
Quantity |
Indicates the quantity of the stock item, sourced from the WhmLpnDetail table. |
| Transaction date | Indicates when the movement was recorded. |
| Operator | Indicates the operator name who performed the action. |
| License plate number |
Indicates the unique identifier of the stock code being queried. This field might be hidden from the listview. Use the Field Chooser to display any columns that are hidden by default.
|
Copyright © 2026 Syspro PTY Ltd.