Finance | Project Operations, Human Resources, ...

Dual write - Cross company or company specific entities issue with Customer groups

(1) Share

Report

Posted on by AvinashVarmag

Hi team,

I am trying to setup Dual write in Tier 2 environment on a customer's sandbox instance.

After enabling the dual write and mapping few tables, when trying to run the table mappings on Customer groups (msdyn_customergroups), I am seeing below error with the initial sync from F&O to Dataverse.

Project validation failed. [DIPV1002] Customer groups or AX is a cross-company entity that doesn't have primary company field set and msdyn_customergroups of CRM is a company-specific entity with primaryCompanyField set to msdyn_company.cdm_companycode. Please make sure the entities are both cross-company or company-specific entities.

Customer groups is a default group and dual write should allow you to run the sync. Can any one help me with your insights and a fix to this?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (1)

Report

Hi Avinash, Check if this old thread helps.

https://community.dynamics.com/forums/thread/details/?threadid=90a80306-ce54-4412-b473-b1c466da947b

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

Hello,

You wanna confirm to us that you have already pushed your companies(legal entities) to CE; alongside the payment terms.

Make sure you do those and try to push the customer group again.

Was this reply helpful? Yes No
AvinashVarmag 2 on at

Like (0)

Report

Hello @komi siabi,

I have a dual write mapping in running state which does push companies onto CE.

Legal entities (cdm_companies)

Still the customer groups doesnt run with the initial sync.

Was this reply helpful? Yes No
Suggested answer

Community member on at

Like (0)

Report

Hi,

Ensure that you have legal entities - companies table map running and is initial sync is also performed.

Hope this helps!

Regards,

Gagan | https://mscrmnovice.blogspot.com/

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

Hi Avinash,

Do you have cross-company data sharing enabled for this or a related table? If so, Dual Write and Cross company data sharing are not supported together. This is mentioned in the documentation.

Was this reply helpful? Yes No
Suggested answer

RK800-1 13 on at

Like (0)

Report

I figured it out yesterday. Firstly I recommend you to run a dual-write with a cdm_company (I hope you have this in your dual-write list, I had it - Picture 1). Then you should go to your table you want to sync in PowerApps and create a row with a "Lookup" data type and link it with the Company table (Picture 2). The final step is to define this row in integration keys (Picture 3).

I hope this helps. I spent a day trying to resolve the same problem and it helped me.

Was this reply helpful? Yes No