Program: Stock Take by License Plate Number

This program lets you capture stock take counts by License Plate Number(s) (LPNs), including drilling into LPN details to add or remove items within an LPN during counting.

Exploring

Things you can do in this program include:

  • Capture the counted quantities by LPNs (rather than by stock code/bin).

  • Review variances

  • Add, delete or change LPN quantities, using the Stock Take Capture LPN Details program.

  • Confirm the stock take to update live inventory.

This program is accessed from the Program List of the Syspro menu:

    Program List > Warehouse Management > Stock Take System > Transaction Processing > License Plate Numbering and Containerization

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 stored within a parent LPN. Only a single level of hierarchy is supported. Child LPNs are managed within the LPN Parent Child Relationship program and LPN Parent-Child Relationship business object.

This refers to an LPN that represents a larger container holding multiple child LPNs (e.g., a pallet holding boxes)

LPN Conversion refers to a company-wide process performed after enabling the Use license plate numbers setup option (Setup Options > Configuration > Distribution > Inventory) to ensure that all existing stock items currently held in bins are placed into LPNs.

Run the License Plate Number Conversion or Stock Take LPN Conversion programs to complete the conversion.

Transactions cannot be posted once the setup option has been enabled, until conversion has been performed.

Starting

  • LPN processing must be enabled and warehouse/LPNs must be included in an active stock take, because LPN-based stock take capture is performed within the stock take framework.

  • Stock take processing requires that selected stock take items/LPNs are captured and investigated before confirmation.

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

  • A stock item must not be assigned to an LPN during capture if that stock item is already held in a different LPN, as LPNs represent container-level ownership of stock.

  • LPNs that are part of an active stock take are expected to be processed at LPN level, otherwise variances cannot be applied accurately to the container.

Solving

LPN-enabled stock take processes are structured by bin > LPN > stock/lot/serial, and variances must be applied to the correct container.

Yes.

The LPN stock take process supports updating the content of an LPN during capture, including adding/removing lines.

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 Stock Take by License Plate Number process is as follows:

  • Load the LPNs that are included in the current stock take (based on your prior Stock Take Selection.

  • Capture the stock take result for each LPN at LPN Level (i.e. treat the LPN as the primary unit of capture)

  • Where you need to reconcile the contents of an LPN, use the LPN details functions (hyperlink) to open the Stock Take Capture LPN Details program and update the lines (add, change, remove) as required.

Use the LPN details function only when needed (e.g. when the physical content do not match what the system expects), as it changes the recorded composition of the LPN for stock take processing.

  • After capture is complete, proceed with your standard variance review and stock take confirmation.

Complete variance review before confirmation, consistent with the standard stock take process

Referencing

This commences processing of LPNs in stock take.

This lets you change the currently configured review criteria.

Field Description

Warehouses

This lets you select a single warehouse that already has an open stock take.

This lets you indicate the single warehouse for which to perform the selection.

This displays the description of the selected warehouse.

Options

This lets you select the various stock take types to be listed in the listview.

Enter a reference to apply to the stock take capture transactions generated for the selected LPNs.

This lets you indicate whether you want to include stock codes that are already captured.

This lets you exclude all stock codes with a zero variance.

Select this to include only full LPNs in the list (i.e., LPNs that are intended to be counted and captured as a complete handling unit.)

Indicate the sequence in which LPNs are displayed in the listview.

  • License Plate Number (LPN)

  • Bin

  • Container

License Plate Numbers

 Choose whether to capture the quantity of All bins, a Range of bins, or a Single bin.

Bins

Choose whether to capture the quantity of All LPNs, a Range of LPNs, or a Single LPN.

Containers

Choose whether to capture the quantity of All containers or for a Single container.

This lets you capture a new data record.

This saves the details you entered or changed.

This lets you select all lines in the listview.

This lets you deselect all lines in the listview.

Field Description

Selected

This indicates the selected stock codes for the stock take.

License plate number

This indicates the License Plate Number (LPN) assigned to the stock code.

Bin

This indicates the bin location for the stock item.

Full status

 This indicates whether the LPN is currently regarded as a full LPN for stock take purposes.

License Plate number details

This hyperlink allows you to maintain the LPN Details. When selected the Stock Take Capture LPN Details program will open.

Original quantity

This indicates the Inventory quantity for the stock item at the time the Stock Take Selection program was run.

Captured quantity

This indicates the counted quantity captured against the LPN.
Warehouse This indicates the warehouse in which the License Plate Number (LPN) exists.
Container This indicates the container which holds the stock against the License Plate Number (LPN).