Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Unexpected Gains/Losse...
Finance forum
Unanswered

Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity

Posted on by 52

We use a consolidation entity to consolidate legal entities into one. For balance sheet accounts, we use the end of month rate, and for P&L accounts, we use the average month rate. After running the consolidation, we run the foreign currency revaluation for balance sheet accounts. We wouldn't expect any gains/losses since the transactions should already be translated with the "correct" rate. However, we still encounter quite a few gain/loss transactions after running the foreign currency revaluation.

Could anyone advise why this is happening?

 
Categories:
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,722 Super User on at
    Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity
    I've never run into this scenario before as all the clients I've worked with use the same reporting currency in all companies.  What if you just don't run revaluation in the Consolidation company?  Apart from that, I'd open a MSFT ticket to ask them to explain the logic at play in this scenario.  Could be a bug.
  • MS-29042149-0 Profile Picture
    MS-29042149-0 52 on at
    Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity
    Hi Frank, in the consolidation company the reporting currency is AUD.
     
    The four legal entities that we are consolidating to the consolidation company have the below reporting currencies:
     
    AUD
    NZD
    AUD
    JPN
     
    During consolidation we have it setup for balance sheet accounts to use the consolidation close exchange rate type. For Foreign Currency Revaluation we have it setup to use the last date of the month exchange rate which should be the same as the consolidation close exchange rate. When we run consolidation, we don't expect any transactions in the Foreign Currency Revaluation, but there appear to be unrealized gain/losses even though consolidation and foreign currency revaluation uses the same rates
     
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,722 Super User on at
    Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity
    You have transactions in your consolidation company in other than reporting currency?  Do you have different reporting currencies setup in your operating companies?  Theoretically, reporting currency should be the same in your operating (child) companies so you can consolidate the results to one currency.
  • MS-29042149-0 Profile Picture
    MS-29042149-0 52 on at
    Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity
    Hi Frank,
     
    This was the process we have been doing for a while. We would have thought during consolidation it would pull through the transactions and calculate them at the correct exchange rate which is setup. But, we noticed only after we run FX Revaluation in the consolidation company, this is when the balances are updated to the correct values.
     
    If we run FX revaluation right after we consolidate the transactions, we would expect there to be no results but there are transactions that get revalued.
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,722 Super User on at
    Unexpected Gains/Losses After running Foreign Currency Revaluation in Consolidation entity
    Why are you running FX Reval in the consolidation company?  Wouldn't you do this at the operating companies and just let the transactions roll up to the consolidation company?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans