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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

CompanyInfo could have the same RecId than DataArea table?

(0) ShareShare
ReportReport
Posted on by 5

Hello,

First of all, I apologise because I am not sure if this is the correct thread.

I am working on a case where we have created a new legal entity. So far, so good, but we have realised that there is a completely customised form that does not display data for the new entity.

At first, we thought it was a data problem, but it turns out that there is a relationship between Ledger and DataArea (PrimaryLegalEntity --> RecId, in the order of table), which, following the standard a little, should be between Ledger and CompanyInfo.

I have tried to find out what the direct relationship between the two tables is, but I can't find anything, and for some reason the old entities have the same RecId in both tables, so the relationship in the view worked, but now with my new entity the RecId are different.

  

Could someone explain to me what the relationship between the two tables is? Do they have to be the same RecId?

 

Thanks,

Categories:
I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    237,155 Most Valuable Professional on at
    CompanyInfo could have the same RecId than DataArea table?
    CompanyInfo and DataArea are indeed two different tables and may records there may easily have different record IDs. It's just a coincidence when the related records happen to get the same ID.
     
    Ledger table has PrimaryForLegalEntity field, which has a relation to CompanyInfo.RecId. Trying to interpret is as RecId of DataArea table is wrong.
     
    The relation between CompanyInfo and DataArea is implemented through CompanyInfo.DataArea field.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 707 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
CU05031448-0 Profile Picture

CU05031448-0 600

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans