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 StoreMore Odoo sales apps
Sale Order Multi Warehouse
A fulfillment warehouse per order line with live stock and warehouse-specific margin beside it — bulk assignment, configurable routing defaults, a per-warehouse summary before confirmation, and automatic split deliveries.
Sale Order Recurring
Scheduled auto-generation of discrete sale orders with a pre-generation review queue, pause/resume/skip controls and a customer self-service portal — a separate order, picking and invoice for every delivery, not one rolling subscription record.
Sale Order Revision
Revise a confirmed order without cancelling it — clean version labels, full history, side-by-side comparison, a what-changed summary, and automatic alerts to the linked purchase and manufacturing orders.
Sale Order Status — Delivery, Payment & Blocker Insight
One clear view of delivery, payment, and the reason every order is stuck, built natively on Odoo.
Sale Order Versions
Snapshot, compare, and restore versions of quotations and sales orders with a full audit trail of who changed what, when, and why.
Sale Product By Location
A source location on every sale order line, splitting the order into one delivery per location automatically — with duplicate warnings, a defined fallback and a configurable customer-portal line.