Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Foreign currency revaluation when using Consolidate online

(3) ShareShare
ReportReport
Posted on by 79
Hello,

I am in need of understanding how to work with foreign currency revaluation as it relates to online consolidation. I have been thrust into an organization where the users do not have understanding for the configurations or processes that are in place in the Finance environment since years back (employee turnover+lack of handovers). 


I have an environment where a consolidation LE is set up and a Consolidate online batch job is running once a day. There are transactions from about 30 Legal entities and 20 different currencies being consolidated. The criteria for transactions to consolidate is set up as following:
The currency translation tab has the following is set up, where the exchange rates in "Default" exchange rate type is updated daily.


The organization is not currently running foreign currency revaluations in the respective LEs nor in the consolidation company. I would venture to guess that what they need to do is establish a process for FX revaluation in each LE and this should result in a consolidation where the account balances are correct. But the Microsoft documentation has me questioning if the revaluation that they are referring to is initiated in the originial LE or if it is run via the consolidation company. 

What is the recommended process here? And if the daily consolidation company imports transactions from another accounting currency but it "translates" it using the daily exchange rate type does that not mean that the consolidated balances are correct?

Thanks in advance,
Oskar
Categories:
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 17,153 Most Valuable Professional on at
    Foreign currency revaluation when using Consolidate online
    In the documentatıon, ıt ıs saıd to run reval for the consolıdatıon company as well.
    Please check the lınk below.
     
     
     
  • ON-16052045-0 Profile Picture
    ON-16052045-0 79 on at
    Foreign currency revaluation when using Consolidate online
    Commenting for visibility
  • ON-16052045-0 Profile Picture
    ON-16052045-0 79 on at
    Foreign currency revaluation in when Consolidating online
    .Gaurangkumar Jani thank you for this insight but I am not sure I quite understand your answer.

    I don't understand "if you are doing daily consolidation for the same period (without changing a date)" What is the difference between your first scenario in which we have to do currency conversion onperiodic basis in consolidation vs. not needing to do so? 

    If we do monthly currency revaluation in the source legal entity and if we need to report on a monthly basis, do we need to do any sort of revaluation in consolidation LE or will it be updated with the correct transaction information? 
  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,511 User Group Leader on at
    Foreign currency revaluation in when Consolidating online
    Hi there,
     
    In D365 Finance, If you are doing daily transaction transfer from mail LE to Consolidation, you have to do currency conversation on periodic basis in Consolidation,
    BUT, if you are doing daily consolidation for the same period (without changing a date) you don't need to do it for running period as your source data is already updated, but still you may have to do it for balance sheet item if it's not revalued in source legal entity.
     
    Please let us know if this helps.
     
    Thanks,
    CA Gaurangkumar Jani

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans