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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Dual-Write Update of currency in F&O order not reflecting in D365 Sales order, lines

(3) ShareShare
ReportReport
Posted on by 170
Subject: Dual-Write Currency syncing issues between F&O Sales order, lines & Dynamics 365 Sales order, lines: Update of currency in F&O order not reflecting in D365 Sales order, lines
 
Hi Guys,
 
Need your help. I have a requirement that when sales order is created in F&O and lines are added. It successfully sync b/w F&O and D365 sales. The currency is also mapped correctly. However when I change currency in F&O header (through F&O sales order form). Currency changes in F&O but in D365 sales (/ Dataverse) it don't change and nothing happen in sales. However if other fields (added in dual-write mapping) changed in F&O it reflects back in dynamics sales. 
 
Please advise which tables are necessary to accomplish above. Also I am wondering are there any other fields in F&O order and lines which need to be added in dual-write mapping to achieve above. We are mostly using default mapping of Dual-write for SO and SO lines tables. Currency field is there in mapping.
 
Note: We have synced the currency table. We haven't sync any other currency table like exchange rate etc.
 
Please provide help, highly appreciated.
 
Thanks
 
Ali
Categories:
I have the same question (0)
  • Ali Hamza Profile Picture
    170 on at
    Dual-Write Update of currency in F&O order not reflecting in D365 Sales order, lines
     
    Sure, I will give it a try and will share the results here. Thanks for your suggestion. 
     
    Thanks
    Regards
    Ali
  • JessonCoock Profile Picture
    26 on at
    Dual-Write Update of currency in F&O order not reflecting in D365 Sales order, lines
    Check if the Currency Code field in both F&O and D365 Sales (Dataverse) is properly mapped in Dual-Write. Ensure that the related Currency Exchange Rate table is also synced, as it might be needed for correct currency updates.

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
DAnny3211 Profile Picture

DAnny3211 433

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 137 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 67 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans