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

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dual Write Data Synch ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Dual Write Data Synch From FO to Dataverse With Cross company data sharing policy

(0) ShareShare
ReportReport
Posted on by D365 Talent 25

All,

I have set up cross-company data sharing for the D365 FO customer master.

With this cross-company data sharing configuration, I'm copying the identical data into three legal entities.

In addition, Dual Write has been enabled for customer master synch from FO to Dataverse.

Data synchronization for such cross-company enabled tables is not possible with dual write.

How can we synch data from FO to Dataverse? 

I raised Microsoft Ticket, they said this is limitation of Dual Writ by Design. 

Please help me with this issue. 

Thank You In Advance....

Yash (Dynatech Systems Pvt. Ltd) 

I have the same question (0)
  • Mohit Rampal Profile Picture
    Mohit Rampal 12,565 Moderator on at

    Hi Yash, Yes it's a limitation and was discussed in below thread

    community.dynamics.com/.../d365-to-cds-dual-write-limitation

    For cross company tables, I think system will throw error related to copying pre existing data.

  • D365 Talent Profile Picture
    D365 Talent 25 on at

    Yes correct. It's a product limitation; that's why I submitted an idea to Microsoft.

    Please check :- experience.dynamics.com/.../

    Thanks

    Yash

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,704 Super User 2026 Season 1 on at

    Hi Yash,

    The limitation about not having dual write and cross company data sharing is documented by Microsoft here: Cross-company data sharing overview - Finance & Operations | Dynamics 365 | Microsoft Learn

    There are technical restrictions to make this working. Cross company data sharing is managed on SQL server level. Dual write is on the Dynamics 365 application ensuring updating 2 databases within one transaction scope. The dual write framework is not aware of any action running in the background on the SQL server. 

  • D365 Talent Profile Picture
    D365 Talent 25 on at

    Hey Andre,

    Greetings..!!

    I raised MS ticket to get it resolved.

    Is there any technical physbility to get this resolved?

    Microsoft Idea: - I submitted this. Please provide your Vote.

    experience.dynamics.com/.../

    Thanks

    Yash

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,704 Super User 2026 Season 1 on at

    Hi Yash,

    We investigated for some time to understand why dual write and cross-company data sharing do not support each other. I think Microsoft is aware of it but will for now treat this as per design. Of course, it would be great if it would work together. I'm not sure about the plans. There are other integration options to achieve your requirement today.

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    Fundamentally the two systems have different architecture, when you initialise Dual Write it brings to the Dataverse the concept of the company binding, this is to enable the systems to integrate. The limitation with Dual Write is that data elements like the Account/Customer relationship are company driven, they do not have the ability or technology to switch.

    The limitation as has been stated is well documented, your option is not not use an integration that is not compatible. Simply put to get the integration to work dont use Dual Write.

    You could wait for your idea to be picked up, but I doubt it will in the next few years (if ever if I am honest) .

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

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

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 280 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 201 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans