| 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 |
| 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 |
Stock Ledger Report
Stock Ledger Report is a custom Odoo module for the Inventory application that provides a complete, line-by-line history of every stock movement for any product. It shows incoming, outgoing, and running balance similar to a financial ledger - giving you full visibility of your warehouse stock at any point in time.
Think of it like a bank statement for your warehouse stock: each row shows one transaction, where the goods moved from, where they went to, and how much stock remained after that movement.
Key Features
Complete Stock Movement History for Any Product
Automatic Opening Balance Calculation
Incoming (IN) and Outgoing (OUT) Transaction Tracking
Running Balance After Every Transaction
Date Range Filter Wizard with Smart Defaults
Colour-Coded IN (Green) and OUT (Red) Indicators
Source and Destination Location Tracking
Only Completed (Done) Stock Moves Are Included
Accessible from Inventory Reporting Menu
How It Works
Step 1: Open Stock Ledger from Inventory → Reporting → Stock Ledger.
Step 2: A wizard opens with the previous month's dates pre-filled. Adjust the From and To dates if needed.
Step 3: Click Generate to open the product list with your date range stored.
Step 4: Click the "View Ledger" button on any product row to generate its stock ledger.
Step 5: The system calculates the opening balance from all prior movements and displays every transaction with a running balance.
Report Columns Explained
The Stock Ledger Report displays a clean, easy-to-read table with the following columns. Each row represents one completed stock movement within your selected date range.
- Product: The product being reported on
- Date: Exact date and time of the stock movement
- From: Source location where stock moved from
- To: Destination location where stock moved to
- Incoming: Quantity received into internal stock (Green)
- Outgoing: Quantity dispatched from internal stock (Red)
- Type: IN (green) for incoming, OUT (red) for outgoing
- Balance: Running total of stock remaining after each movement
Balance Calculation
The balance is calculated cumulatively as: Opening Balance + Incoming − Outgoing. Each row updates the running total so you always know the exact stock on hand after every single movement.
| Movement | IN | OUT | Balance |
|---|---|---|---|
| Opening Balance | - | - | 100 |
| Received from Supplier | 50 | 0 | 150 |
| Shipped to Customer | 0 | 30 | 120 |
| Shipped to Customer | 0 | 80 | 40 |
| Received from Supplier | 20 | 0 | 60 |
Step-by-Step Usage
Step 1 - Open the Stock Ledger
Navigate to Inventory → Reporting → Stock Ledger. The Date Filter Wizard opens automatically.
Step 2 - Select Your Date Range
The wizard pre-fills the previous full calendar month. Adjust the From and To dates to your desired reporting period. Click Generate.
Step 3 - Product List Opens
The product list opens with your date range stored in the background. Browse or search for the product you want to analyse.
Step 4 - Click "View Ledger"
Click the blue View Ledger button next to the product. The system calculates the opening balance and loads all transactions within your date range.
Step 5 - Read the Stock Ledger Report
The ledger report displays every stock movement row by row, with colour-coded IN/OUT indicators and a running Balance column.
Key Concepts
- Opening Balance: Stock quantity that existed before your selected date range begins
- Incoming (IN): Stock entering an internal warehouse or storage location
- Outgoing (OUT): Stock leaving an internal warehouse or storage location
- Balance: Running total of stock remaining after each transaction
- Internal Location: Your company's own warehouse, shelf, or storage area
- Done State: Only fully completed stock movements appear in this report
Requirements
- Odoo Version: Odoo 19 (Community or Enterprise)
- Odoo Modules: Inventory (Stock) module must be installed and active
- No External Dependencies: Works entirely within Odoo - no external APIs or services required
Setup Guide
Step 1 - Install the Module
- Copy the module folder to your Odoo custom addons directory.
- In Odoo, go to Settings and activate Developer Mode.
- Go to Apps - Update Apps List and click Update.
- Search for Stock Ledger Report and click Install.
Step 2 - Start Using
- No additional configuration is needed. The module is ready to use immediately after installation.
- Navigate to Inventory → Reporting → Stock Ledger to begin generating reports.
Support
If you run into any issues during installation or usage, the following checks will resolve most problems:
- Ensure the Inventory module is installed and active in your Odoo instance.
- Verify that the Stock Ledger Report module is properly installed via Apps.
- Always access the report through the wizard to ensure date context is set correctly.
- Confirm that products have completed (Done) stock movements within your selected date range.
For purchase support, installation assistance, or customisation enquiries, please contact us through the channel where you purchased this module.
Connect With Us
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