Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Consolidated Cash Flow Reporting with Management Reporter

(0) ShareShare
ReportReport
Posted on by
I have created a cash flow report in management reporter that uses the movement in account categories in the income statement and the balance sheet. This works well for each company.
 
However, when I try to translate that from local currency (e.g. DKK) into USD the translation does not work as I need it to. I expected this but I cannot think of another way to achieve the result I'm after. Where there are balance sheet movements in the cashflow report, management reporter is translating my opening balance sheet @ opening rates and closing balance sheet account @ closing rates leaving my difference to include a large amount of fx (the difference between the opening and closing rates). I need the movement to be translated at the average rate.
 
Is there any way to achieve this in D365 Finance & Operations native consolidation or management reporter? Or do I need to pull the data and use PowerBI or Excel to do it?
 
Thanks in advance for any thoughts?

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans