Sale Stock Expiry Date on Qty at Date widget
This module extends the functionality of Qty at Date Widget to display next Expiry Date and to allow you to inform your customers properly about the goods they are going to purchase.
auto_awesome What this module does
AI-generated from the code · Odoo 18.0Shows the next expiry date of the stock that will be used to fulfil a sales order line, directly in the Qty at Date popover, and lets users open the related stock quants.
When you sell a product that is tracked with expiry dates, this module adds a "Next Expiry Date" line to the Qty at Date popover on sales order lines. The date is calculated from the available stock in the warehouse, taking the earliest expiry date among the lots that would be needed to cover the ordered quantity.
The popover also gets a "View Stock" button that opens a list of the stock quants for that product in internal locations, so you can inspect the lots and their expiry dates. A dedicated Quants action and views are provided for this.
On the sales order form, the predicted expiry date is added as a hidden field in the order lines list, form and kanban views so the widget can display it. The stock quant list view is made read-only (no create, edit or delete) and a kanban view shows product, available quantity, lot, removal date, owner, package and location.
The calculation only applies to products that use expiration dates. It looks at available quantities in the warehouse's stock location and picks the earliest expiration date among the lots that would be consumed for the ordered quantity.
Depends on
Models and fields (1)
- sale.order.line · extends an existing modelpredicted_first_expiration_date
Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 2 confirmed, 7 with no information of 9 versions.
Sources · Odoo 18.0
Confirmed on 2026-11-03 in branch 18.0 of OCA/sale-workflow.
terminal Installation and usage
OCA documentation · Odoo 18.0Installation
Source · Odoo 18.0In order to use this module, you need to install those modules:
- sale_management
Configuration
Source · Odoo 18.0In order to configure this module, you need to:
- Go to Inventory > Settings > Traceability and enable Expiration Dates
- Enable an user with only this permissions:
- Sales: User: Own Documents Only
- Technical: Manage Lots / Serial Numbers
Usage
Source · Odoo 18.0To use this module, you need to:
- Create an product with Type Goods and Track Inventory by Lots or S/N and check Expiration Date
- Fill stock of this product with Lots and Expiration Dates
- Create a new Sale and select the product you've configured previously
- Check the Widget that shows info about the stock
- Check the next Expiration Date is correctly set
- Click on View Stock to see all Quants and its Expiration Dates
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.