| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 503 |
| Technical Name |
nx_inventory_fsn_report |
| License | LGPL-3 |
| Website | https://www.ash.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 503 |
| Technical Name |
nx_inventory_fsn_report |
| License | LGPL-3 |
| Website | https://www.ash.com |
Overview
Inventory FSN Report brings classic FSN (Fast–Slow–Non-moving) inventory analysis directly into Odoo 17. Using actual stock movement history, it calculates the turnover ratio for every product/location combination and classifies each item so your procurement and warehouse teams can act on real data — not guesswork.
Features
📅 Flexible Date Range
Analyse any period — weekly, monthly, quarterly or custom — with simple Start/End date pickers.
🔍 Powerful Filters
Narrow results by specific Products, Product Categories, Companies, and Warehouses.
🏷️ FSN Type Filter
Show All items or drill into Fast, Slow, or Non-Moving items instantly from the wizard.
📋 Colour-Coded List View
Green badge for Fast, amber for Slow, red for Non-Moving — at a glance in the tree view.
📈 Graph & Pivot Views
Bar chart grouped by FSN classification plus a pivot table for category-level analysis.
📄 PDF Export
Professional QWeb PDF report with header, data table, and colour-coded FSN legend.
📊 Excel Export
Formatted .xlsx file with title, period subtitle, colour-coded FSN cells, and numeric formatting.
🏢 Multi-Company Ready
Filter by one or more companies; warehouse selection automatically scopes the internal locations.
FSN Classification Rules
| Class | Label | Turnover Ratio Condition | Interpretation |
|---|---|---|---|
| F | Fast Moving | Turnover Ratio > 3 | High-velocity items — ensure adequate stock levels |
| S | Slow Moving | Turnover Ratio between 1 and 3 | Moderate demand — review reorder points |
| N | Non Moving | Turnover Ratio ≤ 1 | Dead stock — consider clearance or write-off |
Formula: Turnover Ratio = Sale Qty ÷ Average Stock | Average Stock = (Opening Stock + Closing Stock) / 2
How It Works
- Go to Inventory → Reporting → FSN Report.
- Set the Start Date and End Date for the analysis period.
- Optionally select the FSN Type, products, categories, companies, or warehouses.
- Click View Report to open the interactive tree + graph view inside Odoo.
- Click PDF to download a formatted print-ready report.
- Click Excel to download a colour-coded spreadsheet.
Technical Information
| Attribute | Value |
|---|---|
| Odoo Version | 17.0 Community & Enterprise |
| Technical Name | nx_inventory_fsn_report |
| Depends | stock, product |
| License | LGPL-3 |
| Models | inventory.fsn.report.wizard (TransientModel), inventory.fsn.data.report (TransientModel) |
| Views | Tree, Graph, Pivot, Search, Wizard Form |
| Exports | PDF (QWeb), Excel (xlsxwriter) |
Installation
- Download and unzip into your Odoo
addonsdirectory. - Restart the Odoo server.
- Enable Developer Mode.
- Go to Apps → Update App List.
- Search for Inventory FSN Report and click Install.
Support
For questions or custom development, contact Nxtech Solutions via the website or the Odoo Apps support form.
Please log in to comment on this module