MSDyn365FO: Foreign currency revaluation (General ledger and Accounts payable)

Want to understand foreign currency revaluation in Microsoft Dynamics 365 for Finance and Operations? Here are some cases that are sure to help.

Imagine the following situation:

We have the vendor invoice in the foreign currency, let’s say in USD. Reporting/accounting currency is EUR

INV#1: USD 6,492.30

Fx rate with which the invoice was originally posted is 73.000 (100 USD = 73 EUR)

As the result we have:

1. open amount in transaction currency is USD 6,492.30
2. non fx-valued EUR amount is EUR 4,739.38 (6,492.30*73/100)

In order to keep an updated record of the value of all open transactions in your accounting currency, at the end of each accounting period, your company will run Foreign currency revaluation process in AX.

What the system will do: the value of all open transactions (in our case it’s USD 6.492,30) will be translated into the accounting currency using the current spot exchange rate (let’s say 79 exchange rate).

Foreign currency revaluation (FX revaluation) result will be directly booked on the transaction and will be a part of AR/AP balance.

So, we have the invoice posted on January 28

Below you may find the Vendor transaction record:

Voucher of the vendor transaction:

Let’s make sure that setup is corresponding to the example above.

The currency exchange rate that will be used upon revaluation is 79.

Accounts that will be used for the currency revaluation can be found in the General ledger > Ledger setup > Ledger:

• Unrealized gain
• Unrealized loss

Account balances in foreign currencies can be revalued in General ledger module. As the result, all accounts that are marked as Foreign currency revaluation will be included into this process.

Also, this process needs to be run in the Accounts payable and Accounts receivable separately to revalue the outstanding AR / AP transactions.

To run Foreign currency revaluation in the General ledger, follow the steps below:

Go to General ledger > Periodic tasks > Foreign currency revaluation > Foreign currency revaluation

Accounting entry will consist of the main account being revalued and unrealized gain or loss.

Highlight the completed Foreign currency revaluation task.

Click Voucher transactions button.

To run Foreign currency revaluation in the Accounts payable, follow the steps below:

Go to Accounts payable > Periodic tasks > Foreign currency revaluation > Foreign currency revaluation

Within this process, each accounts payable transaction will be revalued.

The result will be the next:

If you check Vendor transactions, you will notice that additional transaction is being created for the delta between the balance of the main account and the new value based on the exchange rate for the Date of Rate.

Vendor balance will be affected as well.

Let’s imagine that this transaction was revaluated again in the next period. For this scenario, the exchange rate was slightly dropped off.

We would expect to have 259.69 posted as an unrealized gain.

Now, you will notice the difference between General ledger foreign currency revaluation process and Accounts payable.

For the Account payable process, the system will completely reverse the previous revaluation and will create the transaction for the delta between the balance of the main account and the new value based on the exchange rate for the Date of Rate: 4,739.38 – 4,869.23 = 129.85

For the General ledger process, the system will not reverse the previous revaluation and will create the transaction for the delta between the balance of the main account, including any previous revaluation amounts, and the new value based on the exchange rate for the Date of Rate: 4,869.23 – 5,128.92 = 259.69

GL foreign currency revaluation result:

AP foreign currency revaluation result:

Vendor transactions:

Vendor balance:

That’s it!