| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Manufacturing (mrp) • Discuss (mail) |
| Lines of code | 890 |
| Technical Name |
bs_stock_movement_report |
| License | AGPL-3 |
| Website | https://brainstation-23.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Manufacturing (mrp) • Discuss (mail) |
| Lines of code | 890 |
| Technical Name |
bs_stock_movement_report |
| License | AGPL-3 |
| Website | https://brainstation-23.com |
Stock Movement Analysis
High-performance stock movement analysis for Odoo 18 — opening/closing balances,
category grouping, multi-dimensional filters, PDF & XLSX export.
Odoo 18.0
AGPL-3
Depends: stock, product, mrp
Overview
The Stock Movement Analysis module provides a fast, scalable reporting engine to analyze inventory movements across companies, warehouses and locations. It calculates opening and closing balances, groups by product categories, and produces professional XLSX and print-ready PDF reports.
Key Features
- Opening & closing balances per product and location
- Transaction breakdown: Purchase, Production, Adjustment, Transfer, Delivery
- Category grouping with subtotals and overall summary
- Filters: company, warehouse, location, category, product
- Optimized batch queries & pre-computed aggregations — scales to 10,000+ products
- Professional Excel export (xlsxwriter) and PDF/HTML output
How it works
- Open the wizard from Inventory > Reporting > Stock Movement Analysis.
- Select companies, warehouses, locations, categories or specific products.
- Choose the period (start / end dates) and click View Report or Download Excel.
- Excel export uses
xlsxwriterfor formatted spreadsheets.
Installation
- Copy module to your addons path:
bs_stock_movement_report. - Install dependency:
pip install xlsxwriter. - Update apps list and install the module.
Before & After
Traditional Report
- Multiple DB calls
- Poor performance on large catalogs
- No formatted Excel export
This Module
- Batch queries & pre-aggregation
- Scales to large datasets
- Formatted XLSX and print-ready PDF
Screenshots
Inventory -> Reporting
Stock Movement Analysis
Filter Option to generate excel report
Excel Report
Quick Links
Access: Inventory → Reporting → Stock Movement Analysis
Excel lib: pip install xlsxwriter
Contact & Support
For sales, support, or inquiries please contact one of our regional offices below.
Bangladesh
8th Floor, 2 Bir Uttam AK Khandakar Road,
Mohakhali C/A, Dhaka 1212
+8801719-304086
USA
7426 Alban Station Blvd, Suite a101,
Springfield, VA 22150
+1 201 534 7200
Please log in to comment on this module