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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dual-write: company-sp...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Dual-write: company-specific entity with primaryCompanyField set to DataAreaId and...

(1) ShareShare
ReportReport
Posted on by Smile1 20
Hello,
I am trying to build my mapping between the tables but I got the following error:
 
Project validation failed. [DIPV1002] Released products V2 or AX is a company-specific entity with primaryCompanyField set to DataAreaId and products of CRM is a cross-company entity that doesn't have primary company field set. Please make sure the entities are both cross-company or company-specific entities.
  1. I have tried to fixed it by adding the Company field into the CRM table and adding it as Integration key here.
But then I got another error
I am trying to add the field but I cannot find any dataareaid or company or legal entity in F&O table.
So, I appreciate it if you have any ideas how to proceed with this.
Categories:
Microsoft Dynamics AX
I have the same question (3)
  • Suggested answer
    ChadAlt Profile Picture
    ChadAlt 367 User Group Leader on at
    Hey there, 
     
    I've been working through some of this kind of thing recently. In Dataverse, you'll need to create a lookup to the Company (cdm_company) table, then include this field as part of the key in Dataverse. Once you have a lookup to the company table included in your Dataverse key, then navigate to the table map in F&O. Click the "Refresh Tables" button while looking at your table mapping. This will regenerate the integration key using the new lookup, and you'll then be able to select the new lookup field in the table mappings (it will look something like the following). 
     
     
    Now after saying this, I realized you're referencing a map that is OOB, and it natively does not have any company attribute. I wonder if you built this map yourself or are trying to modify the OOB one. 
  • Smile1 Profile Picture
    Smile1 20 on at
    I have created the mapping by myself, but the same error appears for the template: CDS released distinct products (products)
     
    Anyway,
    What I described above is exactly what you are talking about, I have created a lookup field in the CRM table and added it as an Integration key, but then I am trying to connect to the F&O field. And the system seems not to have a corresponding field.
    What is OOB by the way?

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans