| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 228 |
| Technical Name |
account_multi_currency_extend |
| License | LGPL-3 |
| Versions | 18.0 19.0 |
📊 Account Multi Currency Extend
Odoo 19.0
Accounting
OPL-1
Module Overview
Account Multi Currency Extend is a powerful Odoo module that enables companies to track and manage transactions in a second currency alongside the company's primary currency. This module is essential for businesses operating in multi-currency environments, particularly in regions where financial reporting requires dual currency tracking.
🎯 Key Features
- Dual Currency Tracking - Track all accounting transactions in both company currency and a second reporting currency
- Automatic Exchange Calculations - Automatic conversion of debit/credit amounts to the second currency using real-time exchange rates
- Journal Entry Enhancement - Extended journal entry lines with exchange amount fields (debit_exchange, credit_exchange, exchange_amount)
- Company-Level Configuration - Enable second currency tracking at the company level with flexible settings
- Dynamic Column Visibility - Exchange currency columns automatically show/hide based on company configuration
- Multi-Company Support - Full support for multi-company environments with independent currency settings
- Trial Balance Ready - Exchange columns designed for enhanced trial balance reporting
- Smart Currency Handling - Intelligent handling when transaction currency matches the second currency
- Tax Group Validation - Additional validation to ensure tax groups match tax country settings
📋 Technical Specifications
Module Information
| Property | Value |
|---|---|
| Module Name | account_multi_currency_extend |
| Version | 19.0 |
| Author | Bn Technologies |
| Category | Accounting/Accounting |
| License | OPL-1 (Odoo Proprietary License) |
| Dependencies | base, account, sale |
| Auto Install | True |
Extended Models
This module extends the following Odoo models:
account.move- Journal Entriesaccount.move.line- Journal Entry Linesaccount.tax- Tax Configurationres.company- Company Settingsres.config.settings- Accounting Settings
⚙️ Installation
- Download the module and extract it to your Odoo addons directory
- Restart your Odoo server to load the new module
- Navigate to Apps menu and update the apps list
- Search for "Account Multi Currency Extend"
- Click Install button
⚠️ Important: This module is set to auto-install. Ensure you have the required dependencies (base, account, sale) installed before activating this module.
🔧 Configuration
Enable Second Currency
- Navigate to Settings → Companies → Update Company
- Enable the checkbox "Enable Second Currency"
- Select your desired second currency from the dropdown
- Save the configuration
Alternative Configuration Path
- Go to Accounting → Configuration → Settings
- Scroll to the "Second Currency" section
- Select your second currency
- Click Save
💡 Tip: The second currency configuration is company-specific. In multi-company environments, each company can have its own second currency setting.
📊 New Fields Reference
Company Level Fields (res.company)
enable_second_currency_for_company
Type: Boolean
Description: Master switch to enable/disable second currency tracking for the company
second_currency_id
Type: Many2one (res.currency)
Description: The second currency to be used for exchange calculations
Journal Entry Fields (account.move)
enable_second_currency_for_company
Type: Boolean (Related field)
Description: Related to company's second currency enable status
company_second_currency_id
Type: Many2one (Related field)
Description: Related to company's second currency
Journal Entry Line Fields (account.move.line)
exchange_currency
Type: Many2one (res.currency)
Description: The second currency used for exchange calculations (related to company's second currency)
exchange_amount
Type: Monetary
Description: The balance amount (debit - credit) converted to the second currency
Computation: Automatically calculated based on debit, credit, and exchange rates
debit_exchange
Type: Monetary
Description: Debit amount in the second currency
Computation: Positive value of exchange_amount
credit_exchange
Type: Monetary
Description: Credit amount in the second currency
Computation: Absolute value of negative exchange_amount
🎨 User Interface Enhancements
Journal Entry Form View
- New columns for exchange_amount, debit_exchange, and credit_exchange in journal entry lines
- Automatic column visibility based on second currency configuration
- Sum totals for all exchange fields at the bottom of the journal entry
- Reordered currency fields for better usability
Journal Entry Lines Tree View
- Exchange fields available in the account.move.line tree view
- Optional visibility for exchange columns
- Total sum calculations for exchange amounts
Company Configuration
- Simple checkbox to enable/disable second currency
- Currency selector with no-create and no-open options for better UX
- Required validation when second currency is enabled
💼 Business Use Cases
1. Multi-National Corporations
Companies operating in countries with unstable currencies can track all transactions in both local currency and a stable reference currency (e.g., USD or EUR) for better financial analysis.
2. Regulatory Compliance
Some jurisdictions require businesses to maintain accounting records in multiple currencies. This module helps meet such regulatory requirements automatically.
3. Financial Reporting
Generate trial balances and financial statements showing both currencies side-by-side for comprehensive financial analysis and stakeholder reporting.
4. Exchange Rate Analysis
Track exchange rate impacts on financial performance by comparing transactions in both currencies over time.
🔄 How It Works
Exchange Amount Calculation Logic
The module uses intelligent currency conversion:
- Currency Match Detection: If the transaction currency already matches the second currency, it uses the amount_currency directly
- Balance Conversion: Otherwise, it calculates the balance (debit - credit) in company currency and converts it to the second currency
- Date-Based Rates: Uses the transaction date for exchange rate lookup, ensuring accurate historical conversions
- Automatic Debit/Credit Split: Automatically splits the exchange_amount into debit_exchange or credit_exchange based on the sign
Field Dependencies
@api.depends('debit', 'credit', 'currency_id', 'amount_currency',
'company_id.second_currency_id', 'company_id.currency_id')
def _compute_exchange_amount(self):
# Calculates exchange_amount based on:
# - Transaction debit and credit
# - Transaction currency
# - Company currency
# - Second currency configuration
# - Transaction date for exchange rates
✨ Additional Features
Tax Group Validation
The module includes enhanced validation for tax configurations to ensure data integrity:
- Validates that tax groups have the same country as the taxes using them
- Prevents configuration errors that could lead to reporting issues
- Provides clear error messages when validation fails
Enhanced Invoice Date Handling
- Improved invoice date field with future date warnings
- Dynamic required attribute based on move type
- Better visibility control for different document types
📝 Technical Notes
Performance Considerations:
- All exchange fields are stored in the database (store=True) for better query performance
- Fields use precompute=True for efficient calculation on new records
- Computed fields have readonly=False to allow manual adjustments if needed
Database Impact:
- Adds 4 new fields to account.move.line table
- Adds 2 new fields to res.company table
- All fields are properly indexed for optimal performance
🐛 Troubleshooting
Exchange Columns Not Visible
Solution: Ensure "Enable Second Currency" is checked in company settings and a second currency is selected.
Exchange Amounts Not Calculating
Solution: Check that currency exchange rates are configured in Accounting → Configuration → Currencies → Rates
Tax Group Validation Error
Solution: Ensure tax groups and taxes have matching country configurations. Go to Accounting → Configuration → Taxes and verify country settings.
🔐 Security & Permissions
This module respects all standard Odoo accounting security groups:
- Only users with accounting access rights can configure second currency
- Multi-company access rules are automatically applied
- Currency exchange fields follow the same access rights as standard accounting fields
🔄 Compatibility
| Component | Compatibility |
|---|---|
| Odoo Version | 19.0 (Community & Enterprise) |
| Multi-Company | ✅ Fully Supported |
| Multi-Currency | ✅ Enhanced Support |
| Accounting Localization | ✅ Compatible with all localizations |
📚 Support & Documentation
For additional support, customization requests, or bug reports, please contact:
- Author: Bn Technologies
- Module Version: 19.0
- License: OPL-1 (Odoo Proprietary License)
🎓 Best Practices
- Exchange Rate Updates: Keep your currency exchange rates up to date for accurate conversions
- Historical Accuracy: Avoid changing the second currency after transactions are posted
- Backup Before Configuration: Always backup your database before enabling second currency on production systems
- Testing: Test the module thoroughly in a staging environment before production deployment
- Training: Train your accounting team on the new fields and their purpose
📈 Future Enhancements
Planned features for future versions:
- Dedicated reports showing side-by-side currency comparison
- Exchange gain/loss calculation and tracking
- Historical exchange rate analysis
- Multi-currency trial balance report
- Dashboard widgets for currency tracking
Account Multi Currency Extend © 2025 Bn Technologies | Version 19.0 | OPL-1 License
Designed for Odoo 19.0 | Professional Accounting Solution
Please log in to comment on this module