Odoo Inventory Reports: Stock, Valuation, Aging and Forecast in 19/20
Odoo inventory reports in Odoo 19 and 20: where the stock, valuation, aging and forecast reports sit, what each answers, and when to build custom ones.
Most teams ask for custom inventory reports before they have seen what Odoo already ships. Our Odoo customization services start by checking every request against the standard Odoo inventory reports, so you only pay to build what is truly missing.
Related service: Odoo for logistics — shipping, tracking and warehouse operations in one place.
This guide is for operations managers, controllers and Odoo admins on Odoo 19 or 20. It focuses on the reports themselves. For how warehouses, routes and locations are set up behind them, see our Odoo warehouse management guide.
Which Odoo inventory reports come standard in Odoo 19 and 20?

Odoo inventory reports live mostly under Inventory > Reporting, with valuation in Accounting and dashboards in the Dashboards app. Each one answers a different question, so pick the report by the question, not by its name.
| Report | Where to find it | Question it answers | Odoo 19 | Odoo 20 |
|---|---|---|---|---|
| Stock | Inventory > Reporting > Stock | What do we hold and what is it worth? | Yes | Yes, with inline date picker |
| Locations / Detailed Stock | Inventory > Reporting | Where exactly is each lot or unit? | Locations | Renamed Detailed Stock |
| Moves History | Inventory > Reporting > Moves History | What moved, when and why? | Yes | Yes, adds Scrapped filter |
| Moves Analysis | Inventory > Reporting > Moves Analysis | Planned vs actual, value per move | Yes | Yes, with Aging Report favorite |
| Forecasted | Product > Forecasted button | Will we run short, and when? | Yes | Yes, with Assign from forecast |
| Inventory Valuation | Accounting > Review > Inventory Valuation | Does stock value match the books? | Yes | Yes |
The Inventory Reporting menu is only open to users with admin access to Inventory, as the Odoo 20 stock report documentation notes. Plan who needs which report before you hand out admin rights.
How does the Odoo stock report work?
The Odoo stock report is the main list of every stored product, showing quantities and value side by side. It is the first place to look for "what do we have and what is it worth".
The columns are Product, Unit Cost, Total Value, On Hand, Free to Use, Incoming and Outgoing. Free to Use is on-hand stock not reserved for orders. Incoming comes from confirmed purchase orders, and Outgoing from confirmed sales or manufacturing orders.
Each row has buttons for History, Replenishment, Locations and Forecast. The left panel filters by warehouse and product category, and you can save a filter as a shared favorite for your team.
In Odoo 20 the old separate wizard is gone. Our Odoo 20 Inventory release notes show the new Inventory at Date picker at the top of the side panel, which recomputes quantities and values at a precise date and time while keeping your filters.
Where is the Odoo inventory valuation report in Odoo 19 and 20?
In Odoo 19 and 20 the per-product valuation sits in the Stock report, and the accounting view sits in Accounting > Review > Inventory Valuation. Teams coming from Odoo 18 often miss this move.
On the Odoo forum, a user who upgraded asked where the Odoo 18 valuation report went. In Odoo 18 it lived at Inventory > Reporting > Valuation. The answer was to use the Stock report, grouped by product or category, with Unit Cost and Total Value.
The accounting report has a different job. The Odoo 20 inventory valuation documentation lists Initial Balance, Stock Variation and Ending Stock, plus Inventory Loss and Cost of Production for periodic valuation. Stock Variation is the gap between posted value and the Inventory app.
This post covers where the reports are, not how FIFO or AVCO change the numbers. For costing methods and upgrade checks, compare the valuation lines in a test database before you change anything in production.
Is there an Odoo stock aging report?
Yes, Odoo 20 adds a stock aging report as a saved favorite in Moves Analysis, and Odoo 19 shows ageing charts in the Warehouse Metrics dashboard. Neither one gives classic 0 to 30, 31 to 60 and 61 to 90 day buckets out of the box.
In Odoo 20, open Moves Analysis, switch to pivot and pick Favorites > Aging Report. The Moves Analysis documentation says it groups rows by product category and product, columns by month, with Remaining Quantity and Remaining Value.
Know the limits before you rely on it:
- Excluded stock: consignment and dropship moves are not valued, so they do not appear in the Aging Report.
- Month columns, not buckets: you read age by month of receipt, not by a fixed day range.
- Dashboard date logic: the Warehouse Metrics ageing chart shows only the first receipt date for products without lots, unless stock went down to zero.
- Edition: the Warehouse Metrics dashboard runs on the Dashboards app, which uses Spreadsheet, an Enterprise app.
The inventory dashboards documentation describes the ageing charts by product and creation date. If finance needs fixed day buckets, that is a good first custom report.
How does the Odoo forecasted report help with planning?
The Odoo forecasted report shows projected stock over time, so planners see shortages before they hit an order. It is opened from the Forecasted smart button on a product, or from a line on a sales or purchase order.
The graph shows On Hand, Incoming, Outgoing and Forecasted. The table lists each operation with its receipt date, units, what the stock is used by, and forecasted stock with and without pending moves. A negative forecast is an early warning that demand exceeds supply.
Only confirmed documents count. The Odoo 20 forecasted report documentation says RFQs do not change the forecast until confirmed, while confirmed sales orders lower it and confirmed manufacturing orders affect both components and finished goods.
Odoo 20 adds an Assign link on forecast lines, so a planner can tie an incoming receipt to a waiting order in one click. The old reception report is replaced by a new allocation report, so any customization of it must be moved during the upgrade.
Odoo moves analysis vs moves history: which one to use?
Use Moves History for an audit trail of completed moves, and Odoo Moves Analysis for planned versus actual and the value of each move. They look alike but answer different questions.
| Need | Moves History | Moves Analysis |
|---|---|---|
| Who moved what, from where to where | Yes | Yes |
| Lot or serial on each move | Yes | Optional column |
| Demand vs quantity actually moved | No | Yes |
| Value and remaining value per move | No | Yes |
| Pivot and graph by month or location | Limited | Yes, four views |
| Correct a single move's value | No | Yes, Adjust Valuation |
Moves Analysis is the better place to catch under-deliveries, partial picks and manufacturing orders that used more components than planned. In Odoo 20 it also shows when a late landed cost changed the value of goods already shipped.
How do you find dead, stranded or miscounted stock in Odoo?
The Odoo 20 Detailed Stock report, called Locations in Odoo 19, turns three saved filters into dead stock, stranded stock and discrepancy reports. It needs the Storage Locations setting turned on.
- Dead stock: filter on Internal Locations plus Expired Lots (Expiration Alerts in Odoo 19) to list expired items.
- Stranded stock: search a transit location such as WH/Input or WH/Packing to find goods never put away.
- Discrepancies: filter on Internal Locations plus Conflicts to see items that changed since the last count.
- Past position: in Odoo 19 use the Inventory At Date button on the Odoo 19 Locations report; in Odoo 20 use the Incoming Date filter.
The discrepancy view is only as good as your counting habits. Our guide to fixing stock discrepancies with cycle counts explains how to set count frequencies so this report stays short.
What changed in Odoo 20 inventory reporting?
Odoo 20 mostly improves existing reports rather than adding new menus, with the aging view as the main new feature. These are the changes that affect reporting users.
| Change | What it means for reports |
|---|---|
| Stock aging report | New Aging Report favorite in Moves Analysis pivot |
| Inventory at a past date | Date and time picker inside the Stock report |
| Allocation report | Assign from forecast; reception report replaced |
| Traceability report | Upstream and downstream lots in one tree |
| COGS update | Late cost changes revalue goods already shipped |
| Locations renamed | Locations report is now Detailed Stock |
If you upgrade from Odoo 19, check bookmarks that used the old at-date wizard and any custom code on the reception report. Our Odoo upgrade services include testing saved reports and custom report templates on a copy of your database.
Where do standard Odoo inventory reports stop?
Standard reports stop where a question needs history netted over time, fixed buckets, or a layout built for outsiders. These are the gaps we see most often.
- Lots at a past date: a forum user found the Stock report at a date shows quantities by product only, not by lot or serial; the suggested workaround is a saved filter with a date context in developer mode.
- Stock card with running balance: Moves History lists moves but does not net them into an opening and closing balance per product.
- Aging buckets: month columns exist in Odoo 20, but fixed day buckets with a value per bucket need a custom view.
- Turnover and FSN classes: fast, slow and non-moving labels are not standard.
- Printable packs: an auditor or bank often wants a signed PDF, which list views do not produce.
When should you build Odoo custom reports?
Build Odoo custom reports only after a saved filter, pivot or spreadsheet has failed to answer the question. Each step up costs more to build and to maintain at upgrade time.
| Option | Best for | Edition and effort | Upgrade risk |
|---|---|---|---|
| Saved filters and pivots | Recurring views of standard data | All editions, minutes | Very low |
| Spreadsheet and Dashboards | KPI boards, mixed sources, global filters | Enterprise, hours | Low |
| Studio fields and reports | A missing field or simple PDF | Enterprise, Custom plan | Low to medium |
| QWeb PDF report | Branded stock cards, audit packs | Developer, days | Medium |
| SQL view or custom module | Aging buckets, running balances, heavy volume | Developer, days to weeks | Medium to high |
Spreadsheet data linked to Odoo refreshes each time the sheet opens, so a pivot inserted from Moves Analysis stays current. Spreadsheet and Studio are Enterprise only, as the Odoo editions comparison shows.
For PDF layouts, our Odoo QWeb report guide walks through templates. For threshold alerts on stock KPIs, see Odoo dashboards and alerts.
Use this order before you commission a build:
- Write the exact question and who reads the answer.
- Try the matching standard report and a saved favorite.
- Insert the pivot into a spreadsheet if you need totals or charts.
- Add a Studio field only if a value is missing.
- Build QWeb or SQL only when the first four fail.
Which inventory reports matter most by industry?
The report that matters most depends on what drives your stock cost. Retailers watch slow movers, manufacturers watch components, and food firms watch expiry.
| Industry | Pain or cost driver | Odoo approach | How iVentureTeam helps |
|---|---|---|---|
| Retail | Slow movers across branches | Stock report by warehouse, Aging Report | Set up Odoo ERP for retail views per branch |
| Manufacturing | Component shortages stop lines | Forecasted and manufacturing forecast | Tune Odoo ERP for manufacturing planning reports |
| Food and drink | Expired lots and write-offs | Detailed Stock with Expired Lots filter | Add expiry alerts and dead stock favorites |
| Wholesale | Capital tied in idle stock | Moves Analysis aging, stock rotation | Build aging buckets if months are not enough |
| eCommerce | Overselling on fast items | Free to Use and forecast | Align channel stock with forecast |
How iVentureTeam helps with Odoo inventory reports

We start with your reporting questions, answer most of them with standard Odoo reports, and build only the gaps. We have delivered 150+ ERP projects across 35+ countries with 40+ Odoo specialists, led by a consultant with 13+ years in Odoo.
- Report audit: we map each request to the Stock, Moves Analysis, Forecasted or Valuation report and save shared favorites.
- Valuation tie-out: we reconcile the Stock report Total Value with Accounting > Review > Inventory Valuation.
- Odoo 20 upgrade checks: we test aging views, at-date bookmarks and allocation customizations on a copy.
- Custom builds: aging buckets, stock cards and audit packs built by our Odoo development company team to survive upgrades.
- Budget first: get an indicative number from the Odoo project estimate tool before you commit.
Odoo inventory reports case study: Indep Consulting SPRL
A Belgian cleaning-chemicals company got stock and stock rotation reports as part of 8 custom SQL reports on Odoo. It is a loose fit: the case page does not state an Odoo version, and the reports were written in SQL, not built on the Odoo 19 or 20 views above.
Indep Consulting sells cleaning chemicals, equipment and maintenance contracts. Sales, stock and accounting sat in separate tools, so questions like product margin or vendor spend were slow to answer.
Over 12 weeks we rolled out Sales, CRM, Inventory, Accounting and eCommerce in one Odoo system. We then wrote 8 SQL reports, including product margin, vendor summary, stock and stock rotation, to expose profitability and slow movers.
The case page reports a management reporting cycle twice as fast. Read the Indep Consulting Odoo SQL reporting case study for the full scope.
The bottom line on Odoo inventory reports
Odoo 19 and 20 already answer most inventory questions; the skill is knowing which report answers which question. Odoo 20 closes the biggest gap with its aging view.
Use the Stock report for quantity and value, Accounting for the tie-out, Forecasted for shortages and Moves Analysis for aging and move value. Build custom reports only for fixed buckets, running balances or printable packs.
Ready to get the inventory reports your team actually needs?

