Sale Order Multi Lot Selection for traceable stock
Commit specific lots to a sales order line with live, reservation-aware availability, expiry visibility, and one-click FEFO quick-fill — built natively on Odoo Sales and Inventory.
The problem
Lot and serial assignment happens only on the delivery order, so the salesperson cannot promise a specific batch, honor a customer's lot preference, or see whether the exact stock being committed is actually free. Orders that need several lots to cover one line are tracked in spreadsheets or warehouse phone calls — error-prone and untraceable.
The solution
Select and split the ordered quantity of a sales order line across specific lot or serial numbers right on the quotation, with live reservation-aware availability and expiry dates in view, a one-click FEFO fill to propose the soonest-expiring lots for review, and hard validation that the allocation always matches the line quantity before it ever reaches the warehouse.
Everything a lot-tracked order needs
Every capability below is implemented in the module.
Multi-Lot Allocation
Split one order line's quantity across as many lot or serial numbers as needed, with a running allocated-versus-ordered indicator right in the picker.
Reservation-Aware Availability
Every lot shows on-hand quantity minus what other orders have already reserved, so two salespeople can never commit the same units.
Expiry-Visible Picker
Expiration dates are shown for every lot in the selection list, so perishable and regulated stock is never committed blind.
One-Click FEFO Quick-Fill
Populate the picker with the soonest-expiring lots in one click, then review and override before confirming — the speed of automation with full manual control.
Hard Allocation Validation
The sum of per-lot quantities must match the ordered quantity exactly before the line can proceed, eliminating the sum-mismatch errors that reach the warehouse today.
Overselling Prevention
Committing more of a lot than is actually available is blocked at selection time, not discovered at the delivery order.
Delivery Propagation
The lots chosen on the sales order flow through automatically to the delivery order, so the warehouse ships exactly what was promised.
Single-Lot Fast Path
Simple lines that only need one lot stay frictionless — the picker never forces a multi-line split when one lot fully covers the quantity.
Selection Reason & Audit Trail
Every lot line records why it was chosen — manual pick or FEFO quick-fill — giving regulated buyers a record for reconciliation and recall.
How it works
Open the Picker
Click the Lots button on any order line for a lot or serial-tracked product.
Select or Quick-Fill
Add lots manually or use FEFO Quick-fill to propose the soonest-expiring stock.
Confirm Allocation
A live indicator confirms allocated quantity matches the ordered quantity exactly.
Ship the Right Lots
Confirm the order and the chosen lots flow through to the delivery automatically.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
No. FEFO Quick-fill only populates the picker with the soonest-expiring lots for you to review, edit, or remove — nothing is committed until you close the dialog with a matching allocation.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Sale Order Multi Lot Selection
Commit specific lots to a sales order line with live, reservation-aware availability, expiry visibility, and FEFO quick-fill.
Buy on Odoo App Store