| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 266 |
| Technical Name |
rn_stock_aging_report |
| License | OPL-1 |
Stock Aging Report
Stop guessing which products are sitting dead in your warehouse. A simple, zero-config wizard that shows exactly how old every stock item is — grouped into color-coded age buckets with stock value totals and one-click Excel export for management reporting.
- ✗ Odoo only shows current on-hand quantities — no visibility into how long each item has been sitting there.
- ✗ Dead stock (>90 days) ties up working capital — warehouse managers must manually dig through move history in Excel.
- ✗ No built-in way to identify candidates for clearance sales, write-offs, or supplier returns.
- ✗ Management decisions are made without data — or require hours of Excel work every month.
- ✓ Instant aging report from Inventory → Reporting — shows every stock item with its exact age in days.
- ✓ Color-coded rows: green (fresh) → yellow → orange → red (dead stock >90 days).
- ✓ Filter by warehouse, internal location, and product category. Stock value calculated per line.
- ✓ One-click Excel export with color-coded rows + summary sheet by age group for management.
Key Features
Setup Guide
1) Place the stock_aging_report folder in your Odoo custom addons directory and restart the server.
2) Enable Developer Mode — go to Settings → Activate Developer Mode, then click Apps → Update Apps List.
3) Search for "Stock Aging" in Apps and click Install.
4) Open Inventory → Reporting → Stock Aging Report. Set optional filters and click Generate Report.
Wizard form — filter by warehouse, location, or category. Leave blank to include all stock.
5) The report loads instantly — rows color-coded by age, sorted oldest first. Click Export Excel to download.
Report results — all 4 age buckets with color decoration, qty totals, and stock value per line.
6) The exported Excel file contains two sheets: the full detail view and a summary by age group.
All four age groups visible at once — green (fresh), yellow (aging), orange (at risk), red (dead stock).
Frequently Asked Questions
Age is computed as today minus the incoming date (stock.quant.in_date),
which Odoo sets automatically when stock is received via a receipt or inventory adjustment.
No manual setup required.
Two sheets: Stock Aging Report — full detail with color-coded rows sorted oldest first; Summary — totals (lines, qty, value) per age bucket for quick management overview.
Yes. All three filters (Warehouses, Locations, Categories) accept multiple selections via tag inputs. Combine them freely — for example, filter to two categories across three warehouses at once.
Yes. The Lot/Serial column (optional, toggle on/off per preference) shows the lot or serial number for tracked products. Products without tracking show a blank in that column.
No. The module only adds two transient (session-only) models. It reads
stock.quant data but never writes to it. Uninstalling removes the wizard cleanly.
Support
- Email support: nextstep.vina@gmail.com
-
Response time: We aim to respond within 1–2 business days. Please include your Odoo version and a description of the issue.
-
Source code: Available on GitHub (private repo for paid customers): github.com/RandyNguyenN/stock_aging_report
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module