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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Currency exchange Rate...
Small and medium business | Business Central, N...
Answered

Currency exchange Rates from Floatrates.com

(2) ShareShare
ReportReport
Posted on by Bob Callanan 789
We've noticed the daily Exchange Rate service from FloatRates does not give us rates on the weekends and holidays. This doesn't present a problem for day-today transactions as BC will always use the prior day rate. However, when we build Month end financial reports using Jet Reports or Power BI, we can't get a month-end rate if the last day of the month is on a weekend. Has anyone encountered this before and have a good work-around?
I have the same question (0)
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 89,974 Super User 2025 Season 2 on at
    Currency exchange Rates from Floatrates.com
    Although it is not a perfect solution, you can customize a codeunit and set it in the job queue. If the day is a holiday, let the system automatically create the same exchange rate as the previous day.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 2,349 Super User 2025 Season 2 on at
    Currency exchange Rates from Floatrates.com
    Hello Bob,
     
    This is because you filter the exchange rate table on the reporting tool with the month-end date and no record was found in BC.
     
    You could try filtering the exchange rate table with the current month and find last record instead.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,359 Super User 2025 Season 2 on at
    Currency exchange Rates from Floatrates.com
    That's pretty common with all exchange rate services. You would simply use the exchange rate on the last working day of the month i.e. for August 2024 you would use August 30 rather than 31.
     

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

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…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,737 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,577

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,251

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans