Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by D365 Talent

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)

All responses (6)

Answers (0)

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
D365 Talent 25 on at

Like (1)

Report
Copy link

Link copied!

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

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

Thanks

Yash

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,403 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
D365 Talent 25 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
André Arnaud de Cal... 303,403 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report
Copy link

Link copied!

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) .

Was this reply helpful? Yes No