Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / YTD Average Rate for R...
Finance | Project Operations, Human Resources, ...
Suggested answer

YTD Average Rate for Reports generated in Management Reporter

(0) ShareShare
ReportReport
Posted on by Jennifer 30

Dear Expert,

I am running a consolidated report from MR and have chosen average as the currency translation type for the main accounts in the report.

I was expecting that the exchange rate used in consolidation was calculated by YTD total of exchange rates / numbers of exchange rates. And the total YTD value was calculated by this rate * Total Value of the Transaction Currency

However, it turned out that the YTD value was calculated by adding up the value of each month. Monthly value was calculated by monthly average rate * Monthly Value in Transaction currency.

Here is the current set up in AX and MR.

Can anyone please let me know how can I set up to use the YTD average rate, i.e. YTD total of exchange rates / numbers of exchange rates for the auto consolidation? I am in Microsoft AX not GP by the way.

Thanks Heaps !!!

pastedimage1627018684272v1.pngpastedimage1627018723275v2.png

  • Jennifer Profile Picture
    Jennifer 30 on at
    RE: YTD Average Rate for Reports generated in Management Reporter

    Hi Ludwig,

    Thanks very much for your reply.

    We have been trying to figure out a workaround. 

    Will share it when it's sorted.

    Cheers

    Jennifer 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: YTD Average Rate for Reports generated in Management Reporter

    Hello Jennifer,

    If you really need a different / additional translation technique then feel free to let MS know about it.

    On top of this site we have an ideas site that allows you suggesting missing functionalities in D365 to the MS product team.

    If you get sufficient votes from community members then it will be likely that we get this feature in the standard application.

    Best regards,

    Ludwig

  • Jennifer Profile Picture
    Jennifer 30 on at
    RE: YTD Average Rate for Reports generated in Management Reporter

    Hi Ludwig,

    Thanks very much for your comments. I‘ve set up the rate and translation type in AX as per detailed in the site you shared.

    As our company have been using YTD average rate for consolidation ( involves much manual work), we are aiming to automate this process and thought MR would be an idea tool to achieve this.

    Anyway, thanks for you coming back to me.

    Thanks

    Jennifer

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: YTD Average Rate for Reports generated in Management Reporter

    Hi Jennifer,

    Please have a look at the following site, which details the different translation types

    cloudblogs.microsoft.com/.../

    What you are asking for is not supported but I would like to ask whether it makes a big difference using a YTD average rate compared to using an average rate on a period-to-period basis?

    Best regards,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,009 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans