Dual currency

In Microsoft Dynamics 365 Finance, you can repurpose the reporting currency and use it as a second accounting currency. This functionality is known as dual currency. You can't turn off the changes for dual currency through a configuration key or parameter. Because the reporting currency serves as a second accounting currency, the way the reporting currency is calculated in the posting logic changes.

In addition, several modules are enhanced to track, report, and use the reporting currency in various processes. The affected modules include:

• General ledger
• Financial reporting
• Accounts payable
• Accounts receivable
• Cash and bank management
• Fixed assets
• Consolidations

After an upgrade, you must complete specific steps for Cash and bank management and Fixed assets. Therefore, be sure to read and understand the relevant sections of this article.

Posting process

The posting logic changed for all transactions that generate an accounting entry to general ledger. Here's how the reporting currency was previously calculated:

Transaction currency amount > Accounting currency amount > Reporting currency amount

For example, you enter a transaction in the Canadian dollar (CAD) currency. The CAD amount translates to the accounting currency, which is the US dollar (USD). The USD amount then translates to the reporting currency, which is the euro (EUR). Therefore, the exchange rates must exist between CAD and USD, and between USD and EUR.

Here's the new calculation:

Transaction currency amount > Accounting currency amount

Transaction currency amount > Reporting currency amount

Because of this change, exchange rates must now exist between CAD and USD, and between CAD and EUR.

Reports and inquiries

Various reports and inquiries now show both reporting currency amounts and accounting currency amounts. Not every report and inquiry is updated. For example, reports that show amounts only in the transaction currency didn't change.

The changes follow one of two patterns:

• If the report or inquiry had enough space to show amounts in both the accounting currency and the reporting currency, the reporting currency amounts were added.
• If the report or inquiry didn't have enough space to show amounts in both currencies, an option was added so that users can select which currency is shown.

For various reports and inquiries, logic was also added to suppress the reporting currency amounts if the reporting currency is the same as the accounting currency, or if the reporting currency wasn't defined on the ledger for the legal entity.

Financial journals

The financial journals, such as the general journal and vendor invoice journal, now include more information about the reporting currency. The totals for the voucher and journal show the reporting currency. You can see the reporting currency's exchange rate on the General tab of the journal lines. You can override the reporting currency's exchange rate when you enter transactions.

Vendor invoices, sales orders, and sales agreements

Vendor invoices, sales orders, and sales agreements have been updated to include a fixed exchange rate for the reporting currency. A fixed exchange rate can be defined for both the accounting currency and reporting currency when the transaction currency is different. When the accounting currency and reporting currency are the same, the fixed exchange rate is kept in sync by using the accounting currency’s fixed rate as the reporting currency’s fixed rate. The reporting currency fixed exchange rate can't be changed for this configuration. When the accounting currency and reporting currency differ, a fixed exchange rate can be defined for both the accounting currency and reporting currency during transaction entry. If the reporting currency hasn't been defined on the ledger, the Reporting currency fixed exchange rate field isn't enabled, and no reporting currency amount is calculated.

Module changes

The following modules use the reporting currency as a second accounting currency:

• General ledger
• Financial reporting
• Accounts payable
• Accounts receivable
• Cash and bank management
• Fixed assets
• Consolidations

General ledger

If a reporting currency was defined on the ledger, the general ledger already tracked reporting currency amounts on every accounting entry. However, those amounts are now translated from the transaction currency amounts.

The following additional changes were made in the General ledger module:

• You can define a separate exchange rate type for the reporting currency on the ledger. If you don't want to use a different exchange rate type, you can leave the field for the exchange rate type for the reporting currency blank. Alternatively, you can select the same exchange rate type that is used for the accounting currency. If you leave the field blank, the system uses the exchange rate type for the accounting currency.
• A new journal, the Reporting currency adjustment journal, enables adjustments to be posted to ledger accounts in the reporting currency only. This journal enables posting only to ledger accounts. It doesn't support intercompany, and the currency must be the reporting currency of the legal entity where the journal is posted. When the journal is posted, the transaction currency and accounting currency amounts are 0 (zero), and the reporting currency amount is posted with the amount that is entered on the transaction. Because the way that the reporting currency is used in the Accounts payable, Accounts receivable, and Fixed assets modules have changed, this journal can be used for adjustments after an upgrade. For examples that show how this journal can be used, see the sections for those modules.
• The process for period allocation is updated so that it allocates amounts in the transaction, accounting, and reporting currencies. Previously, the process allocated amounts in the transaction and accounting currencies, and then the accounting currency amount was translated to the reporting currency. That behavior could cause a balance to remain on the ledger account in the reporting currency. Now, when amounts are calculated and used in the accounting entry, no translation occurs.
• The process for foreign currency revaluation already revalued amounts in the reporting currency. However, the reporting currency amount is now calculated through the transaction currency amount, as described in the Posting process section earlier in this article.
• Many reports and inquiries in General ledger already had the reporting currency, but a few didn't. One example is the Trial balance list page. This list page now includes columns for both the accounting currency and the reporting currency. The columns for the reporting currency are hidden if the accounting currency and the reporting currency are the same, or if no reporting currency was defined on the ledger.

Financial reporting

An enhancement to the Financial reporting module lets you include reporting currency amounts on a financial statement in two ways. On the column definition, you can report directly on the reporting currency amounts that are posted to the ledger (new functionality). Alternatively, you can continue to translate amounts from the accounting currency to the reporting currency (existing functionality).

This change is available through the Currency display setting in the column definition. If you select Reporting currency from ledger, amounts in the column aren't translated. Instead, they're reported directly from the general ledger. If you want the column to show translated amounts, select the Translate to XXXX option, where XXXX is the reporting currency that the column should show. In this case, accounting currency amounts are translated to the selected currency by using the existing translation functionality.

Accounts payable and Accounts receivable

The Accounts payable and Accounts receivable modules already tracked reporting currency amounts. However, the amounts weren't shown or used for various processes. The following changes were made:

• Reporting currency amounts are now shown on transactions for both customers and vendors. Reporting currency amounts are also shown for the open balance of each transaction.
• The aging process is updated so that an organization can view the aging buckets in either the accounting currency or the reporting currency.
• Various inquiries and reports were updated so that they show reporting currency amounts. Examples include the Customer to ledger reconciliation and Vendor to ledger reconciliation reports.
• The process for foreign currency revaluation already revalued amounts in the reporting currency. However, the reporting currency amount is now calculated through the transaction currency amount, as described in the Posting process section.
• Upgrade consideration: Before an upgrade, the reporting currency amounts for documents (invoices, payments, and so on) are calculated through the accounting currency. For example, an invoice is posted before an organization upgrades, and the invoice isn't paid. During the upgrade, the invoice's accounting entry isn't changed. However, after the upgrade, the changes for dual currency are in effect. Therefore, when a payment is made for the invoice, the payment's reporting currency amount is now calculated through the transaction currency amount. When the payment and invoice are settled, a slight difference might be calculated in the realized gain/loss amount, because reporting currency amounts are now calculated differently. If the difference that is calculated is considered significant, the new Reporting currency adjustment journal can be used to adjust the balance of the realized gain/loss and Accounts payable/Accounts receivable ledger accounts in the reporting currency only.

Cash and bank management

Previously, the Cash and bank management module didn't track any reporting currency amounts for transactions that you posted against each bank account. After an upgrade, the system automatically tracks reporting currency amounts for any new transactions that you post. However, you must add reporting currency amounts to previously posted transactions in the subledger.

• Upgrade consideration: Because bank account transactions didn't previously track reporting currency amounts in the subledger, a wizard is available so that you can add reporting currency amounts to bank account transactions. This wizard doesn't post to the general ledger again. Instead, it takes the reporting currency amounts from the general ledger and updates them in the subledger tables.

  • To start the wizard, select Cash and bank management > Setup > Add reporting currency amounts to bank account transactions.
  • The wizard shows transactions for all bank accounts in the current company that have a reporting currency amount of 0 (zero). It only includes transactions that you posted before the upgrade.
  • For each bank account transaction, the wizard finds the corresponding accounting entries in the general ledger and enters a default reporting currency amount. Although you can edit the amounts, don't edit them. Otherwise, you might not be able to reconcile the bank account balances to the general ledger. The only time that you should edit an amount is if the reporting currency amount can't be found in the general ledger. In that case, the wizard shows an amount of 0 (zero) for the reporting currency.
  • If you select Cancel in the wizard, the system saves the bank account transactions and any changes to the reporting currency amounts until the next time that you run the wizard. However, the system doesn't update the reporting currency amounts on the bank account transactions. That update occurs only when you select Finish in the wizard. You can run the wizard multiple times. Therefore, you can fix any incorrect reporting currency amounts if you make a mistake.

