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
Description
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.
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 xlsxwriter for 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
| Versions | 18.0, 19.0 |