Apps › Reports and dashboards

Stock Aging & Dead Stock Report

How old the stock on your shelves is, product by product, dated first in first out from the stock moves, what it is worth at cost, and which part no longer moves.

Open the live demo Read the manual

Odoo 16Odoo 17Odoo 18Odoo 19Odoo 20

The aging matrix of an analysis on the demo: on-hand value by age bucket in rows and movement class in columns
The aging matrix of an analysis on the demo: on-hand value by age bucket in rows and movement class in columns
Runs onOdoo 16 to 20Community or Enterprise, self-hosted or Odoo.sh
NeedsInventory, Invoicingno Enterprise module
Price99 EURone-time, per series, on the Odoo Apps Store
Demodemo20.bambooforge.devlogin page already filled in
Supportsupport@bambooforge.devfirst reply within one business day
Version20.0.1.2.4bambooforge_stock_aging

26 automated checks run before every release of this app, the same suite on every series it ships for. The complete list is in the source you receive; run it yourself with --test-enable.

How you use it

From the stock moves to a decision

Flow 01

Run an analysis

For an Inventory Administrator.

  1. Stock Aging > Analyses, New: the reference date is today.
  2. Keep or change the five bucket limits and the dead-stock window (180 days).
  3. Compute: every product on hand gets its oldest age, bucket and movement class.
An aging analysis on the demo: reference date, dead-stock window, the five bucket limits, the total and dead values, and the results by product
Flow 02

Read the figures

For the inventory manager.

  1. The Products button opens the pivot: age buckets down, movement classes across.
  2. The list shows each product's quantity, value, oldest age and last delivery.
  3. Filter Dead Stock, Slow Moving or With Provision; group by bucket or category.
The lines of an aging analysis on the demo, grouped by age bucket, with on-hand quantity and value
Flow 03

Back on the product

For anyone who opens a product.

  1. The product's Stock Aging tab shows its days in stock, bucket and dead-stock flag.
  2. The product list filters Dead Stock and groups by Aging Bucket.
  3. The tab names the analysis the figures come from.
The Stock Aging tab of a product form on the demo: days in stock, aging bucket, dead-stock flag and the last analysis
Flow 04

Book the provision and decide

For finance and operations.

  1. Provision Rules: an age band, a percentage, optionally a category.
  2. Propose Provision Entry: a draft entry, expense debited, allowance credited.
  3. Stock Aging > Dead Stock: set the assignee and the disposition of each product.

Price and where to buy

99 EUR, one payment per Odoo series, on the Odoo Apps Store. Pick your series:

Twelve months of support by the people who wrote the code; bug fixes and improvements within the series free for as long as it is published. Report a bug within two months of purchase and, if it is not resolved within fifteen days, you get a full refund. Full source under OPL-1, no licence key, no phone-home. The whole promise.