6.3 Multi-Currency Setup & Exchange Rates

6.3 Multi-Currency Setup & Exchange Rates

Quick Summary: Microsoft Dynamics 365 Business Central provides a robust multi-currency engine. The company's base functional currency is designated as Local Currency (LCY) in General Ledger Setup. All other currencies are maintained on the Currencies page with dedicated G/L accounts for Realized and Unrealized Gains/Losses. Exchange rates are configured chronologically in the Currency Exchange Rates subpage, where the Fix Exchange Rate Amount parameter controls user editability on transaction headers. At period-end, the Adjust Exchange Rates batch job revalues open subledger balances. For multinational compliance, an Additional Reporting Currency (ACY) maintains dual-currency accounting across the General Ledger.

---

Multi-Currency Architecture in Business Central

In Dynamics 365 Business Central, multi-currency processing is embedded across sales, purchasing, banking, and general ledger operations:

• Local Currency (LCY): The base operational currency defined in General Ledger Setup. When a transaction occurs in LCY, the Currency Code field is left blank. The General Ledger stores all monetary balances in LCY.
• Foreign Currency (FCY): Any transaction involving an international customer, foreign vendor, or non-domestic bank account carries an explicit foreign Currency Code (e.g., EUR, CAD, USD, GBP).
• Dual Storage of Amounts: Every transaction involving foreign currency stores values in both currencies across ledger entries:
  • Subledgers (Customer/Vendor Ledger Entries) record both the foreign currency amount (e.g., Amount) and the converted local currency equivalent (e.g., Amount (LCY)).
  • The General Ledger (G/L Entries) records amounts strictly in LCY (unless an Additional Reporting Currency is enabled).

Currency Architecture Comparison:

Transaction Currency: LCY (Local)
  ├── Document Currency Code: [BLANK]
  ├── Customer/Vendor Ledger: Stored in LCY
  └── General Ledger Entry:   Stored strictly in LCY

Transaction Currency: FCY (Foreign - e.g., EUR)
  ├── Document Currency Code: 'EUR'
  ├── Customer/Vendor Ledger: Stored in EUR (Original) AND LCY (Converted)
  └── General Ledger Entry:   Stored strictly in LCY (Converted at document rate)

---

The Currencies Card & General Ledger Account Mapping

Foreign currencies are created and maintained on the Currencies page (Alt+Q -> type Currencies).

UI Navigation Path:
Tell Me (Alt+Q) -> Currencies -> Open Currency Card

Core Metadata & Rounding Settings

• Code: Standard ISO code (e.g., EUR, CAD, GBP, JPY).
• Description & Symbol: Visual text and currency symbol (e.g., €, £, ¥).
• ISO Code & ISO Numeric Code: Required for electronic banking formats, PEPPOL electronic invoicing, and regulatory reporting.
• Invoice Rounding Precision & Type: Defines the rounding threshold (e.g., 0.01, 0.05) and direction (Nearest, Up, Down) applied to document totals in this foreign currency.

Account Mapping FastTab: Foreign Exchange Gain and Loss Accounts

When exchange rates fluctuate, Business Central posts currency variances to specific G/L accounts designated on the Currency Card:

[!IMPORTANT] Realized vs. Unrealized Distinctions on the MB-800 Exam:

• Realized Gain/Loss: Requires an application (closing of an invoice with a payment). It represents actual economic profit or loss realized upon cash conversion.
• Unrealized Gain/Loss: Generated without settlement by the Adjust Exchange Rates batch job at period-end. It reflects balance sheet revaluation of outstanding open balances under prevailing spot rates.

---

Currency Exchange Rates & Relational Rate Quotations

Exchange rates are maintained on the Currency Exchange Rates subpage (Currencies Page -> Action: Exchange Rates).

UI Navigation Path:
Tell Me (Alt+Q) -> Currencies -> Select Currency -> Action: Exchange Rates

Exchange Rate Structure & Rate Math

Business Central uses a two-factor relational ratio to define exchange rates:

• Starting Date: The effective date from which this exchange rate applies. The rate remains valid for all transactions until a new record with a subsequent Starting Date is created.
• Relational Currency Code: If left blank, the exchange rate is quoted directly against the company's Local Currency (LCY). If populated with another currency code, it defines a triangular cross-rate.
• Exchange Rate Amount: The base unit quantity of the foreign currency (typically 1.00, or 100.00 for high-denomination currencies such as Japanese Yen).
• Relational Exch. Rate Amount: The equivalent value in the relational currency (LCY).

