In this post, I am going to explain the MultiCurrency Revaluation feature in GP. This is used to calculate the Realized and Unrealized gain/loss based exchange rates
Setup accounts for the Realized and Unrealized Gain/Loss:
1. Turn on the revalue for the accounts
2. Enter the posting accounts for Realized and Unrealized gain/loss
1. Revaluation option must turned on for accounts which you want to revalue.
Open Cards >> Financial >> Account Currencies
Check on Revalue account and currencies and save changes
In above window, you can turn on revalue account for one account at a time.
To mass update accounts use Multicurrency Mass Account Update window from Cards >> Financial >> Currency Account Update
Restrict the accounts by inserting the segment values
Check on the Update currencies and update Revalue Option
Click update to Update accounts
2. Enter the posting accounts for Realized and Unrealized Gain/Loss
Open Microsoft Dynamics GP menu >> Tools >> Setup >> Posting >> Posting Accounts window
Enter the default accounts for revaluation
These account will be used for revaluation of all currencies.
If you want to setup different accounts for different currencies use Multicurrency Posting Account Setup window from Microsoft Dynamics GP menu >> Tools >> Setup >> Financial >> Currency Accounts.
Select the currency and enter the accounts
Revalue currency values:
Open Multicurrency Revaluation window from Microsoft Dynamics GP menu >> Tools >> Routines >> Financial >> Revaluation
Enter the Revalue Option.
Select whether you want to post transaction or view report only
Select Realized or Unrealized.
Mark Unrealized to calculate unrealized gains/losses during revaluation. You will have the option to reverse the posting.
Mark Realized to calculate realized gains/losses during revaluation. You will not have the option to reverse the posting.
Depending upon the option selected, Reversing date field is enabled or disabled
Select the currency and enter the exchange rate
You can restrict the accounts for which you want to revalue restrictions Button
Click Revalue to view the report or post the Transaction
How these values are calculated:
Lets consider account 000-1200-00.
We have run revaluation for Canadian Dollar for April 2017
Get all the transactions entered in this month for Canadian dollar
Note the total amount is C$ 519
Get the this amount in Functional currency
|Originating amount(C$)||Exchange rate||Functional Amount($)
Originating Amt * Exchange Rate
|Total||519.18||=(0.689905793+2)/2(Average Exchange rate)
|After Revaluation||519.18||1.23444(Exchange rate we entered for revaluation)||=519.18*1.23444
Revaluation is the process of recalculating the functional currency value of transactions that were recorded in a currency other than your functional currency, or of recalculating the functional currency balances for accounts that are held in a currency other than the functional currency, based on a specific exchange rate.
You can indicate whether you want to calculate unrealized gains and losses or realized gains and losses during revaluation. If you select to calculate unrealized gains and losses, you will have the option to reverse the posting. If you select to calculate realized gains and losses, you will not have the option to reverse the posting.
Unrealized gains and losses
An unrealized gain or loss can be calculated for a transaction that hasn’t been settled. The unrealized gain or loss is the amount that would be posted as a realized gain or loss if the transaction was settled at the exchange rate on the date of the revaluation. When accounts held in a currency other than your functional currency are revalued, the account’s balance is calculated as if you were to convert the account’s balance to your functional currency on the revaluation date, and an unrealized gain or loss is posted. You should revalue accounts and post transactions for unrealized gains and losses so your financial statements reflect your company’s current financial position.
Realized gains and losses
A realized gain or loss can be calculated for a transaction when applying documents in Receivables Management and Payables Management. A realized gain or loss from revaluation can occur when you revalue accounts or transactions in the Multicurrency Revaluation window. The exchange rate for the transaction date is compared to the exchange rate for the date the transaction was settled and a realized gain or loss for the change in the exchange rate is posted to a realized gain or loss account.
A realized gain or loss from applying documents is the difference in the functional currency values of an originating currency payment when compared to the original transaction or invoice in the same originating currency that it’s being applied to.