Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Foreign currency revaluation in when Consolidating online

(2) ShareShare
ReportReport
Posted on by 44
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
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,501 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,575 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans