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.

A single global default container type must always be defined. When selecting a new default it clears the previous one so only one default container type will always exists at a time.
An optional default container can be stored against the stock code (Stock Code Maintenance) and is used when generating LPNs during receipting, if no stock code default is supplied, the global default container type is used.

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)

The Full indicator is a processing flag used to guide downstream behavior.

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

  • 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.

  • 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).

  • 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.

  • LPN options:

      • 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.

      • 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.

Solving

Why don't you drop us a line with some useful information we can add here?

* product-authoring@syspro.com

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.

This lets you browse an application.

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.