| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 1797 |
| Technical Name |
aos_stock_ageing_report |
| License | OPL-1 |
| Website | http://www.alphasoft.co.id |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 1797 |
| Technical Name |
aos_stock_ageing_report |
| License | OPL-1 |
| Website | http://www.alphasoft.co.id |
How old is your on-hand stock?
A dynamic dashboard that breaks every product's on-hand quantity and value into FIFO age buckets — as of any date — so you can spot slow-moving and ageing inventory before it turns into dead stock. Plus a 2-sheet Xlsx export.
Buckets are fully configurable — set your own thresholds.
What You Get
📅 Configurable age bucketsDefine thresholds like |
⏳ FIFO simulationWalks each product's stock valuation layers; every outgoing layer consumes the oldest receipt first, so on-hand items keep their real receipt dates. |
📊 Dynamic dashboardKPI tiles, per-bucket distribution, per-product stacked age bars, bar + doughnut charts, and a per-batch drill-down — all client-side, instant. |
🔍 Group & filterGroup by Product, Product × Warehouse or Product × Location. Filter by date, product, category, warehouse, location — filters auto-save per user. |
💾 Xlsx exportTwo sheets — Summary (one row per group, Qty + Value per bucket) and Detail (every FIFO batch with receipt date, age, qty, unit cost, value). |
🔒 Cost privacyValue and cost columns can be gated to a cost-editor group; quantities and ages stay visible to everyone else. |
See It In Action
KPI tiles, per-bucket totals, and a per-product stacked age bar with a batch-level table.
How It Works
1 |
Open Inventory › Reporting › Stock Ageing, pick an as-of date and your bucket thresholds, then run. |
2 |
The engine replays every stock move as FIFO — outgoing quantities retire the oldest receipts, leaving the true age of what's still on hand. |
3 |
Explore the dashboard — slice by warehouse/location, search, hide zero-stock, drill into batches — or export to Xlsx for sharing. |
ⓘ A note on valuation methods
For FIFO-valued products this matches Odoo's own remaining quantity exactly. For AVCO / Standard products — where Odoo doesn't track a remaining quantity natively — the report gives a consistent age proxy based on FIFO consumption, so you still get a reliable ageing picture across your whole catalogue.
Compatibility
Odoo 18.0 — Community & Enterprise •
Depends only on stock_account •
Xlsx export needs the xlsxwriter Python package
Built by Alphasoft
We build practical Odoo modules for real Indonesian businesses — accounting, inventory, and reporting that fit how teams actually work.
www.alphasoft.co.id
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