Finance | Project Operations, Human Resources, ...

Invoiced sales order exchange rate update

(1) Share

Report

Posted on by Mustafa Quraitem

112

Hi,

Our sales team created & posted a "foreign currency" sales order with a particular rate (System rate), then we received the money in our local currency with a diff. rate!

Let's say the sales order amount is USD 100,000 / system rate is 0.305 then revenue credited with KWD 30,500 / then we received from the customer amount of KWD 30,600

Is there any method to update the rate for the INVOICED Sales order to be matched with received money?

Note;

Creating the SO with the foreign currency was as per customer requirement despite he is a local customer!

Rgds

Mostafa

All responses (4)

Answers (0)

Sort by

Suggested answer

Bharath jain 1,633 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Mostafa,

Once it’s invoiced, you will not be able to make changes.
As an alternative, you can run the FCR for that customer with the new exchange rate, which will increase the receivable from 30,500 to 30,600 due to a foreign exchange gain. You can then adjust the customer payment to 30,600.

Regards,

Bharath Jain
Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

It's not possible to edit a posted sales invoice. In addition to Bharath's suggestion, another option would be to settle the invoice with the payment and charge off the overage to Realized Gain/Loss on exchange rate difference.
Suggested answer

BillurSamdancioglu 21,481 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please check this functionality.

https://learn.microsoft.com/en-us/dynamics365/finance/accounts-payable/specify-cross-rate
Suggested answer

saurabh bharti 15,059 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think this should be a process for you rather than changing the invoice amount to match with payment because it will happen again in future for you when you have foreign currency invoice.

Better way is to utilize D365 standard feature for this which calculates currency realise/unrealise loss or gain for such transactions.

https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/foreign-currency-revaluation-accounts-payable-accounts-receivable