(EEUR) Calculate exchange rate adjustments for bank account transactions [AX 2012]

Updated: January 30, 2013

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

You must revalue and adjust bank accounts if there is a difference in the exchange rate between the accounting currency and the reporting currency. This helps you to calculate the correct balance in the accounting currency and the reporting currency for the bank accounts.


This process is applicable for Latvia, Lithuania, and the Czech Republic.

  1. Click Cash and bank management > Setup > Cash and bank management parameters.

  2. In the left pane, click Number sequences.

  3. In the Number sequences area, in the Reference field, select a number sequence for the Bank - Exchange adjustment parameter.

  4. Close the form.

  5. Click General ledger > Setup > Currency > Currency exchange rates. In the Currency exchange rates form, you can define the exchange rate between two currencies or a currency pair. For more information, see 货币汇率 (窗体) and 汇率类型 (窗体).

  6. Close the form.

  7. Click General ledger > Setup > Ledger. Select the main account in the Unrealized gain and the Unrealized loss fields that the exchange rates are posted for.

  8. Close the form.

  9. Click Cash and bank management > Periodic > Bank > Foreign currency revaluation.

  10. In the On date field, select the revaluation or the adjustment date.

  11. In the From currency and the To currency fields, select the current currency code and the currency to which the adjustment is made.

  12. Click Select to set up the bank account, and then click OK.

  13. In the Foreign currency revaluation form, click OK. The adjustment for the bank account transactions on the selected date is calculated.


    You can view two separate transactions for the accounting currency and the reporting currency in the general ledger. For more information, see 银行交易记录(窗体) and 凭证交易记录 (窗体).

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).