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

Trying to limit dual write sync to CRM unsuccessfully

(0) ShareShare
ReportReport
Posted on by 16

We have enabled dual write sync between F&O and CRM. For the sales orders, we use a table map CDS Sales Order Header < - > Order. Currently, we are planning on enabling the Intercompany feature, and came across one issue when confirming an sales quotation and converting it into an sales order.

Namely, if it is a IC sales order, then both the sales order and the intercompany order are getting synced to CRM from F&O, which is not our use case (we need only the sales order). 

We have extended the mapping in Dual write with the IntercompanyOrder field from the SalesTable (NoYes enum), and added it in the query as: INTERCOPMANYORDER == NoYes::No , but this still havent prevented the sync of the IC orders. I can see that the field is correctly mapped in the table map (it is synced correctly from F&O), but the query doesn't really work, at least not On Create.

Is there any way to do this through Dual write at all? It would really reduce the amount of unnecessary data being synced. 

Thanks

Categories:
I have the same question (0)

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 Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
11manish Profile Picture

11manish 58 Super User 2026 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 48 Super User 2026 Season 2

#3
Subra Profile Picture

Subra 42 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans