LPN Lookup
What this does
LPN Lookup is the warehouse-level directory of every LPN (licence plate number, usually a pallet) that has existed in a warehouse. That includes active, shipped and deleted LPNs.
For each LPN, Teamship stores and shows:
- What is on it (SKUs, batch or custom attributes, available quantity)
- Where it is (location and zone)
- Where it came from and where it went (created from, shipped from, shipped date)
- Who created, changed, quarantined, deleted or closed the order for it, and when
- Storage type, storage charge, dimensions and weight
- A full LPN history of every movement and change
LPN Lookup is also where warehouse users generate and print LPNs, relocate them, tag them, quarantine them, change their storage type and delete them.
When to use
Use LPN Lookup to:
- Find where a pallet is and what is on it
- Check whether an LPN has been shipped or deleted, and by which order or user
- Trace the full history of a pallet when stock doesn't match
- Generate and print new LPNs or tote LPNs
- Quarantine a pallet for quality or compliance review
- Export LPN data for audits or customer reporting
Where LPN Lookup starts
- Go to Warehouse.
- Open the Actions menu for the warehouse.
- Select LPN Lookup.
The LPN table
Each row is one LPN. Expand a row to see its child rows: one row per SKU on the LPN.
LPN status
Every LPN has a status:
| Status | Meaning |
|---|---|
| Active | The LPN is in the warehouse |
| Shipped | The LPN was shipped out on a shipping order |
| Deleted | The LPN was deleted and was not shipped |
By default, LPNs are listed by LPN number, newest first, and shipped and deleted LPNs are hidden. Use the Shipped and Deleted options to include them.
A regular LPN is marked Shipped automatically once all of its product has shipped out, either a little at a time or when the whole LPN ships.
LPN-level columns
| Column | What it shows |
|---|---|
| LPN | The LPN number. Select it to open the LPN history. |
| LPN Status | Active, Shipped or Deleted |
| Items | Number of unique SKUs on the LPN |
| Location / Zone | Where the LPN is, and the zone of that location (for example Regular or Picking) |
| Tags | Tags added to the LPN |
| Quarantined | Yes or No. Quarantined LPNs also show a lock icon. |
| Quarantine Modified By / Quarantine Modified At | Who last added or removed the quarantine, and when |
| Created By / Created Date | Who created the LPN, and when |
| Created From | Where the LPN was created, for example an inventory order (linked), a transfer order, Product Relocate or LPN Lookup |
| Last Modified By | Who last changed the LPN |
| Shipped From | The shipping order the LPN left on, linked to that order |
| Shipped Date | The date the LPN shipped |
| Closed by | Who closed the order. Shown by default. |
| Deleted At / Deleted By | When the LPN was deleted, and by whom |
| Dimensions (Inches) / Weight (LBS) | Pallet dimensions and weight recorded on the inventory order |
Dimensions and Weight are not part of the system view. Add them to a custom view from the column list. They are also available as optional columns in Ship by LPN.
Location is shown only at LPN level, not for each SKU.
Child rows (SKUs on the LPN)
Each child row shows:
- SKU
- Batch and any custom attribute fields and values
- Available: stock and unit of measure (UOM)
- Available Units
- Storage Type and Storage Charge
Quarantined SKUs, or SKUs on a quarantined LPN, show the lock icon.
Tote LPNs
Tote LPNs have a visual marker in the table. They behave differently from regular LPNs:
| Regular LPN | Tote LPN | |
|---|---|---|
| Created from | Receiving, relocations, LPN Lookup | LPN Lookup only |
| Marked as shipped automatically | Yes, once all its stock ships | Never |
| Stock from more than one customer | Not allowed | Allowed |
| Must be in a picking location to pick into | Yes, for picking LPNs | No. Any location works. |
Tote LPNs can be relocated, deleted and have products relocated to and from them the same way as other LPNs. In the pick flow, the tote field accepts only tote LPNs.
Searching and filtering
The table supports column selection, filtering, sorting, grouping (for example Group by LPN) and saved views.
- Search by company name to find a customer's LPNs.
- Search quarantined to list every quarantined LPN.
- When a search matches a SKU, the matching child row is highlighted.
Actions
Select one or more LPNs, then open the Actions menu.
Generate and print LPNs
- Select Generate LPN. You don't need to select a row first.
- Enter how many LPNs to create.
- To create totes, tick This is a Tote LPN. It is unticked by default.
- Choose a warehouse printer and print the labels.
Use Print LPN to reprint labels for existing LPNs.
Relocate
From LPN Lookup you can relocate a whole LPN to another location, or move products between LPNs with Product Relocate.
Moving between regular and picking locations
- When an LPN moves into a picking location, it becomes a picking LPN. Its stock is removed from inventory (bulk) stock and added to ecommerce stock.
- When it moves back to a regular location, the opposite happens.
- If the LPN holds batched stock, you'll be asked to confirm, because moving it to a picking location removes the batch.
- Inventory is synced to connected order platforms after the move.
- Picking LPNs don't appear in Ship by LPN.
The same rules apply in Relocate by Scan.
An LPN can hold stock for only one customer. If a move would mix customers on a regular LPN, you'll see Stock of multiple customers is not allowed on the same LPN.
Tags
Add, edit or remove tags on one or more LPNs. Enter several tags separated by commas.
Quarantine
Mark an LPN as quarantined, or remove the quarantine.
- Only non-picking LPNs can be quarantined.
- Deleted LPNs cannot be quarantined (Deleted LPNs cannot be quarantined).
- Quarantined LPNs can't be shipped, manually or through bulk import. Shipping orders that contain them can't be completed until the quarantined LPNs are removed.
Change storage type
Change the pallet storage type of an LPN. The change is recorded in LPN history and is used for storage charges.
When units are replenished into a picking LPN, or a new pallet is created through Product Relocate or Update Inventory Stock, the LPN picks up the pallet storage type so that monthly storage covers it.
Delete
Deleting an LPN:
- Asks for a delete reason
- Removes the stock from the LPN and from inventory stock
- Adds a line to the product's inventory history
- Removes the LPN from the inventory order's pallet list
The LPN stays in LPN Lookup with status Deleted, along with Deleted At and Deleted By.
Create bulk inventories / LPNs
Use these actions to load LPNs and stock in bulk, for example when setting up a new warehouse.
- Bulk LPN create imports a list of LPNs from a template.
- Bulk inventories imports stock into existing LPNs. The template has LPN number, customer, SKU, custom SKU attributes and stock columns.
Rules for importing inventory:
- The LPNs must already exist in the warehouse.
- Each SKU and attribute combination can appear only once in the file. Duplicates are rejected.
- Stock can be imported into an LPN only once. If the LPN already holds stock, the import is rejected.
After the import, LPN stock and inventory stock are updated and the product history shows the import.
Exporting
| Export | What it contains |
|---|---|
| Excel export | Every LPN and its child rows, with the columns on screen. Includes tags, quarantine, custom attributes, Tote LPN (Yes/No), and Available and UOM as separate columns. |
| LPN report | One row per LPN with all LPN-level columns and Tote LPN (Yes/No), without child rows. Run it from the Actions menu. A loader shows while it downloads. |
Grouping, such as Group by LPN, stays applied after you export.
LPN history
Select any LPN number to open its history. Events are listed newest first, and every column can be filtered and sorted.
LPN history records:
| Area | Events |
|---|---|
| Creation and setup | LPN created, renamed, assigned to a location, converted to a tote, printed, tags added, edited or removed |
| Receiving | Received on an inventory or transfer order, products added, quantities adjusted, received into a new location, staged |
| Storage and movement | Putaway, relocated (including Relocate by Scan), replenished, moved to another warehouse by transfer order |
| Picking | Products picked, picks cancelled or returned, assigned to a shipping order or batch, stock moved to a tote, quantity deducted on bulk ship, outbound scan steps |
| Packing and shipping | Quantity deducted from a tote when an order closes, LPN shipped, who closed the order |
| Quality control | Quarantined, released from quarantine |
| Administration | Deleted, storage type or storage charge changed, bulk created, stock imported |
Roles and permissions
Warehouse users and administrators
LPN Lookup is available to admins, org admins, warehouse managers and warehouse associates. These roles can:
- View, search and export LPNs
- Generate, print, relocate, tag and delete LPNs
- Quarantine and release LPNs
- Change storage types
Customers
- Don't have access to LPN Lookup
- See quarantined LPNs only on the Ship by LPN view
Common issues
| Issue | Likely cause |
|---|---|
| A shipped or deleted LPN isn't listed | Shipped or Deleted isn't selected. They are hidden by default. |
| Can't quarantine an LPN | It is a picking LPN or it has been deleted |
| A shipping order can't be completed | It contains a quarantined LPN or SKU |
| Stock of multiple customers is not allowed on the same LPN | The LPN already holds another customer's stock. Only tote LPNs can mix customers. |
| An LPN doesn't appear in Ship by LPN | It is in a picking location, so it's a picking LPN |
| Batch is missing after a relocation | The LPN was moved to a picking location, which removes the batch |
| Dimensions or Weight isn't shown | The columns aren't in your view. Add them to a custom view. |
| Bulk inventory import is rejected | The LPN doesn't exist yet, already holds stock, or the file has duplicate SKU and attribute rows |
| A tote LPN never shows as shipped | Expected. Tote LPNs are never marked as shipped. |