web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Calculate spot rate (CTA) in Management Reporter.

(0) ShareShare
ReportReport
Posted on by 2,438

Hi,

Does anyone know how to configure the spot rate calculation in Management Reporter? Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Calculate spot rate (CTA) in Management Reporter.

    Hello Kim,

    The rate conversion is done through a setup at the ledger account level in GL

    Please have a look at the following screen-print and probably this site: blogs.msdn.microsoft.com/.../currency-translation

    6663.mr.png

    Hope this helps,

    Ludwig

  • lmai Profile Picture
    2,438 on at
    RE: Calculate spot rate (CTA) in Management Reporter.

    Hi Ludwig,

    During the month, I posted transactions.  The exchange rates are determine by the rate I pulled from Oanda.  So the transaction on that date is affected by the currency exchange rate for that day.  At the end of the month, I use average rate.  So how do I configure in MR to flip from daily rate to Average for every transactions made that involved 2 currencies? I'd like to focus on Income Statement to do this spot rate calculation.  Thanks for

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Calculate spot rate (CTA) in Management Reporter.

    Hello Kim,

    What you you mean by spot rate calculation in Management Reporter? Is it that you want to have your financial statements evaluated at a certain exchange rate on a specific date? Would be great if you could provide us more information on the requirement and the expected result.

    Many thanks,

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans