| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 182 |
| Technical Name |
ydod_stock_aging |
| License | OPL-1 |
| Website | https://profile.dodyakj.online |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 182 |
| Technical Name |
ydod_stock_aging |
| License | OPL-1 |
| Website | https://profile.dodyakj.online |
Overview
Stock Aging Analysis tells you exactly how long every unit in your warehouse
has been sitting since it was first received — down to the day. The module reads directly
from Odoo's stock.quant receipt dates, so the data is always current: no
manual recalculation, no cron job, no stale cache.
Items are automatically classified into four age buckets so your team can instantly spot fast-moving, slow-moving, and obsolete inventory at a glance.
Key Features
Real-Time SQL View
Backed by a PostgreSQL view — every time you open the report the data reflects the current stock state instantly.
Pivot Analysis
Pivot table with product categories as rows and age buckets as columns — drill down in one click.
Bar Chart View
Stacked bar graph comparing quantity per age bucket across product categories. Perfect for board-level reporting.
Color-Coded List
List view rows are color-coded green → yellow → red by bucket. Age badge widget highlights status at a glance.
Filter Wizard
Launch from "Generate Report": select location(s), category(ies), minimum age, or slow-moving filter before opening.
Excel Export
Use Odoo's built-in list export (≡ Actions → Export) to download aging data as .xlsx for finance or ops teams.
Cara Penggunaan
Buka Inventory → Stock Aging → Aging Analysis
Langsung tampil semua stok internal aktif yang sudah dikelompokkan per bucket umur.
Gunakan filter bawaan
Klik filter Slow Moving, Obsolete, atau kelompokkan berdasarkan Produk / Kategori / Lokasi.
Switch ke Pivot atau Graph
Gunakan icon view di pojok kanan atas untuk berpindah antara List, Pivot, dan Bar Chart.
Export ke Excel
Di list view → ≡ (Actions) → Export → pilih kolom → Download .xlsx.
Buka Inventory → Stock Aging → Generate Report
Wizard terbuka dengan opsi filter sebelum laporan ditampilkan.
Pilih lokasi dan/atau kategori
Kosongkan untuk menampilkan semua. Atau centang Slow Moving Only langsung.
Klik "Open Report"
Laporan terbuka dengan domain filter yang sudah diterapkan, dikelompokkan per bucket.
Analisis & Export
Gunakan Pivot / Graph untuk presentasi, atau export ke Excel untuk laporan ke manajemen.
Catatan Penting
- Data diambil dari field in_date pada
stock.quant— tanggal ini di-set Odoo saat quant pertama kali dibuat dari penerimaan barang. - Hanya stok di lokasi internal dengan
quantity > 0yang ditampilkan — transit dan virtual locations tidak termasuk. - Jika
in_datetidak tersedia pada quant lama (import atau migrasi), baris tersebut tidak akan muncul di laporan. - Bucket umur dihitung dari tanggal hari ini saat laporan dibuka — selalu real-time.
- Module hanya butuh modul stock — tidak memerlukan Purchase atau Sales.
- Export Excel menggunakan fitur bawaan Odoo (Actions → Export) — tersedia di semua lisensi Odoo.
Live Demo
Demo: analisis umur stok langsung dari Inventory dengan pivot, graph, dan filter wizard
Screenshots
Wizard filter: pilih lokasi, kategori, dan minimum umur sebelum membuka laporan
List view dengan warna hijau/kuning/merah per bucket — tampilkan produk, kategori, lokasi, lot, dan umur stok
Compatibility & Technical Info
| Attribute | Value |
|---|---|
| Odoo Version | 19.0 |
| Module Name | ydod_stock_aging |
| Author Tag | yDoD |
| Depends | stock |
| License | OPL-1 |
| Price | $29.00 USD |
| Models Added | ydod.stock.aging.report (SQL view), ydod.stock.aging.wizard |
| Database Objects | View: ydod_stock_aging_report (PostgreSQL VIEW, read-only) |
| Views | List, Pivot, Graph, Search, Wizard Form |
| Menu Added | Inventory → Stock Aging → Generate Report / Aging Analysis |
About the Developer
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