Skip to Content

Odoo 19: the inventory aging report is gone, here is how to get it back

November 16, 2026 by
Odoo 19: the inventory aging report is gone, here is how to get it back

“The inventory aging report disappeared in Odoo 19.” The question keeps coming back on the Odoo forum, always the same: how do you know how long goods have been sitting on the shelf? And the usual answer, grouping the quants by incoming date, gives wrong ages. Here is why, what the standard can still do, and the free module I am publishing to fill the gap.

1. What Odoo 18 did, and what Odoo 19 removed

Up to Odoo 18, each receipt created a valuation layer (stock.valuation.layer) that kept its remaining quantity: as deliveries went out, the oldest layers emptied first. Grouped by date, these layers gave an inventory aging view: the inventory.aging view of the stock_account module.

Odoo 19 rebuilt valuation on the stock moves themselves. The layer model was removed, and the aging view went with it. A “remaining quantity” field remains on the moves, but it is computed on the fly, product by product, and no report sorts it into age brackets. I checked the Odoo 20 code: the gap is there too.

💡 Key takeaway

In Odoo 19 and 20, there is no longer a standard report that says “here is the value of your stock older than 180 days”.

2. Why the incoming date of quants lies

The workaround you read everywhere is to open the stock on hand and group it by incoming date. The problem: a quant is a quantity of one product at one location. When a new receipt arrives at the same location, Odoo merges the units into the existing quant. A single date then covers items received months apart.

Example: 4 chairs received 200 days ago, 6 received 3 days ago, stored in the same place. The stock shows one quant of 10 chairs, with one date. The 4 chairs that have been sitting there for over six months drop off the radar.

💡 Key takeaway

The age of stock cannot be read from the location; it has to be rebuilt from the entries.

3. The solution: match the stock with its entries

The Inventory Aging Brackets module adds Inventory › Reporting › Inventory Aging. You choose a reference date (today by default), a warehouse or a location, product categories, and your own age brackets: 0-30, 31-60, 61-90, 91-180, 181-365 and over 365 days by default.

The stock on hand at that date is matched with the entries that brought it in: receipts, manufacturing orders, inventory adjustments, customer returns. The oldest units go out first (FIFO). Each remaining part of an entry gets its age, quantity and value. You get a list grouped by bracket, a categories × brackets pivot table, a graph, and export to a spreadsheet.

On the value side: a FIFO product keeps the cost of each receipt; a product at average cost or standard price is valued at the product cost, as in the standard valuation. The age is computed the same way for every method. Periodic or automated valuation: both work, Odoo records the value of the moves in both modes.

💡 Key takeaway

Filtered on one warehouse, a transfer from another warehouse counts as an entry: the age restarts on the day of arrival. For the whole company, an internal transfer makes nothing younger.

⚔️ The Match: standard remaining quantity vs Inventory Aging Brackets

Criterion Standard Odoo 19 With the module
Age brackets None Configurable
Past reference date No Yes
Warehouse / location filter No Yes
SQL queries on 2,000 products ≈ 38,000 queries, 62 s ≈ 30 queries, 1 s

Measured on a test Odoo 19 Community database: 2,000 storable products (half FIFO, half average cost), three receipts at 400, 120 and 20 days, one delivery of 15 units per product. Standard = search for the moves with a remaining quantity, then read that quantity and its value.

4. What the module does not do

It changes nothing in the valuation: it reads the moves and their value, and writes the report into temporary tables. Two accepted limits: at a past date, an average-cost product is valued at its current cost; and lot valuation is not detailed lot by lot (the age stays right, the value follows the product cost). Consignment stock owned by a third party is excluded, as in the standard valuation.

The module is free (LGPL-3), for Odoo 19 and 20, Community and Enterprise. It does not work on Odoo Online, which does not accept custom modules. App page: Inventory Aging Brackets.

💡 Key takeaway

An aging report is there to make decisions: promotion, return to supplier, write-down provision. It has to be right before it is pretty.

The Verdict: the age of stock is rebuilt, not guessed

Odoo 19 simplified valuation, and the aging report left with the layers. The module brings it back from the moves, without changing your accounting.

Do your stock and your valuation tell the same story? I can check it with you during an Odoo audit.

Request a Free Audit
Odoo 19: the Description field of canned responses is gone, how to get it back