Consolidated Cash Flow Reporting with Management Reporter

(0) Share

Report

Posted on by AW-27040946-0

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?