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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Settlement in different currency

(0) ShareShare
ReportReport
Posted on by 232

Hi All, 

I would like to ask your support to understand settlement exchange rate used when different currency are involved and accounting currency is different.

I have the following situation

EUR invoice 150€ accounting USD --> 120$ at 0.8ER

GBP settlement 100£ accounting USD--> 120$ at 1.2ER

When settle the transaction the system fill on the invoice a value for the adjustment exchange rate (25.864 in USD) and the settle amount is 117.67 in EUR.

Amount settled in EUR 117.67
Amount in GBP 100
Exchange rate used 0.849834282

The Vendor balance is 0 but the vendor transaction is stil open for 

Amount not settled in EUR 32.33
Amount not settle in USD 25.864

My understanding is that the system settle the transaction using GBP against EUR and the remaining EUR amount represents the not settled amount due to the 100GBP conrsion in EUR.

Am I right?

Where the ER 0.8498... used to convert the GBP EUR comes from? it is not present in the ER rate saved in the system.

Should the system close the transaction on the vendor since the USD amounts were completely settled?

thank you

I have the same question (0)
  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,703 Most Valuable Professional on at

    Hi,

    It is not neccesarily close these two transactions while there can be revaluation them etc.

    But if you would like to settle these transactions together, you may fill the settlement conversion rate.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,703 Most Valuable Professional on at

    learn.microsoft.com/.../specify-the-cross-rate

  • Fabio C. Profile Picture
    232 on at

    Thank you Billur,

    what I would like to understand is the way the system handle this settlement. The system direct settles transaction using a direct exchange rate GBP EUR or it converts the amount first in USD?

    During the settlement in GBP it converts GBP in EUR at which exchange rate?

    regards

  • Fabio C. Profile Picture
    232 on at

    As far as I undesrtood the system calculate the gain/loss using the ER stored in the system if the user settles the transactions using the Settle Transaction functionality, am I right? how the open transaction on the vendor is calculated?

  • Fabio C. Profile Picture
    232 on at

    Any support on this topic?

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…

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

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans