How old is your stock? The aging report is back in Odoo 19 and 20

Up to Odoo 18, the valuation layers kept the remaining quantity of each receipt: grouped by date, they gave the age of the stock. Odoo 19 removed these layers with nothing in their place, and so did Odoo 20. Inventory Aging Brackets rebuilds the report from the stock moves: quantity and value by age bracket, at the date of your choice. Free, for Odoo 19 and 20, Community and Enterprise.

  • Free
  • Odoo 19 · 20
  • Community & Enterprise
  • Odoo.sh

No view of stock age any more

Sleeping stock costs space and cash, and Odoo 19 no longer shows it.

The layers are gone

Odoo 19 removed the valuation layers, and with them the remaining quantity per receipt that served as an aging report.

Wrong quant dates

Grouping quants by incoming date does not work: a new receipt merges with the quant already there, and one date ends up covering units received months apart.

No value per bracket

There is no way to tell what the stock older than 180 days is worth, or in which category it sleeps.

What Inventory Aging Brackets does

Each unit on hand is traced back to the entry that brought it in, oldest units out first.

Real ages

The stock on hand is split between the entries that brought it in (receipt, manufacturing, inventory, customer return). Two receipts merged into one quant keep their two ages.

Your brackets, your scope

Any reference date, a warehouse or a location, product categories, and your own brackets: 0-30, 31-60, 61-90, 91-180, 181-365 and over 365 days by default.

Quantity and value

FIFO products keep the cost of each receipt. Average and standard cost products are valued at the product cost, like the stock valuation.

List, pivot, graph

A list grouped by bracket, a categories × brackets pivot you can expand to products, a graph, and export to a spreadsheet.

Fast on a large catalogue

One pass for all products: about thirty queries, whether you have 20 or 2,000 products.

Other people’s stock left out

Consigned stock, owned by a third party, is left out, as in the stock valuation.

Odoo 19 inventory aging report grouped by age bracket, with receipt, entry date, age in days, quantity and value
Stock grouped by bracket: each line is an entry, with its age, remaining quantity and value.
Odoo pivot of stock value by product category and age bracket, in FIFO and average cost
The pivot crosses categories and brackets: you see at once where the value sleeps.

Three clicks

  1. Open the report

    Inventory › Reporting › Inventory Aging: reference date (today by default), warehouse or location, categories and brackets.

  2. Read the stock by bracket

    The list groups the stock by age bracket. Filters show what is older than 90, 180 or 365 days.

  3. Analyse and export

    The pivot crosses categories and brackets, down to the product. List and pivot export to a spreadsheet.

Frequently asked questions

The number of days between the reference date and the entry that brought the unit into your stock: a receipt, a manufacturing order, an inventory gain or a customer return. The oldest units are assumed to leave first, which is how Odoo values FIFO stock.
Ages are computed the same way. Only the value differs: the remaining quantity at the current product cost. For a past date, today’s cost is therefore applied.
For the whole company, an internal transfer keeps the age of the goods. Filtered on one warehouse, goods coming from another warehouse start their age on the day they arrived.
Yes. On 2,000 products, Odoo’s standard remaining quantity search needs about 20,000 queries and 30 seconds just to find the moves; this report about thirty queries and one second.
The report covers one company at a time and does not detail by lot or serial number. It works with periodic and automated valuation.
Odoo 19 and 20, Community and Enterprise: the module only depends on stock valuation. It works on Odoo.sh and on your own server, not on Odoo Online.

Is your stock sleeping more than you think?

Tell me how you tracked stock age before Odoo 19: I show you what your stock looks like, bracket by bracket.