Loading page
Dead Stock & Inventory Ageing
by TechnoVision · Odoo App
A warehouse can receive a fresh pallet on Monday of a product that has not shipped since March. By age it looks healthy; by movement it is dead capital. Conflating the two hides exactly the case worth finding.
Security Center
Live82
Score
1.2k
Events / 24h
3
Alerts
Export volume · 14 days
Unusual export detected
res.partner · 4,812 rows · outside business hours
Illustrative UI. Product screenshots to be dropped into this frame.
What it does
Days in Stock counts from when the goods arrived. Days Since Last Movement Out counts from the last outgoing move. They answer different questions and one number cannot do both.
0-30, 31-60, 61-90, 91-180, 181-365 days and over a year, with never-shipped stock flagged separately.
In the company currency, summed on every group, so the report answers how much money is stuck here.
Grouped by warehouse, location, category, product, age band or company.
Threshold, warehouses, categories, minimum value and age band - opening straight into a list or a pivot.
Optional, per warehouse, and sent only when there is something to report.
A single PostgreSQL view over stock quants and move lines. No table to build, no nightly job, and no second copy of your data. Correct the moment a move is validated.
Enforced by a record rule rather than left to filters.
Screenshots
4 reserved slots at 16:10, ready for real captures of the dashboard, activity log, sensitive-change detail and report builder.
How it works
Depends on stock and mail only. No external Python packages, no outbound network calls.
Inventory - Reporting. Group by warehouse or category to see where the value has settled.
Set a threshold, a minimum value and the warehouses that matter, then work the list.
Weekly, per warehouse, so the question gets asked without anyone remembering to ask it.
FAQ
Quantity times the product Cost field, read per company. It is not a stock-accounting valuation layer, so on products whose cost has changed it will differ from an FIFO valuation report - it is the right measure for money stuck here and the wrong one for a balance sheet.
No. It is a PostgreSQL view, so there is nothing to rebuild and nothing that can drift out of date.
Odoo restricts the Inventory Reporting menu to Inventory Managers itself. Inventory Users have read access to the model and can reach it through a link or an embedded view.
Stock with no done outgoing move line from its location - flagged separately rather than folded into the oldest age band.
Install from Odoo Apps, or talk to us about a guided rollout across multiple companies.