Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odgovori
1846 Prikazi

Hello, 

I am wondering if there's a way figure out slow moving inventory easily in Odoo v.13? I'm trying to figure it out from Warehouse Analysis report  but I'm not shure if it is the right way to do it but at the moment it seems to be right way as far as I  know. 

Avatar
Opusti
Best Answer

You can analyze slow-moving products by looking at stock movements over time. Here's how to do that:

Steps:
  1. Go to: Inventory > Reporting > Warehouse Analysis
  2. Group By: Product
  3. Add Measures such as:
    • Quantity Done
    • Quantity In / Quantity Out
    • Value
  4. Apply Filters:
    • Date Range (e.g., Last 90 days)
    • Location if needed (e.g., internal warehouse only)
What to Look For:
  • Products with low or zero Quantity Out over a reasonable period (e.g., 60–90 days).
  • Products with high stock levels but low movement — these are typically your slow movers.
Tips:
  • Use Pivot View to export data to Excel/CSV for deeper analysis.
  • Add custom fields or use Odoo Studio to tag “slow-moving” items if needed.

Odoo v13 Community Edition doesn't have built-in inventory aging or slow-mover reports. So while Warehouse Analysis works, it’s a bit manual and limited.

Alternatives & Enhancements
1. Custom Report (via Studio or Developer Mode):
  • Create a custom report or view on stock.quant and stock.move models.
  • Calculate:
    • Last outgoing date
    • Days since last movement
    • Average sales per month
2. Excel Export + Analysis:
  • Export Warehouse Analysis or Inventory Valuation report.
  • In Excel, calculate:
    • Turnover ratio = Quantity Sold / Average Stock
    • Days of inventory = 365 / Turnover ratio
3. Third-Party Modules (Optional in Community):

Some Odoo partners have free or paid modules for:

  • Inventory aging
  • ABC Analysis
  • Dead stock alerts

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
0
nov. 24
859
2
nov. 23
2349
7
jul. 24
8122
0
jan. 25
928
1
dec. 24
2461