Skip to main content

Notifications

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

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Dual Write Data Synch From FO to Dataverse With Cross company data sharing policy

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,996 Super User 2025 Season 1 on at
    RE: Dual Write Data Synch From FO to Dataverse With Cross company data sharing policy

    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.

  • D365 Talent Profile Picture
    D365 Talent 25 on at
    RE: Dual Write Data Synch From FO to Dataverse With Cross company data sharing policy

    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

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,996 Super User 2025 Season 1 on at
    RE: Dual Write Data Synch From FO to Dataverse With Cross company data sharing policy

    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
    RE: Dual Write Data Synch From FO to Dataverse With Cross company data sharing policy

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

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

    Thanks

    Yash

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Dual Write Data Synch From FO to Dataverse With Cross company data sharing policy

    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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans