Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
2168 Lượt xem

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. 

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ

Seems not to be available for Odoo 13.

Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 11 24
1051
2
thg 11 23
2693
7
thg 7 24
8396
0
thg 1 25
1251
1
thg 12 24
2671