Lots and expiration dates in Settle allow users to manage inventory at a granular level, tracking specific batches of products or raw materials with associated expiration dates. This functionality is essential for ensuring compliance, maintaining product quality, and optimizing inventory management.
Settle supports two types of lots:
Lots on Finished Goods: Consumed by sales orders, typically tracked at Warehouse Management System (WMS) connected locations.
Lots on Raw Materials: Consumed by transfers and work orders (WOs), often tracked at manually managed locations.
Key features
Stock Screen Visibility: View inventory lots at a product-by-location level.
Snapshot Updates: Manually add and update lot-level data for manually managed locations.
Lot Selection: Allocate inventory to specific lots during manufacturing and ordering processes.
👉 Read more on how to manage your inventory in Settle.
How to view lots on the stock screen
The Stock Screen groups inventory by:
Product
Location
Lot Details
For WMS-connected locations:
Lot data is automatically collected through nightly inventory snapshots.
For manually managed locations:
Counts are handled via snapshots and ordering documents.
Note: Inventory at the lot level may not always sum up to the product-level inventory, especially in cases where discrepancies are introduced (e.g., sales orders). For WMS-connected locations, these are reconciled nightly.
How to add lots for manually managed locations
When entering or updating snapshots for manually managed locations, users can now include lot information.
Steps to add lot information:
Navigate to the Location Screen for the relevant inventory.
Select Add Snapshot.
Enter the following details:
Product name/SKU
Quantity on hand
Lot number(s)
Expiration date(s)
Save the snapshot.
👉 Learn more about manually managed locations in Settle.
How to select lots on ordering documents
When using lots in transfers or work orders, you must allocate all units to specific lots.
Open the relevant ordering document (Transfer or Work Order).
Select the lot(s) to allocate inventory.
Ensure all units in the transaction are fully assigned to one or more lots.
How often do lots update?
Lot-level inventory data is updated nightly at 00:00 UTC for WMS-connected locations. This ensures that any discrepancies introduced during the day are corrected automatically.
For manually managed locations, updates are made via user-entered snapshots or ordering documents.