Tell us the questions your managers ask, and we will show which Odoo report answers each one. Request an Odoo inventory reporting review, call +91-90235-15208, or email business@iventureteam.com.
Frequently Asked Questions
What inventory reports does Odoo have?
+
Odoo includes the Stock, Detailed Stock (Locations in Odoo 19), Moves History, Moves Analysis and Forecasted reports in Inventory, plus Inventory Valuation in Accounting. Enterprise adds inventory dashboards in the Dashboards app.
How do I get an inventory valuation report in Odoo 19?
+
Go to Inventory > Reporting > Stock and group by product or category to see Unit Cost and Total Value. For the accounting view, use Accounting > Review > Inventory Valuation, which shows Initial Balance, Stock Variation and Ending Stock.
Does Odoo have a stock aging report?
+
Yes. Odoo 20 adds an Aging Report favorite in the Moves Analysis pivot, showing remaining quantity and value by product and month. Odoo 19 Enterprise shows ageing charts in the Warehouse Metrics dashboard.
Can I see stock at a past date in Odoo?
+
Yes. In Odoo 20, the Stock report has an Inventory at Date picker that recomputes quantities and values at a chosen date and time. In Odoo 19, the Locations report has an Inventory At Date button.
Why does my Odoo forecast not show an RFQ?
+
RFQs do not affect the Forecasted report until they are confirmed as purchase orders. Confirmed sales orders lower the forecast, and confirmed manufacturing orders change both components and finished goods.
Who can see Odoo inventory reports?
+
The Inventory Reporting menu is only open to users with admin access to the Inventory app. The Operation analysis and Warehouse Metrics dashboards are also limited to Inventory admins by default.
Can I build custom inventory reports without coding?
+
Often, yes. Saved filters, pivots and grouped lists cover many needs in all editions. In Enterprise you can insert pivots into a spreadsheet or dashboard, and Studio can add fields or simple PDF reports.
When do I need a developer for an Odoo inventory report?
+
You need one for fixed aging buckets, running stock card balances, lot balances at a past date or branded audit PDFs. These usually mean a SQL view, a custom module or a QWeb template.
Free written answer from a certified consultant
Getting inventory valuation right in Odoo?
We review your costing method and valuation setup in Odoo and show what to fix before it reaches your books.
Free, with no obligation. A senior consultant replies within 12 business hours.
Free Odoo tools
All tools- Odoo Health CheckVersion, modules, findings and upgrade cost
- Odoo App SelectorWhich apps you need, by industry
- Odoo Project EstimateIndicative cost and timeline in minutes
- Odoo Implementation Cost CalculatorImplementation cost and timeline, in minutes
- Odoo Migration Cost CalculatorVersion jump or legacy ERP, priced in minutes
Continue reading
Odoo Inventory Accuracy: Fix Stock Discrepancies with Cycle Counts
Improve Odoo inventory accuracy: causes of stock discrepancies, negative stock fixes, cycle counts by location, blind barcode counts and Odoo 20 tools.
Odoo Warehouse Management System: WMS Guide for Odoo 19 and 20
Set up the Odoo warehouse management system in Odoo 19 and 20: locations, putaway rules, routes, replenishment, barcode picking, cycle counts and 3PL limits.
Odoo Pick, Pack and Ship: 1, 2 or 3-Step Shipping Routes in Odoo 19/20
Odoo pick, pack and ship explained: when 1, 2 or 3-step outgoing routes fit, how to set them up in Odoo 19 and 20, and the mistakes that slow shipping.