• No processes in Cash and bank management changed, but various reports and inquiries were updated so that they show reporting currency amounts. The cash flow forecasting reports are an exception. They weren't updated to include the reporting currency amounts.

Fixed assets

Previously, the Fixed assets module didn't track any reporting currency amounts for transactions that you posted against each fixed asset book. After an upgrade, the system automatically tracks reporting currency amounts for any new transactions. However, you must add reporting currency amounts to previously posted transactions in the subledger.

In addition, major changes were made to the depreciation process. These changes require user action after an upgrade. It's important that you read and understand the following changes, even if you aren't yet using Fixed assets.

• The way that the depreciation process determines the reporting currency amount has changed. The following scenario compares how depreciation previously determined the reporting currency amount and how it determines the reporting currency amount now.

  Depreciation scenario

  An asset is acquired and posted with the following amounts. The reporting currency amount is posted in the general ledger, but it isn't stored in the Fixed asset subledger tables.

  Transaction type	Transaction amount	Exchange rate	Accounting currency amount	Exchange rate	Reporting currency amount
  Acquisition	1,000,000 DKK	2.0	500,000 USD	2.5	200,000 EUR

  Previous depreciation for the reporting currency

  At the end of the year, the depreciation proposal is run and calculates the following amounts.

  Transaction type	Transaction amount	Exchange rate	Accounting currency amount	Exchange rate	Reporting currency amount
  Depreciation	50,000 USD	1.0	50,000 USD	2.6	19,230.77 EUR

  When the depreciation proposal is run, it calculates the accounting currency amount by using the depreciation method. It then translates that amount to the reporting currency by using the current exchange rate between USD and EUR. This translation causes problems, because the asset can't be fully depreciated in the reporting currency when the spot rate is used.

  New depreciation for the reporting currency

  The depreciation process was changed so that it calculates the reporting currency amount by using the depreciation method. Here are the results when depreciation is run on the asset.

  Transaction type	Transaction amount	Exchange rate	Accounting currency amount	Exchange rate	Reporting currency amount
  Depreciation	50,000 USD	1.0	50,000 USD	2.5 NOTE: Although this exchange rate is shown, it isn't used to translate to the reporting currency.	20,000 EUR

  When the depreciation proposal is run, it calculates both the accounting currency amount and the reporting currency amount by using the depreciation method. The amounts are then used in the accounting entry in the general ledger. No translation is done to determine the reporting currency amount.

• Upgrade consideration: Because fixed asset book transactions didn't previously track the reporting currency, a wizard was added so that you can add reporting currency amounts to fixed asset book transactions. This wizard doesn't post to the general ledger again. Because the way that the depreciation proposal calculates reporting currency amounts changed, you must run and complete the wizard for every company before an organization can enter any depreciation transactions.

  • To start the wizard, select Fixed assets > Setup > Add reporting currency amounts to fixed asset books.
  • The wizard shows transactions for all fixed asset books in the current company that have a reporting currency amount of 0 (zero). Only transactions that you posted before the upgrade are included.
  • The wizard doesn't pull the reporting currency amounts from the general ledger. As was described in the previous scenario, the reporting currency amounts that were originally posted to the general ledger incorrectly used the spot rate. Those amounts shouldn't appear in the fixed asset subledger, because the next depreciation calculation will use the incorrect amounts. Instead, the wizard finds the exchange rate on the date of the first acquisition. It then uses that exchange rate to recommend the reporting currency amount that should be posted in the subledger. For example, here's what the wizard might show for the previous scenario.

• Many customers tracked their asset transaction details in workbooks. These details include the exchange rates and amounts. If you have this data in a workbook, you can create a custom exchange rate type and update it with the exchange rates from the workbook. This exchange rate type is then used to enter a default exchange rate on the acquisition date and calculate the reporting currency amount. If an exchange rate type isn't selected, the wizard uses the exchange rate type that was defined on the ledger.

• You can change the exchange rate and reporting currency amounts. If you change the exchange rate, the reporting currency amount is recalculated by using the new rate.

• If you select Cancel in the wizard, the fixed asset book transactions and any changes to the exchange rate or reporting currency amounts are saved until the next time that you run the wizard. However, the reporting currency amounts aren't updated on the fixed asset book transactions. That update occurs only when you select Finish in the wizard. You can run the wizard multiple times. Therefore, you can fix any incorrect reporting currency amounts if you make a mistake.

• When the reporting currency amounts are updated in the subledger, you must set the Have you updated all the reporting currency amounts on the fixed asset book transactions? option to Yes and then select Finish. Depreciation calculations can't be completed until you set the Have you updated all the reporting currency amounts on the fixed asset book transactions? option to Yes. After that option is set to Yes, the wizard is no longer available.

• After the fixed asset transactions in the subledger are updated with reporting currency amounts, those amounts don't match the amounts that were originally posted to the general ledger. However, the Reporting currency adjustment journal can be used to update the balances of the depreciation ledger accounts in the general ledger, so that they match the amounts that were originally posted.

• A new Asset transaction reporting currency amounts entity that was added in the Data management workspace lets you export the data from the wizard. You can then use the data to determine the balance in the fixed asset subledger for the depreciation transactions. That balance can then be used to determine the amount of the reporting currency adjustment in the general ledger.

• Upgrade consideration: New setup fields were added to fixed assets and are used in the depreciation calculation. You might have to update these fields before the next depreciation calculation.

  • On the fixed asset book (Fixed assets > Books), the General FastTab has a new Acquisition price in reporting currency field.
  • On the fixed asset book (Fixed assets > Books), the Depreciation FastTab has a new Expected scrap value in reporting currency field.
  • In the Fixed asset parameters (Fixed assets > Setup > Fixed asset parameters), the General FastTab has a new Minimum depreciation amount in reporting currency field.
  • On books (Fixed assets > Setup > Books), the General FastTab has two new fields: Round off depreciation in reporting currency and Leave net book value at reporting currency.

• Because the depreciation proposal now calculates amounts in both the accounting currency and the reporting currency, the Fixed asset journal is updated so that it shows depreciation amounts in the reporting currency. For depreciation transactions, the transaction currency is always the accounting currency. Therefore, those amounts continue to appear in the Debit and Credit columns. Two new columns, Debit in reporting currency and Credit in reporting currency, are added to the grid.

  • The new fields are available only when the transaction type is one of the four depreciation types: Deprecation, Depreciation adjustment, Extraordinary depreciation, or Special depreciation allowance.
  • If you enter a deprecation transaction type in the Fixed asset journal, the reporting currency amounts appear in the new columns. You can change those amounts.
  • If the accounting currency and the reporting currencies on the ledger are the same, the amounts stay in sync. If you change the Credit amount, the Credit in reporting currency amount automatically changes so that it matches.
  • If you enter any other transaction type in the Fixed asset journal, the Debit in reporting currency and Credit in reporting currency amounts never show, either before or after posting. The accounting currency and reporting currency amounts are still available on the voucher that posts to the general ledger.

Consolidations

In Dynamics 365 Finance, feature management provides enhanced flexibility for consolidation and dual currency. To enable this functionality, go to the Feature management workspace and select Enable dual currency functionality in General ledger consolidation.

In General ledger consolidation, there's an option to consolidate either the accounting or reporting currency amounts from the source companies. If the accounting or reporting currency is the same as the accounting or reporting currency in the consolidation company, the amounts are copied directly rather than translated.

• You can now choose whether to use the accounting currency or the reporting currency from the source company as the transaction currency in the consolidation company.

• The accounting or reporting currency amounts from the source company will be copied directly to the accounting or reporting currency amounts in the consolidation company, if either of the currencies are the same. The accounting and reporting currency amounts in the consolidation company are calculated using the exchange rate if neither of the currencies is the same.