Stock Balance Report | Inventory Summary by Location — PDF & Excel
by Herul Ramdani https://www.lemacore.com$ 12.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 348 |
| Technical Name |
hrl_stock_balance_report |
| License | OPL-1 |
| Website | https://www.lemacore.com |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 348 |
| Technical Name |
hrl_stock_balance_report |
| License | OPL-1 |
| Website | https://www.lemacore.com |
| Versions | 17.0 18.0 19.0 |
Stock Balance Report | Inventory Summary by Location — PDF & Excel
Get an instant stock position snapshot for every product at any location — the
Stock Balance Report
summarizes total
Moves In,
Moves Out,
and
Ending Balance
per product in a single consolidated table — no transaction detail noise.
Export to
PDF
or
Excel
— your stock review is ready in seconds.
Email Us
LinkedIn
Stock Balance Report
Skip the transaction noise — get a clean, consolidated stock position for every product at any location. One row per product, Beginning Balance, total Moves In, total Moves Out, and Ending Balance — your entire inventory summarized on a single page.
Access from Inventory Reporting Menu
Navigate to
Inventory →
Reporting →
Stock Balance Report —
available directly in the standard Inventory Reporting menu
alongside Locations, Moves History, and Valuation.
No extra configuration, no developer mode required.
Configure Location, Date Range & Format
A clean print dialog lets you define the scope — select a
Location,
set a
Start Date
and
End Date,
choose output format
(PDF or
Excel),
and optionally filter by specific products or enable
Detail Variant
for variant-level breakdown. Hit
Print — your summary is ready.
Clean PDF — One Row per Product, Print-Ready
The PDF output presents every product in a single consolidated row —
Beginning Balance,
Moves In,
Moves Out, and
Ending Balance —
with your company logo, location, date range, total item count,
and printed-by information in the header.
A 24-item inventory fits on a single page,
ready to share with management or file for periodic review.
Structured Excel — Clean Data, Ready to Analyze
The Excel export mirrors the same one-row-per-product structure —
styled headers, product rows with
Beginning Balance,
Moves In,
Moves Out, and
Ending Balance —
clean and structured straight out of Odoo.
Use it for pivot tables, stock opname reconciliation,
or feeding into your management reporting dashboard.
No reformatting needed.
Consolidated One-Row-per-Product Summary
Every product is summarized in a single row showing
Beginning Balance, total
Moves In, total Moves Out,
and Ending Balance —
your entire inventory position at a location,
visible on a single page without transaction clutter.
Filter by Location & Date Range
Scope the report to any warehouse location
(e.g. WH/Stock) and define a
Start Date and End Date —
generate a daily, weekly, monthly, or custom period
stock balance summary with a single
Print action.
Optional Product Filter
Leave products blank to summarize all items at the
selected location, or filter by specific products
using Internal Reference and
Name — full flexibility for both
full-inventory reviews and targeted stock checks.
Detail Variant Breakdown
Toggle Detail Variant to split the
balance summary by individual product variant —
ideal for businesses managing products with
multiple sizes, colors, or attributes that need
variant-level stock visibility.
Export to PDF & Excel
Choose a professionally formatted
PDF with company logo and print-ready
layout, or a structured Excel (XLSX)
file ready for pivot tables, stock opname
reconciliation, and management dashboards —
both carry identical, clean data.
Zero Configuration, Instant Ready
Install the module and
Stock Balance Report appears instantly
under Inventory → Reporting —
no settings to configure, no developer mode needed.
Install once, report anywhere.
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