Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Legal Entity

Posted on by Microsoft Employee

How to display values from particular "Company" of  "Legal Entity" as one of the "Table Fields"?

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Legal Entity

    Hi Aniket,

    You can check the field BuyingLegalEntity in table PurchReqLine for an example of how you can achieve this. This field is on type RefRecId and has a relation to CompanyInfo table.

    pastedimage1616325536432v1.png

    If you need a field of type string in the table, you can try creating a new field having EDT "DataAreaId". This should also give you a lookup of company values.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Legal Entity

    Hello,

    The requirement is :

    I have to utilize Lookup field. This should display values from "company" field of form Legal entities. Path - Organization administration>Organizations>Legal entities.

    So, I would like to know how to find the field so that I can add it to my Table.

    And sorry I could not provide the example since I'm new to this technology.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Legal Entity

    Hi Aniket,

    Is it your intention to get a certain field value from the Legal entities form (record 'DAT') and copy it in your table? Or do you need the definition of a certain field? Can you be a bit more clear with the exact requirement (e.g. provide the example)?

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Legal Entity

    Hi Aniket,

    You can check the data sources of the form and figure out which table the field is in. The primary table containing the information regarding legal entities is "CompanyInfo". You may start by looking at this table to see if the field you need is present here.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Legal Entity

    Working on Sample Table. I want to add a field which belongs to Legal Entity Company DAT. I need help in finding the DAT company's Table and it's field from below page. So that I can add that field in my SampleTable.

    pastedimage1616315138737v1.png

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Legal Entity

    Hi Aniket,

    Could you please elaborate on your requirement? Which table are you working with here?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans