Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Sales forum / Extend the Address ent...
Sales forum

Extend the Address entity with a ISO country code field

(0) ShareShare
ReportReport
Posted on by JeroenS 46

Hi All,

I have read a few articles about the address entity but was unfortunately not able to find the answer.

We have the following scenario:

Because the country name field within the Address entity is messing up reporting we would like to align this.

The idea would be to:

- Create a new Custom entity called Country

- Create a new custom field on the Address entity which will be of type Lookup to the newly created entity Country.

Somehow I am not able to create a field on the Address entity of type Lookup to create this reference.

Am I maybe missing one of the limitations that I am not aware of ?

Please advise

Jeroen

Categories:
Addresses
  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: Extend the Address entity with a ISO country code field

    Hi Jeroen Scheper,

    My usual method of solving this problem is to create a custom country entity, and then display the country records using either a Lookup field or a Sub-Grid depending on how I want to display the data. For the integration with Dynamics AX, I would use SQL Server Integration Services (SSIS).

  • JeroenS Profile Picture
    JeroenS 46 on at
    RE: Extend the Address entity with a ISO country code field

    Thank you for your reply.

    But how what you make sure that countries are defined in a unique way ?

    - using external tools to enforce a country dropdown?

    - integrate this with an ERP (AX) that does require the dropdown (validation of addresses)

    Ideally I do not like to go for the custom route.

    Any thoughts?

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 21,009 Super User 2024 Season 2 on at
    RE: Extend the Address entity with a ISO country code field

    Hi Jeroen Scheper,

    You cannot create custom fields or relationships on the address entity, and you will not want to once you know how the entity works. The address entity is actually one of the more complicated entities behind the scenes. For more on this topic read this article.

    A better idea is to modify your report so that the country name field does not influence it.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans