| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 201 |
| Technical Name |
daily_odoo_stock_ledger_report |
| License | OPL-1 |
| Website | https://www.ahex.co |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 201 |
| Technical Name |
daily_odoo_stock_ledger_report |
| License | OPL-1 |
| Website | https://www.ahex.co |
| Versions | 18.0 19.0 |
Odoo Stock Ledger Report
A line-by-line history of every stock movement â incoming, outgoing, and running balance â giving you full, auditable warehouse visibility at any point in time.
Simplify Warehouse Audits & Inventory Tracking
Odoo's standard Inventory module provides current stock levels and basic movement reports, but lacks a chronological, line-by-line ledger view. The Stock Ledger Report acts like a bank passbook for your warehouse: showing the opening balance, every IN and OUT transaction with source and destination details, and a live running balance after each movement. Trace discrepancies instantly and provide auditors with a clean, transparent transaction trail.
Key Features
Line-by-Line Movement History
Tracks every single stock transaction chronologically with detailed from/to locations.
Running Balance Calculation
Automatically calculates and displays a cumulative stock balance after every transaction completes.
Automatic Opening Balance
Computes the opening balance correctly for any selected date range by summing all prior done stock moves.
Color-Coded IN/OUT Rows
Highlight incoming and outgoing shipments in clear green and red indicators for rapid scanning and auditing.
No External Dependencies
Runs entirely on your local Odoo server database with 100% security, privacy, and zero third-party calls.
Excel & PDF Export Ready
Works seamlessly with native Odoo actions to instantly print reports or export data to spreadsheet formats.
Smart Date Filter Wizard
Launch the stock ledger report and input your desired date filters. The wizard comes pre-filled with the previous full calendar month, so you can execute the calculation with a single click.
Real-Time Running Balance
Once computed, the ledger outputs a detailed tabular history of every stock move. Review exact transaction times, source locations, destination points, color-coded IN/OUT amounts, and a running cumulative stock balance.
Step-by-Step Workflow
|
1
|
Open Stock Ledger MenuNavigate directly to the new Stock Ledger reporting menu item inside the Inventory application. |
|
2
|
Set Date RangeEnter your desired start and end dates inside the pre-filled calendar wizard and click Generate. |
|
3
|
Browse Product ListFilter or search the standard product list. The date parameters are stored in your active session context. |
|
4
|
View & Audit LedgerClick the 'View Ledger' action button on any product row to instantly generate and analyze its historical movements. |
Instant Action Access
The module adds a direct 'View Ledger' action button on product list views. Access any product's historical ledger instantly without complex navigation or search steps.
Technical Details
Make sure you have completed stock movements (in 'Done' state) in your Odoo database. The ledger calculates opening balance and running transactions specifically for done state stock moves to maintain absolute audit integrity.
| Information | Detail |
|---|---|
| Technical Name | daily_odoo_stock_ledger_report |
| Odoo Version | 18.0 (Community & Enterprise Editions) |
| Dependencies | stock |
| License | OPL-1 |
| Author | Ahex Technologies |
Frequently Asked Questions
Is this compatible with both Odoo Community and Enterprise?
Yes, the module is fully compatible with both Odoo Community and Odoo Enterprise versions. It is developed using Odoo standard ORM API rules.
Can I filter by warehouse or specific location?
The current version calculates ledger movements for the selected product date-wise across all warehouse locations. For dedicated location filtering, contact Ahex Technologies for customization.
How is the opening balance calculated?
The opening balance is calculated by summing all completed (Done state) stock movements for the product from the beginning of your Odoo history up to the selected From date. Incoming quantities add to the balance, while outgoing quantities subtract from it.
What is the difference between this and Odoo's standard inventory report?
Odoo's standard reporting shows current stock valuations or stock moves lists, but lacks a running chronological ledger. Our module orders movements by date, shows exact from/to locations, color-codes IN/OUT movements, and calculates a running balance after each transactionâjust like a bank statement.
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