| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 314 |
| Technical Name |
ask_party_ledger_detailed |
| License | LGPL-3 |
| Website | https://www.asksol.pk |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 314 |
| Technical Name |
ask_party_ledger_detailed |
| License | LGPL-3 |
| Website | https://www.asksol.pk |
Party Ledger Detailed Report
Comprehensive detailed party ledger analysis with SQL-based report generation, featuring opening balances, product-wise tracking, payment records, and running balance calculations.
Key Highlights
SQL-Based Report
Optimized SQL queries for fast generation even with large volumes of accounting data and complex calculations.
Opening Balance
Automatic calculation of opening balance one day before the start date for accurate recovery analysis.
Product-Wise Tracking
Detailed product-level tracking with quantity and unit price information for each transaction.
Payment Records
Comprehensive payment and journal entry tracking with separate debit/credit columns.
Running Balance
Dynamic running balance calculation that updates with each transaction for clear financial visibility.
PDF & Excel Export
Professional PDF reports and Excel export with formatting, making data sharing and analysis effortless.
Party Ledger Detailed Report
Generate comprehensive party ledger reports today! Complete financial analysis with PDF and Excel exports.
Module in the App Store
The Party Ledger Detailed module as it appears in the Odoo Apps marketplace.

Wizard Form
Simple wizard interface to select date range, partners, journals and export format.

PDF Report
Professional PDF showing opening balance, product details, payments, and running balance per partner.

Excel Export
Export complete data to Excel with all transaction details, quantities, and running balances.

Additional Features
Advanced filtering and reporting capabilities with comprehensive transaction tracking.

Powerful Features
Date Range Filtering
Select custom date ranges to analyze party ledger for any period with opening balance calculation.
Partner Selection
Multi-select partners to generate detailed reports for specific customers or suppliers.
Journal Filtering
Filter by specific journals to focus on particular accounting transactions.
Product-Wise Breakdown
Detailed product information including quantity and unit price for each transaction.
Debit & Credit Tracking
Clear separation of debit and credit entries with automatic balance calculations.
Running Balance Calculation
Real-time running balance that updates with each transaction for financial clarity.
Professional PDF Reports
Generate clean, formatted PDF reports with all transaction details and summaries.
Excel Export with Formatting
Export data to Excel with professional formatting and multiple sheets per partner.
SQL Optimized Queries
Fast report generation using optimized SQL queries for handling large datasets efficiently.
Frequently Asked Questions
Party Ledger Detailed is a comprehensive reporting module that provides detailed transaction-level view of all dealings with customers and suppliers, including opening balances, product details, quantities, payments, and running balances.
This module is compatible with Odoo 18 Community Edition. It works seamlessly with standard Odoo modules like Accounting, Contacts, and Inventory.
Yes! You can use multi-select to choose specific partners, or leave empty to include all. The report will be generated for selected partners with their complete transaction history.
The report includes: Date, Journal, Document reference, Product details, Quantity, Unit Price, Debit, Credit, and Running Balance for each transaction with opening balance calculation.
Absolutely! You can export the entire report to Excel format (.xls) with professional formatting. Multiple sheets are created for each partner for better organization.
Opening balance is automatically calculated as the net balance (debit - credit) of all transactions from the beginning up to one day before the selected start date. This ensures accurate period analysis.
Yes! The report works with both receivable accounts (customers) and payable accounts (suppliers). You can select to show only one type or both in the same report.
What's New
- Initial module release for Odoo 18 Community Edition.
- SQL-based Party Ledger Detailed Report with optimized queries.
- Opening balance calculation one day before start date for accuracy.
- Product-wise tracking with quantity and unit price per transaction.
- Detailed payment and journal entry records with debit/credit tracking.
- Running balance calculation for real-time financial visibility.
- Print PDF and Export Excel functionality.
- Date range, partner, and journal filtering options.
- Full integration with standard Odoo Accounting module.
Please log in to comment on this module