| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Purchase (purchase) • Discuss (mail) • Invoicing (account) |
| Lines of code | 402 |
| Technical Name |
ma_stock_movement_report |
| License | OPL-1 |
| Website | https://codeerts.odoo.com |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Purchase (purchase) • Discuss (mail) • Invoicing (account) |
| Lines of code | 402 |
| Technical Name |
ma_stock_movement_report |
| License | OPL-1 |
| Website | https://codeerts.odoo.com |
| Versions | 18.0 19.0 |
Inventory Movement Report
Opening balance, purchases, sales, scrap and adjustments
per product, for any date range, in seconds.
Your inventory numbers should reconcile instantly. Not after hours of manual spreadsheet work.
|
6
Columns Per Product
|
2
Output Formats
|
0
SQL Required
|
Any
Date Range
|
v18
Compatible
|
What this module does
Inventory Movement Report gives every storable product its own row: opening balance, quantity purchased, quantity sold, quantity scrapped, net stock adjustment, and closing balance, all computed from live Odoo stock moves for any date range you choose. No SQL. No external tools. No manual pivot tables.
Run it in seconds from Inventory › Reporting. Filter by product, product category, or leave filters empty for a full warehouse stock ledger. Export to Excel or view the color-coded HTML report directly in the browser. Every figure is scoped to your active company automatically.
|
📈
Instant Opening & Closing Balance
Accurately computed from all historical stock moves. Know your stock position at the start and end of any period without touching a spreadsheet. |
📊
Full Stock Movement Breakdown
Purchase receipts, sales deliveries, scrap operations and inventory adjustments each get their own column. Positive values green, negative values red. |
📥
HTML Report & Excel Export
View the color-coded report in a browser tab or download a formatted .xlsx workbook with a navy header row and green/red cell fills. One wizard, two formats. |
|
🔍 Product & Category Filters
Drill into one product, an entire product category, or leave both filters empty for a full-warehouse stock movement ledger. Only storable products with inventory tracking are included. |
⚖ Self-Balancing Formula
Opening + Purchase - Sales - Scrap + Adjustment = Closing. The Adjustment column absorbs returns and inter-location transfers so the formula is guaranteed to balance for every product and every row. |
|
🏢 Multi-Company Support
All stock moves are automatically scoped to your active company. Switch company in Odoo and run the report again to get a separate ledger for each entity. |
🔒 Standard Odoo Security
Accessible to stock users and stock managers out of the box via the standard Odoo Inventory groups. No extra configuration or custom roles needed after installation. |
|
📅 Any Date Range
Pick any start and end date you need. The report defaults to today and recalculates every balance the moment you change the range. |
🧮 Totals Row
A summed totals row at the bottom adds opening balance, purchases, sales, scrap, adjustments and closing balance across every listed product. |
How it works
|
1
|
Open the report
Go to Inventory › Reporting › Inventory Movement Report to open the filter wizard. |
|
2
|
Set your filters
Set your date range (defaults to today). Optionally select specific products or product categories to narrow results. |
|
3
|
View the report
Click View Report to open the color-coded inventory movement report in a new browser tab, ready to print or share. |
|
4
|
Or export to Excel
Click Export Excel to download a formatted .xlsx stock movement report with a navy header, green fills for positive quantities and red fills for negative quantities. |
|
5
|
Review the totals
Review the totals row at the bottom for summed opening balance, purchases, sales, scrap, adjustments and closing balance across all listed products. |
Screenshots
REPORT LOCATION: INVENTORY › REPORTING SUBMENU
WIZARD: DATE RANGE, PRODUCT AND CATEGORY FILTERS
HTML REPORT: OPENING BALANCE, PURCHASES, SALES, SCRAP, ADJUSTMENT, CLOSING BALANCE
EXCEL EXPORT: FORMATTED STOCK MOVEMENT WORKBOOK
Technical information
|
Version
18.0
|
License
OPL-1
|
Editions
Community & Enterprise
|
Dependencies
stock, purchase, sale_stock
|
Technical name: ma_stock_movement_report · Model added: stock.movement.wizard · Python library: xlsxwriter (pre-installed on Odoo.sh)
Frequently asked questions
Inventory Movement Report shows opening balance, purchases in, sales out and closing stock per product over any period.
Yes, you choose any period and it summarises movements per product.
Yes.
The team behind this module
About CODEerts
Full-Service Odoo ERP Agency · Solutions That Scale
Every module in our store is built from real client work, tested in production and maintained long-term by a team of Odoo certified consultants. When you need more than an app, we deliver the full solution.
|
🏗️ Implementation
Full Odoo roll-outs from requirements to go-live, across any industry and company size. |
🧩 Custom Development
Bespoke modules, OWL components and business logic built precisely to your workflow. |
🔄 Migrations
Zero-data-loss upgrades from older Odoo versions with full custom module porting. |
|
🔌 Integrations
Payment gateways, shipping carriers, biometric devices, eCommerce and third-party APIs. |
🔍 Odoo Audits
Performance, security and code-quality reviews that surface risks before they become problems. |
🧑💻 Support & Training
Ongoing helpdesk, user training and monthly retainers so your team stays productive. |
|
Odoo
Certified
|
6+
Years
|
50+
Projects
|
10+
Industries
|
18
Published Apps
|
More from CODEerts
Other apps we build to make Odoo do more. Tap any card to open it on the Odoo Apps Store.
 FREE Archive Anything |  FREE Transaction Flow Visualizer |  FREE Smart Mail Rebrand |  FREE Duplicate Record Detector |
 AI Dashboard Builder |  Advance Payment Pro |  Dual Book & Tax Depreciation |  Smart Duplicate Detector |
See every CODEerts app on the Odoo Apps Store.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module