Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Invoiced sales order e...
Finance | Project Operations, Human Resources, ...
Suggested answer

Invoiced sales order exchange rate update

(1) ShareShare
ReportReport
Posted on by Mustafa Quraitem 41
 
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  
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2024 Season 2 on at
    Invoiced sales order exchange rate update
    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.
     
     
     
     
     
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,811 Most Valuable Professional on at
    Invoiced sales order exchange rate update
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,215 Super User 2024 Season 2 on at
    Invoiced sales order exchange rate update
    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
    Bharath jain Profile Picture
    Bharath jain 848 on at
    Invoiced sales order exchange rate update
    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

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans