| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 1963 |
| Technical Name |
an_partner_ledger_adv |
| License | LGPL-3 |
| Website | https://odoosa.net |
| Versions | 16.0 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 1963 |
| Technical Name |
an_partner_ledger_adv |
| License | LGPL-3 |
| Website | https://odoosa.net |
| Versions | 16.0 17.0 18.0 |
Advanced Partner Ledger
Comprehensive partner ledger reporting with enhanced features
A powerful extension to Odoo's standard accounting reports that provides detailed partner ledger analysis with multiple filtering options, balance confirmation features, and full multilingual support including Arabic.
Key Features
Advanced Filtering Options
- Flexible Date Ranges: Choose from predefined periods (Today, This Week, This Month, This Quarter, This Year) or set custom date ranges.
- Multiple Partner Selection: Select individual partners or filter by partner tags.
- Journal Filtering: Include only specific journals in your reports.
- Reconciliation Options: Include or exclude fully reconciled entries.
- Zero Balance Filtering: Option to hide partners with zero balances.
- Salesperson Filtering: Filter partners by their assigned salesperson.
- Sales Team Filtering: Filter partners by their sales team.
Enhanced Report Features
- Invoice Details: Show detailed invoice line information including products, quantities, and prices.
- Delivery Address: Display delivery address for sales and purchase transactions.
- Summary Reports: Generate summary reports grouped by salesperson or sales team.
- Font Size Options: Choose between small, medium, or large font sizes for better readability.
- Company Stamp Integration: Display your company's official stamp in reports.
- Balance Confirmation: Include professional balance confirmation sections for client signature.
- Multilingual Support: Full support for right-to-left languages including Arabic with proper RTL formatting.
Screenshots
Wizard Configuration
Advanced Options
Partner Ledger Report
Invoice Details
Salesperson Summary
Sales Team Summary
English Confirmation
Arabic Confirmation
How to Use
Step-by-Step Guide
- Installation: Install the module from the Apps menu. The module will automatically install its dependency (an_company_stamp).
- Access the Report: Navigate to Accounting > Reports > Partner Ledger (Advanced).
- Configure Report Options:
- Date Range: Select a predefined period or set custom start and end dates.
- Partner Selection: Choose specific partners or filter by partner tags.
- Company: Select the company for which to generate the report.
- Reconciliation: Choose whether to include fully reconciled entries.
- Journal Selection: Filter by specific journals if needed.
- Sales Filtering: Filter by salesperson or sales team.
- Display Options:
- Show Invoice Details: Enable to display detailed invoice line information.
- Summary Reports: Choose to generate summary reports by salesperson or sales team.
- Balance Confirmation: Enable to include a balance confirmation section.
- Company Stamp: Choose to display the company stamp in the balance confirmation and/or next to the ending balance.
- Font Size: Select small, medium, or large font size for better readability.
- Generate Report: Click "Print" to generate the report in PDF format.
Balance Confirmation Features
When the balance confirmation option is enabled, the report includes:
- A professional balance confirmation letter in either English or Arabic (based on the user's language).
- The partner's current balance clearly displayed.
- Signature fields for both the partner and company representatives.
- Optional company stamp for official documentation.
- Current date automatically included at the top of the confirmation.
Technical Details
Module Architecture
The module is built on Odoo's standard accounting framework and extends it with the following components:
- Partner Ledger Wizard: A comprehensive wizard with extensive filtering and display options.
- Report Templates: Multiple report templates for different report types (detailed, summary by salesperson, summary by team).
- Company Stamp Integration: Seamless integration with the an_company_stamp module.
- Multilingual Support: Full support for both LTR and RTL languages with proper formatting.
Key Technical Features
- Dynamic Date Range Selection: Intelligent date calculations for various periods (today, this week, this month, etc.).
- Advanced Partner Filtering: Filter by individual partners, partner categories, salesperson, or sales team.
- Detailed Transaction Analysis: Comprehensive analysis of partner transactions with running balances.
- Invoice Line Details: Detailed display of invoice line items including products, quantities, and prices.
- Error Handling: Robust error handling for missing records in Many2one fields.
- Responsive Design: Reports adapt to different font sizes and display environments.
- RTL Support: Proper right-to-left formatting for Arabic and other RTL languages.
Dependencies
- account: Odoo's standard accounting module
- an_company_stamp: Module for managing company stamp images
Report Types
- Detailed Partner Ledger: Comprehensive transaction history for each partner with running balances.
- Partner Summary by Salesperson: Summary of partner balances grouped by salesperson.
- Partner Summary by Sales Team: Summary of partner balances grouped by sales team.
- Balance Confirmation: Professional balance confirmation reports for client signature.
Contact Information
Ahmed Nour
Email: ahmednour@outlook.com
Website: odoosa.net
Please log in to comment on this module