Announcements
No record found.
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!!
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
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 593 Super User 2026 Season 1
Giorgio Bonacorsi 543
CP04-islander 430