OdooWiki OCA HUB

Account Invoice Report Lot Expiry Date

stock_account_invoice_report_lot_expiry folder_open OCA/account-invoice-reporting open_in_new
Accounting/Accounting License: AGPL-3

This module extends the invoice report to show the expiration date for each tracked lot in the invoiced lots summary table.

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Adds an Expiration Date column to the lots table on the customer invoice PDF, so each tracked lot listed on the invoice shows its expiry date.

When you print a customer invoice that includes tracked products, Odoo shows a summary table of the serial or lot numbers that were invoiced. This module adds one extra column to that table, called Expiration Date.

  • The new column appears in the header of the invoiced lots table on the invoice report.
  • For each lot line, the report looks up the lot record and prints its expiration date, formatted as a date.
  • If a lot has no expiration date recorded, the cell is simply left empty.

The change only affects the invoice PDF layout; it does not add menus, buttons, settings or new screens, and it does not change how invoices, stock moves or lots are created or validated. It relies on the standard lot tracking and expiry features already provided by the Inventory and Accounting apps, so the expiration date must already be filled in on the lot itself for it to show up.

In short, it is a small reporting improvement for businesses that sell perishable or dated goods and need the expiry information visible directly on the invoice they send to customers.

Depends on

stock_accountproduct_expiry

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-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 2 confirmed, 7 with no information of 9 versions.

Sources · Odoo 16.0

Confirmed on 2026-11-03 in branch 16.0 of OCA/account-invoice-reporting.

terminal Installation and usage

OCA documentation · Odoo 18.0

To use this module, you need to:

  • Enable the Display Lots & Serial Numbers on Invoices setting.
  • Create or use a product tracked by lots with expiration dates enabled.
  • Deliver and invoice a lot-tracked product.
  • Print the invoice.

The invoiced lots summary table will include an Expiration Date column.

No verified information in OCA: Installation, Configuration.

info

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.