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)
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) .
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.
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.
Thanks
Yash
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.
Yes correct. It's a product limitation; that's why I submitted an idea to Microsoft.
Please check :- experience.dynamics.com/.../
Thanks
Yash
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.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156