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, ... / Reporting Rates (Histo...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Reporting Rates (Historic Rates) - D365 F&O - how frequently are they to be updated?

(0) ShareShare
ReportReport
Posted on by DianaE 155

Hi Guys, 

We are having some struggles recently with some accounts that need the reporting/historical rate to correctly translate in the Financial Reporter. 

We seem to have not really kept them up to date at all, and the last rate recorded is from last February. 

Are the reporting rates meant to be kept up to date with ALL rates presented in a month i.e from the 1st of the month to the last day of the month regularly? As I understand this, the reporting rates are used to translate a certain account balance as of the transaction date of the transaction, therefore I am guessing the system will need to have ALL rates updated each month until present? 

Any help at all with this will be much appreciated. 

Thanks, 

Diana

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Diana,

    Can you tell if the reporting rates are an exchange rate type in your environment?

    The exchange rates in the system can be updated with an Exchange rate provider or manually. If you want to have it automated, you need to schedule a recurring batch job for the exchange rate provider of your choice.

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees on at

    Hi Diana Elsasser,

    Maintaining daily currency exchange rates is totally choice of your business needs. For example In software subscription business finance always want to maintain daily exchange rate to book customer invoice in foreign currency/transaction currency based on daily forex rate so that they can do the internal financial reporting accordingly. In order to do that, we automate this process by buying some external currency rates provider services that pull the rate at specific time in a day and save the rate on currency exchange rate screen.

    Yes in nutshell, we can update/maintain exchange rates on weekly or at month end but it's totally depend on your finance business requirement so that while creating any foreign currency vendor/customer invoice or payment system can use most recent rate.

    Can you share your business model please?

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

    Hello Diana,

    The exchange rate that is entered last will be applied for all dates after the one for which the exchange rate has been specified.

    If your last exchange rate is from February, all translations in March, April, May, etc. will use this rate, which might probably be wrong.

    What you can try in regards to the MR is first getting your rates right in D365FO as Andre and Junaid suggested.

    Check if the MR currency translation grabs those new rates.

    If the MR does not, test if resetting the datamart helps.

    Best regards,

    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…

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 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans