Display Foreign Currency Accounts in Both Local and Foreign Currency (DR, CR, and Balance)

[Mina-Geez]

Current Issue
ERPNext currently displays account balances for foreign currency accounts either in the local currency or the foreign currency, depending on the configuration. However, many businesses require both local and foreign currency amounts (Debit, Credit, and Balance) to be visible side by side for accurate reconciliation and reporting, especially in multi-currency environments.

Proposed Solution
Enhance ERPNext's reporting and ledger views to display foreign currency accounts with dual currency columns, showing both:

Local Currency (converted using the exchange rate).
Foreign Currency (as entered).
This would apply to:

General Ledger
Account Ledger
Trial Balance
Financial Reports

Key Features
Dual Currency Display:

Add columns in reports to display DR, CR, and Balance in both Local and Foreign currencies.
Exchange Rate Integration:

Display the exchange rate used for the conversion to ensure transparency.
User Configuration:

Allow users to toggle the dual currency display in report settings.
Export Compatibility:

Ensure the additional columns are included in exported reports (PDF, Excel, etc.).

Use Case Examples

Multinational Business:

A company dealing with USD and EUR accounts in an EGP-based ledger can track transactions and balances in both the foreign and local currencies simultaneously.

Auditors and Compliance:

Auditors need clear visibility of how foreign currency transactions impact local currency balances, along with the applied exchange rate.

Bank Reconciliation:

Comparing foreign currency bank statements with ERPNext records becomes easier when both currencies are displayed.