Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
1857 Widoki

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. 

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć

Seems not to be available for Odoo 13.

Powiązane posty Odpowiedzi Widoki Czynność
0
lis 24
862
2
lis 23
2360
7
lip 24
8128
0
sty 25
929
1
gru 24
2468