Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Consolidation - Balanc...
Finance | Project Operations, Human Resources, ...
Suggested answer

Consolidation - Balance sheet report Quarter end exchange rate

(1) ShareShare
ReportReport
Posted on by Hossam Z. EL Hassan 12
Hi,
 
Need your guidance on generating a Dynamics 365 Finance & Operations Consolidation balance sheet report for quarter end exchange rate.
 
Example. Jan, Fab, March balance sheet transactions are loaded at month end exchange rate every month. 
 
For the quarter report, we need to calculate the exchange rate at March end exchange rate for this example.
 
Is there a specific configuration required for the Management Reporter?
  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 12 on at
    Consolidation - Balance sheet report Quarter end exchange rate
    Hi Frank,
     
    Thanks a lot for the details. Unfortunately, the foreign currency revaluation didn't return any results. 0 records.
     
    Will open a ticket with Microsoft in the mean time, while waiting for other ideas.
     
     
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,215 Super User 2024 Season 2 on at
    Consolidation - Balance sheet report Quarter end exchange rate
    Surely.  Create a Revaluation with parameters similar to below.  This will revalue Reporting currency for your quarter transactions to the end of quarter rate.
     
    1. Beginning and ending quarter dates
    2. Date of rate for revaluation (should be spot rate on last day of quarter)
    3. Currency to revalue would be your Reporting currency
    4. I always like to preview the journal before posting it
    5. Whether you select to revalue Reporting currency adjustments is your preference
     
     
    In your Main account setup, make sure that under Currency translation, the Financial reporting exchange rate is set to the same rate as Reporting currency in Ledger setup and Currency translation type = Current.  
     
     
    In theory, this should work.  Let us know if it produces the desired results.
  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 12 on at
    Consolidation - Balance sheet report Quarter end exchange rate
    Hi Frank,
     
    Would love to try the quarterly FX revaluation of your reporting currency solution.
     
    Would you be able to provide me with steps please.
     
    Thanks,
    Hossam
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,215 Super User 2024 Season 2 on at
    Consolidation - Balance sheet report Quarter end exchange rate
    Have you considered a quarterly FX revaluation of your reporting currency?  

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans