Skip to main content

Notifications

Announcements

Community blog subscriptions are now enabled!

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Consolidation - Balanc...
Finance forum
Suggested answer

Consolidation - Balance sheet report Quarter end exchange rate

(1) ShareShare
ReportReport
Posted on by Hossam Z. EL Hassan 242
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?
Categories:
Financial Management
  • Hossam Z. EL Hassan Profile Picture
    Hossam Z. EL Hassan 242 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... 3,638 Super User 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 242 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... 3,638 Super User on at
    Consolidation - Balance sheet report Quarter end exchange rate
    Have you considered a quarterly FX revaluation of your reporting currency?  

Helpful resources

News and Announcements

Community blog subscriptions are now enabled!

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,907 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,189 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans