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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Foreign Exchange - D365 Calculation

(0) ShareShare
ReportReport
Posted on by 90

hi team

In need of some advice.

I am struggling to understand how the FX gain sale/loss is being calculated by the system. Is there some report that I can extract that can show me the breakdown of how the $785.92 has been generated? 

Thank you!!

pastedimage1627967434185v1.png

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,055 Moderator on at

    Hi,

    There is no report which we have for this.

    1. You can go to Forex revaluation run and check the transactions which got impacted

    2. You can run vendor transactions and filter on transaction type as Forex

    Calculation on revaluation is basically for all open transactions.

    So, lets say you have 100 USD with forex 110 EUR with exchange rate 1.1

    now, if you revaluate at the month end with rate 1.2 , system will post .1*100 = 10 as impact

  • Suggested answer
    MU-25040629-0 Profile Picture
    Microsoft Employee on at

    Dear Sir or Madam,

    Thank you for posting this issue to our community.

    I will give an example of DEMF legal entity which has accounting currency=EUR, reporting=transaction currency=USD. If you post an USD invoice on 1st of August and then post a payment on 3rd of August to settle the invoice created on 1st of August and there was an exchange rate difference between 1st and 3rd of August then an adjustment entry is created as a loss or gain depending on how the rate fluctuated. I am not aware of a breakdown option to see how the calculation occurred as this is an accurate operation, I have not experienced where a calculation was incorrect.

    Can you please provide the similar details of your transaction so that we can clear your doubts about the incorrect calculation?

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 April Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 593 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 543

#3
CP04-islander Profile Picture

CP04-islander 430

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans