Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Exchange rates in AX

Posted on by Microsoft Employee

Hi Everybody,

I am new to AX and struggling to extract exchange rates wrt the sales order creation date. I am actually trying to convert line amount in transaction currency to GBP.

Please help.

I am working AX 2012 R3

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Exchange rates in AX

    Hi Anusha 15,

    If you have quarterly exchange rates available then your SO should automatically take the exchange rate from the exchange rate table.

    Does this not work?

    Can you share an example with some screenprints?

    Many thanks,

    Ludwig

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 18,463 Super User on at
    RE: Exchange rates in AX

    Hi,

    Not sure if I understood it correctly.

    You want to extract the exchange rates for the Quarter? if this is the case, you can use the  Data management framework and export from there by using the "Exchange rate currency pair" and "exchange rates"

    or if I am missing something?

    If so, you may share one example.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exchange rates in AX

    Thank you both.

    I have exchange rates set up for every quarter. I only want to extract the data for that particular quarter  the SO creation date falls into.

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 18,463 Super User on at
    RE: Exchange rates in AX

    For SO creation date, system will look for the date of SO date and if not setup for the same date, it will look for the latest exchange date for the pair.

    You can refer the document which was shared by Dr. Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Exchange rates in AX

    Hi Anusha,

    If you import the exchange rates on a daily basis then you can achieve what you are looking for.

    There are standard exchange rate providers available in AX2012 that you can use for importing exchange rates (Ex: ECB).

    If those exchange rate providers don't provide all currency pairs you are looking for then a new exchange rate provider needs to be created (developed).

    This creation is described here in this MS whitepaper: docs.microsoft.com/.../creating-exchange-rate-providers-for-microsoft-dynamics-ax-2012

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exchange rates in AX

    Hey,

    I have exchange rates set up already. I want to extract exchange rates valid during SO creation date.

    Thanks,

    Anusha

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 18,463 Super User on at
    RE: Exchange rates in AX

    Hi,

    We can help.

    What exactly you are facing the issue with?

    Are you trying to import exchange rate? or you already have exchange rates setup?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans