Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
2 Risposte
2366 Visualizzazioni

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
Abbandona
Risposta migliore

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
Abbandona
Risposta migliore

https://apps.odoo.com/apps/modules/17.0/fsn_analysis_enhanced

Avatar
Abbandona

Seems not to be available for Odoo 13.

Post correlati Risposte Visualizzazioni Attività
0
nov 24
1138
2
nov 23
2878
7
lug 24
8565
0
gen 25
1370
1
dic 24
2777