web
You’re offline. This is a read only version of the page.
close
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, ... / Currency Exchange Rate
Finance | Project Operations, Human Resources, ...
Answered

Currency Exchange Rate

(0) ShareShare
ReportReport
Posted on by Vignesh R 535

Hi Everyone,

Version - AX 2012 CU 13

I have an issue with Import currency exchange rate in ax. Everyday batch is running to import the currency exchange rate into the system.  

While importing rate, yesterday's currency rate is saving in today's date. 

Provider -- Central Bank of Europe

For e.g: 

1. Date = 10/9/2019 - currency="USD" rate="1.103" -----> Actual data but AX storing data like given below

2. Date = 10/10/2019 - currency="USD" rate="1.103.

What could be the reason for this issue? How to resolve this issue ?

 

When we have checked the same with CU8, there is no issue.

Thanks and Regards,

Vignesh

I have the same question (0)
  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,730 on at

    Hi Vignesh R ,

    You have to check how frequently the batch is set to push exchange rate in ERP and if the batch run date is set properly to fetch exchange rate on daily basis or not.

    Best regards,
    Sourav Dam

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • Vignesh R Profile Picture
    Vignesh R 535 on at

    Hi Sourav,

    If i import the exchange rate using "import currency exchange rate" form without batch, I am getting the same issue. Yesterday's exchange rate is storing in today's date in system.

    Kindly help here.

    Thanks in advance and Regards,

    Vignesh

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,730 on at

    Hi Vignesh R ,

    I believe, you have already selected Today's date in import currency exchange rates form while pulling rates in ERP.

    1018.JPG

    However; can you please check with the developer if the API is responding properly for this action. Also, please check if this is happening for any time zone difference in system or not.

    Else; let's wait for other members in this community to share their input on this.

    Best regards,
    Sourav Dam

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • Vignesh R Profile Picture
    Vignesh R 535 on at

    Hi Sourav,

    Thanks for your input! Yes I am selecting Today's date while importing the exchange rate in ax.

    Meanwhile I will check with developer also. Let wait for others to contribute their input here.

    Thanks in advance and regards,

    Vignesh

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Vignesh,

    I think that you run a bit into a difficult issue for which no good solution other than using a different exchange rate provider is available in my opinion. The problem with the ECB rates is that they are currently published 16:00 every day. Please see: www.ecb.europa.eu/.../index.en.html

    If your import job runs in the morning then you get the 'wrong' old rates from the day before.

    On the other hand side, if you run the import at 16:05 you get the correct rates but orders that have been processed in the morning still got the rates from the previous day.

    This is something I would recommend you discussing with your accounting team to identify what they want to have. If they want to have up to date rates then you need a different exchange rate provider that publishes data earlier than the ECB.

    If they want to have official rates from the ECB then you have to define when and how you run the import job and you might have to accept that orders that are entered in the morning have a 'wrong' rate from the previous date.

    Best regards,  

    Ludwig

  • Vignesh R Profile Picture
    Vignesh R 535 on at

    Hi Ludwig,

    I'm glad to see your suggestion here.

    I will try to update the exchange rate at 16:05 pm in AX ERP and I will check whether the system is taking correct date or not.

    Regards,

    Vignesh

  • Vignesh R Profile Picture
    Vignesh R 535 on at

    Hi Ludwig,

    Daily I am updating the Currency exchange rate around 16:10 PM into system. Still system is updating wrong date into AX. Any suggestion here?

    Thanks and Regards,

    Vignesh

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans