This article describes how the average exchange rate is determined in Multicurrency in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains. This article also describes how the average exchange rate affects the realized gains and the realized losses in a revaluation report.
How the average exchange rate is determinedThe average exchange rate is determined by the setup of the account that you are revaluing. To set up the account, follow these steps:
- On the Cards menu, point to Financial, and then click Account Currencies.
- In the Account list, click the account that you want to revalue.
- Click to select the Revalue Account check box.
- Use the appropriate method:
- In the Select Account Currencies window, click Period Balances.
- In the Select Account Currencies window, click Net Change.
- In the Select column, click to select the check box for the currency ID that you want to use.
- Click Save.
If you decide to calculate the revaluation by using the net change, the period balance of the period that you want to revalue is subtracted from the period balance of the prior period. Then, the average exchange rate is calculated. The result is a true-weighted average.
The average exchange rate is compared to the revaluation rate to determine whether a difference exists in the exchange rate. The average exchange rate is also used to print the exchange rate in a revaluation report or in a revaluation journal.
How the average exchange rate affects the realized gains and the realized losses in a revaluation reportA revaluation report contains two exchange rates. These exchange rates include the exchange rate that was entered for the revaluation and the average exchange rate that was calculated by the system. (The average exchange rate depends on the period balances or on the net change, as explained earlier.)
A revaluation report displays the realized gain or the realized loss for the account that you want to revalue. The exchange rates determine how Microsoft Dynamics GP determines this number. The following is a sample calculation:
- (Originating amount) × (average exchange rate) = functional amount 1
(Originating amount) × (exchange rate) = functional amount 2
- Functional amount 1 - functional amount 2 = realized gain or realized loss