$\text{Effective Exchange Rate} = \frac{\text{Relational Exch. Rate Amount}}{\text{Exchange Rate Amount}}$

Example 1: Base Currency = USD (LCY), Foreign Currency = EUR

• Exchange Rate Amount = 1.00
• Relational Exch. Rate Amount = 1.08
  Calculation: 1 EUR = 1.08 USD.

Example 2: Base Currency = USD (LCY), Foreign Currency = JPY

• Exchange Rate Amount = 100.00
• Relational Exch. Rate Amount = 0.65
  Calculation: 100 JPY = 0.65 USD.

The "Fix Exchange Rate Amount" Parameter

When operators enter a sales order or purchase invoice, Business Central populates the exchange rate from the Currency Exchange Rates table. The Fix Exchange Rate Amount setting determines whether and how users can modify the exchange rate on the document header:

---

The Adjust Exchange Rates Batch Job: Managing Unrealized Fluctuations

At the end of each reporting period, financial consultants run the Adjust Exchange Rates batch job (Alt+Q -> type Adjust Exchange Rates).

UI Navigation Path:
Tell Me (Alt+Q) -> Adjust Exchange Rates

Operational Scope of the Batch Job

The batch job inspects all open, unsettled ledger entries across three primary subledgers:

1. Customer Ledger Entries: Open foreign currency accounts receivable.
2. Vendor Ledger Entries: Open foreign currency accounts payable.
3. Bank Account Ledger Entries: Foreign currency bank accounts.

Accounting Execution Example

1. On November 10, a sales invoice is posted for €10,000 when 1 EUR = $1.05 USD.
   Recorded Receivable: €10,000 ($10,500 LCY).
2. On November 30, the invoice remains unpaid. The spot exchange rate is now 1 EUR = $1.10 USD.
3. The accountant runs Adjust Exchange Rates as of November 30:
   • Business Central recalculates the open receivable: €10,000 × 1.10 = $11,000 LCY.
   • An unrealized gain of $500 USD is recognized.
   • Detailed Customer Ledger Entry created: Type = Unrealized Gain, Amount (LCY) = $500.
   • General Ledger Entries posted:
     • Debit: Accounts Receivable Control Account ($500 LCY)
     • Credit: Unrealized Foreign Exchange Gains Account ($500 LCY)
4. If the customer subsequently pays on December 15 when 1 EUR = $1.12 USD ($11,200 LCY):
   • Business Central automatically reverses the $500 unrealized gain.
   • Business Central posts the final total Realized Gain of $700 USD to the Realized Gains Account.

---

Additional Reporting Currency (ACY) & Dual-Currency Accounting

Multinational enterprises or subsidiaries of foreign corporations frequently must report financial statements in two distinct currencies (e.g., local statutory reporting in Canadian Dollars [CAD], and parent consolidation in US Dollars [USD]). Business Central fulfills this requirement via the Additional Reporting Currency (ACY).

UI Navigation Path:
Tell Me (Alt+Q) -> General Ledger Setup -> Additional Reporting Currency

Core Architecture of ACY

When an Additional Reporting Currency is enabled on the General Ledger Setup card:

• Every subsequent G/L Entry records transaction values in both LCY and ACY simultaneously.
• Database columns in the G/L Entry table store: Amount (LCY), Debit Amount (LCY), Credit Amount (LCY), along with Additional-Currency Amount (ACY), Add.-Currency Debit Amount (ACY), and Add.-Currency Credit Amount (ACY).
• Subledgers (Customer, Vendor, Item) continue to operate in LCY and document foreign currency; ACY exists strictly within the General Ledger domain.

Initializing ACY: The Conversion Batch Job

When a consultant selects an ACY code on General Ledger Setup for a company with existing transactions, Business Central displays a confirmation prompt. The system requires executing the Adjust Additional Reporting Currency batch job:

• Historical entries are converted using historical exchange rates or an entered baseline rate.
• Any rounding variances resulting from the initial conversion are posted to the Conv. LCY Rndg. Debit/Credit Accounts defined on the Currency Card.

G/L Account Exchange Rate Adjustment Settings

Not all general ledger accounts should be revalued identically. On each G/L Account card, consultants configure the Exchange Rate Adjustment field:

When the Adjust Exchange Rates batch job runs with the Adjust G/L Accounts for Add.-Reporting Currency toggle enabled, Business Central scans all G/L accounts set to Adjust Additional-Currency Amount, posting unrealized currency adjustments to the Unrealized G/L Gains/Losses accounts.