| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) • Invoicing (account) |
| Lines of code | 1273 |
| Technical Name |
am_stock_card_report |
| License | OPL-1 |
| Website | https://idealitsetup.com/ |
| Versions | 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) • Invoicing (account) |
| Lines of code | 1273 |
| Technical Name |
am_stock_card_report |
| License | OPL-1 |
| Website | https://idealitsetup.com/ |
| Versions | 17.0 18.0 |
Stock Card Report
Comprehensive Stock Movement Tracking with Weighted Average Cost & Excel Export
Overview
The Stock Card Report module provides a complete and detailed view of stock movements per product with Weighted Average Cost or Standard Price calculation. Generate reports in Tree View, PDF, or beautifully formatted Excel with dashboard summary, color-coded rows, and inventory reconciliation.
Use Case: Warehouse managers and accountants need to track every stock movement for each product — incoming receipts, outgoing deliveries, internal transfers — with running balance and cost calculations. This module provides exactly that, with full reconciliation against actual inventory (stock.quant).
Key Features
| ✔ Three Output Formats - Tree View, PDF Report, and Excel Export with dashboard |
| ✔ Weighted Average & Standard Costing - Choose your costing method per report |
| ✔ Group By Product / Category / Location - Flexible grouping in all outputs |
| ✔ Opening & Closing Balance - Automatic calculation of balances before and after the period |
| ✔ Inventory Reconciliation - Compare calculated balance vs actual stock.quant with variance detection |
| ✔ Lot/Serial Number Tracking - See lot/serial info for each movement |
| ✔ Partner Filter - Filter movements by specific vendor or customer |
| ✔ Excel Dashboard - Summary cards showing total products, qty in/out, closing value, most active product |
| ✔ Color-Coded Rows - Blue (opening), Green (incoming), Red (outgoing), Yellow (internal), Bold Blue (closing) |
| ✔ High Performance - Batch data fetching with raw SQL for SVL & Lot data (3 queries for all products) |
| ✔ Timezone Aware - Correct date boundaries based on user timezone |
How It Works
| Step 1: Go to Inventory → Reporting → Stock Card Report |
| Step 2: Set your filters: Period, Warehouse/Location, Product/Category, Costing Method, Group By |
| Step 3: Click View Report for Tree View, Print PDF for PDF, or Export Excel for Excel with dashboard |
| Step 4: Use the search filters to drill down — filter by movement type, find variances, or view summary only |
Report Columns
| Column | Description |
|---|---|
| Product Ref / Name / UoM | Product identification |
| Date / Location / Move Ref | Movement details & picking reference |
| Partner / Lot/Serial | Vendor/Customer & traceability |
| Qty In / Qty Out / Qty Balance | Quantity movements with running balance |
| Unit Price / Cost / Avg Cost | Move price, product standard cost, weighted average |
| Amount In / Out / Balance | Financial value of movements |
| Quant Qty / Variance | Actual inventory vs calculated (on closing row) |
Screenshots
1. Report Wizard
Configure your stock card report with flexible filters: period, warehouse, products, costing method, grouping, and Excel layout options.
2. PDF Report
Clean, professional PDF output grouped by product with opening balance, all movements, and closing balance in a structured table.
3. Excel Export with Dashboard
Excel output with KPI dashboard (total products, qty in/out, amounts, closing value, most active product), color-coded rows, auto-filter, and frozen panes for easy analysis.
Technical Information
| Attribute | Value |
|---|---|
| Technical Name | stock_card_report |
| Version | 18.0.1.0.0 |
| Dependencies | stock, stock_account, product |
| License | OPL-1 |
| Odoo Version | 18.0 |
Contact & Support
$100 USD
Get professional support and customization services
| Developer: | Ahmed Magdy |
| Email: | qarsan4@gmail.com |
| Website: | idealitsetup.com |
| WhatsApp: | +966 509818413 |
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