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

Announcements

News and Announcements icon
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)
  • JessonCoock Profile Picture
    26 on at
    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.
  • Ali Hamza Profile Picture
    170 on at
     
    Sure, I will give it a try and will share the results here. Thanks for your suggestion. 
     
    Thanks
    Regards
    Ali

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Subra Profile Picture

Subra 119

#2
11manish Profile Picture

11manish 89

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 89 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans