Skip to Content
Menu

Advanced Partner Ledger Report

by
Odoo

61.23

v 16.0 Third Party 3
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Lines of code 758
Technical Name an_partner_ledger_adv
LicenseLGPL-3
Websitehttps://odoosa.net
Versions 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Lines of code 758
Technical Name an_partner_ledger_adv
LicenseLGPL-3
Websitehttps://odoosa.net
Versions 16.0 17.0 18.0

Advanced Partner Ledger Report

Comprehensive, Detailed, and Customizable Partner Ledger Reports

Key Features

  • Custom Date Range - Generate reports for specific time periods
  • Multiple Partner Selection - Choose individual partners, partner categories, or filter by salesperson
  • Journal Filtering - Limit the report to specific journals
  • Reconciliation Options - Include or exclude fully reconciled entries
  • Invoice Details - Display detailed invoice line information including products, quantities, and prices
  • Delivery Address - Show delivery address for sales and purchase transactions
  • Salesperson Filtering - Filter results by specific salesperson
  • Summary Reports - Generate summary reports grouped by salesperson
  • Balance Confirmation - Include a professional balance confirmation section for client signature

Detailed Wizard Options

  • Date Range Selection - Choose start and end dates for your report
  • Company Selection - Select the specific company for multi-company environments
  • Journal Selection - Filter by specific journals
  • Partner Selection - Choose specific partners or filter by partner tags
  • Salesperson Selection - Filter by specific salesperson
  • Include Fully Reconciled Entries - Option to show or hide reconciled transactions
  • Only Partners With Movements - Focus only on partners with activity during the period
  • Show Invoice Details - Display detailed invoice line information
  • Summary by Salesperson - Generate a summary report grouped by salesperson
  • Balance Confirmation Request - Include a section for client signature to confirm balance

Detailed Partner Ledger Report

The detailed report provides comprehensive information for each partner:

  • Partner name, reference, and assigned salesperson
  • Initial balance at the start of the period
  • All transactions during the selected period
  • Running balance calculation for each transaction
  • Detailed invoice information (when enabled)
  • Delivery address details (when available)
  • Total debits, credits, and ending balance

Invoice Line Details

When "Show Invoice Details" is enabled, the report displays comprehensive information for each invoice line:

  • Product name
  • Quantity and unit of measure
  • Unit price
  • Subtotal (before tax)
  • Total (including tax)
This level of detail is perfect for reconciliation and verification purposes.

Summary Report

The summary report provides a concise overview of all partners, showing:

  • Partner name and reference
  • Initial balance
  • Total debits during the period
  • Total credits during the period
  • Ending balance
This is perfect for management reviews and quick financial overviews.

Balance Confirmation Request

Include a professional balance confirmation section for client signatures. This feature is invaluable for audit purposes and formal account reconciliations with customers and vendors.

The balance confirmation section includes:

  • Current date and balance
  • Amount in words
  • Signatory information fields
  • Company stamp area
  • Automatic multilingual support (English/Arabic)
  • Professional layout for official documentation

Arabic Balance Confirmation (مطابقة الرصيد)

Full support for Arabic language in balance confirmation requests, perfect for Middle Eastern markets and Arabic-speaking businesses.

The Arabic balance confirmation section includes:

  • Right-to-left text layout
  • Proper Arabic formatting for dates and numbers
  • Arabic labels for all fields
  • Arabic legal terminology
  • Amount in words in Arabic
  • Culturally appropriate documentation format

Technical Features

  • Efficient Data Processing - Optimized queries for faster report generation
  • Multilingual Support - Full translation capabilities including right-to-left languages
  • Customizable Templates - Easily extendable QWeb templates
  • Well-Organized Code - Clean, modular, and well-documented Python code
  • Integration with Odoo Core - Seamlessly integrates with Odoo's accounting modules
  • Multi-Company Support - Full compatibility with multi-company environments

Use Cases

Financial Audits

Generate comprehensive reports for auditors with all the required transaction details, including balance confirmations.

Customer Statements

Send detailed account statements to customers with transaction history and current balance information.

Internal Reconciliation

Perform internal account reconciliation with detailed transaction traces and running balances.

Compatibility

This module is compatible with Odoo 17 Community and Enterprise editions.

Support

Developer Information

Additional Information

  • Module Price: $60
  • Version: 17.0.1.0.0
  • License: LGPL-3

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.