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

Announcements

No record found.

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)
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,214 Super User 2026 Season 1 on at
    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.
     
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 2,647 Super User 2026 Season 1 on at
    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.
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 99,090 Super User 2026 Season 1 on at
    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,949 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,064 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 559 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans