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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Add custom fields to Account entity in Dynamics 365 Sales Enterprise

(0) ShareShare
ReportReport
Posted on by 15

Hi lovely forum members!

I'm a noob developer/system configurer preparing a CRM for a company in Dynamics 365 Sales Enterprise.

We need some additional information added to the Account entity, which the standard columns don't cover. This seems like it should be obvious (apologies for being a noob!), but the MS-provided training modules don't seem to cover it.

Additional columns required are:

  • Registered number (text field)
  • Country of incorporation (this can be different to the country in which the account operates) (country option drop-down list if possible, allowing only selection of country names for this field, e.g. USA, Canada etc)
  • Source - drop down options, gives the option to provide the source of the Account, whether via their website enquiry form or from a referral partner - which then allows to search for and link the Partner record (Partner will be set up as a custom entity, which would be linked to the Account using this method)

Thank you in advance!

I have the same question (0)
  • Suggested answer
    Moximox Profile Picture
    2 on at

    Hi

    Yes it is a very easy task. Recommended approach is to do changes in a separate dev environment into an unmanaged solution which you then export to your uat and prod as managed solution.

    When you have created your solution you simply add the tables you require to developed - in this case account. You go to the column section and add the required fields.

    docs.microsoft.com/.../create-edit-entities-solution-explorer

  • Suggested answer
    Amit Katariya007 Profile Picture
    10,409 Super User 2025 Season 2 on at

    Hello Tim,

    You can implement above 3 requirements.

    1. Create a Single line of text(It this field has non number values). If it does not have the non number value then you can use the whole number field.

    docs.microsoft.com/.../types-of-fields

    2. Then For the Country you can create a drop down(option set) field or Lookup field.

    3. For this one you will have to work with dependent Lookup fields because from one lookup field you will show the related data in another lookup field.

    If you are thinking to filter the lookup data by using the drop down list then it will be very difficult to implement.

    microsoft-business-applications.hcltech.com/.../

    Thank you,

    Amit katariya

  • Verified answer
    Community Member Profile Picture
    on at

    Hi Tim Bee,

    According to the description of the case, I did the following test

    Create Registered number field

    pic33.png

    Create Country of incorporation field

    Select option set and set the content of options.

    pic34.png

    pic35.png

    Create Source field

    I suggest you to use sub-grid to achieve.  Here I am using the contact entity, you can replace it with the partner entity.

    1.Create 1:N relations between Account and Contact

    pic36.png

    pic37.png

    2.Create a view that you want to display.

    pic38.png

    pic39.png

    3.Add Tab and sub-grid.

    pic40.png

    pic41.png

    pic42.png

    pic43.png

    Select related entities and views

    pic44.png

    pic45.png

  • Suggested answer
    Tim Bee Profile Picture
    15 on at

    Thanks Steve, your answer was really helpful. It took me a while to locate the classic view to achieve this, and I'm still working on the final on the final point connecting a new custom entity, but your answer and pictures were what I needed! Thanks!

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…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 96 Super User 2025 Season 2

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans