| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 258 |
| Technical Name |
lv_nova_lot_expiry |
| License | OPL-1 |
| Website | https://www.luanviservices.com |
Lot Expiry Dates on Deliveries & Invoices
Know the expiry status of every lot before you ship or invoice. This module adds expiry date columns and color-coded status badges to delivery orders, receipts and customer invoices — and includes the lot and expiry information in the printed PDF documents.
🏭 Delivery & receipt orders
Expiry Date and Status columns in the Detailed Operations tab. Alert banner when the picking has expired or expiring-soon lots.
🧾 Customer invoices
Each invoice line shows the lot numbers and expiry dates from the related deliveries, automatically resolved via the sale order.
🖨 PDF reports
Expiry dates appear in the printed Delivery Slip and on the Invoice PDF — essential for food, pharma and cosmetics audits.
🎨 Color-coded alerts
Three levels: expired (red), expiring within 30 days (orange), OK (green). Warning threshold is configurable in the module code.
Alert levels
Where it shows
- Stock Picking form: "Expiry Date" and "Status" columns in the Detailed Operations tab. Banner alert at the top if any lot is expired or close to expiry.
- Invoice form: "Lots / Expiry" column after the Product column in the invoice lines list.
- Delivery Slip PDF: Expiry Date column added to the lot/serial section.
- Invoice PDF: Lot numbers and expiry dates printed as a sub-line below each invoice line.
Compatibility
Odoo 18.0 Community Enterprise Requires: Inventory, Accounting, Expiration Dates (product_expiry)
Technical notes
- Reads expiry dates from
stock.lot.expiration_date— requires the Expiration Dates module to be enabled (Inventory → Configuration → Settings → Traceability → Expiration Dates). - Invoice lots are resolved via the sale order line's stock moves. Works for sales invoices and vendor bills.
- The 30-day warning threshold can be changed by editing the
EXPIRY_WARNING_DAYSconstant inmodels/stock_move_line.py. - No new database tables — all fields are computed on the fly.
Support
For questions or bug reports, please use the support button on the App Store or email luanviservicesinfo@gmail.com.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 258 |
| Technical Name |
lv_nova_lot_expiry |
| License | OPL-1 |
| Website | https://www.luanviservices.com |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module