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 / 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 50

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
I have the same question (0)
  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,027 Moderator on at

    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.

  • JeroenS Profile Picture
    JeroenS 50 on at

    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 1,027 Moderator on at

    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).

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 > Sales

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans