Exchange rate type for AP/AR and Bank foreign currency revaluation D365 Finance and operations

Idea posted in 2019.

We have the possibility to do foreign currency revaluation separate for both Accounts Payable and Accounts Receivable (and now from version 10 even Cash and Bank module). However, the exchange rate type used for revaluation is determined from the accounting currency exchange rate type in Ledger setup. For FX revaluations performed in GL-module, every main account has the option of overriding the standard (Ledger) exchange rate type. Please add a parameter for setting the exchange rate type used for FX revaluation in AP, AR and Cash and Bank modules.

Microsoft is releasing new changes to define different exchange rate for Account payable, Accounts receivable and Bank for bank module.

You need to enable following features to use this option.

Exchange rate option AP and AR module can be enabled using following feature.

Exchange rate type enhancement for accounts payable and accounts receivable foreign currency revaluation

Exchange rate option for Bank module can be enabled using following feature.

Exchange rate type enhancement for bank foreign currency revaluation

Set up an additional exchange rate type for Accounts receivable foreign currency revaluation.


Go to Accounts receivable > Setup > Accounts receivable parameters.

On the Ledger and sales tax tab, in the Exchange rate type source field, select one of the following options:

Ledger – Use the exchange rate type that’s defined in the ledger setup.


Specific – Use the accounting currency exchange rate type and reporting currency exchange rate type that are defined in the current legal entity.


Group – Use the accounting currency exchange rate type and reporting currency exchange rate type that are defined in the customer group

Set up an additional exchange rate type for Accounts payable foreign currency revaluation.


Go to Accounts payable > Setup > Accounts payable parameters.

On the Ledger and sales tax tab, in the Exchange rate type source field, select one of the following options:

Ledger – Use the exchange rate type that’s defined in the ledger setup.


Specific – Use the accounting currency exchange rate type and reporting currency exchange rate type that are defined in the current legal entity.


Group – Use the accounting currency exchange rate type and reporting currency exchange rate type that are defined in the vendor group.

Set up an additional exchange rate type for Cash and Bank foreign currency revaluation

Go to Cash and bank management > Setup > Cash and bank management parameters.

On the General tab, in the Exchange rate type source field, select one of the following values:

Ledger – Use the exchange rate type that’s defined in the ledger setup.
Specific – Use the accounting currency exchange rate type and reporting currency exchange rate type that are defined in the current legal entity.
Bank – Use the accounting currency exchange rate type and reporting currency exchange rate type that are defined in the bank account.

Cash and Bank can be setup similar way like AR and AP.

You can follow section “Process a foreign currency revaluation” from following section to run foreign currency revaluation.

Currency revaluation for Accounts payable and Accounts receivable – Finance | Dynamics 365 | Microsoft Learn

Leave a comment

Design a site like this with WordPress.com
Get started