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 :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Creating lookup field on Opportunity Close entity - not supported?

(0) ShareShare
ReportReport
Posted on by 120

Hello,

Now that we are able to customize the opportunity close entity along with adding fields, we wanted to create custom lookup fields to other entities to be able to capture winning product, competing product etc but when we are unable to create lookup fields, the "Target Record Type" is just empty/not clickable.

Is this intended or just a bug in our environment?

Screen-Shot-2020_2D00_03_2D00_16-at-13.12.46.png

I have the same question (0)
  • Verified answer
    Gary Letter Profile Picture
    1,267 on at

    Hi David123,

    I haven't found it documented anywhere, but I don't think it's a bug. It looks like adding fields is allowed, but adding relationships is not. Adding a lookup field would create a relationship.

    If you try to create a Customer field, which also creates relationships, that is not grayed out. But you will get an error, "The referencing entity of a relationship must have the CanBeRelatedEntityInRelationship managed property set to true," which implies that that metadata property that would allow custom entity relationships is set to False for the Opportunity Close entity.

    Gary Letter
    NextLevel Business Systems

    If you find the answer useful, please click "Yes" to mark it as verified.

  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi David123,

    Agree with Gary.

    The Opportunity Close entity does not support creating lookup field, which is by design.

    When we create a lookup field, we are actually creating a new N:1 relationship for this entity.

    If you are going to create a new N:1 relationship of the Opportunity Close entity, you will find that there is no New button. Opportunity Close entity does not allow new relationships to be created.

    pastedimage1584425974304v1.png

    Therefore, the Opportunity Close entity does not support the creation of lookup fields.

  • Community Member Profile Picture
    on at

    Which is weird, because it clearly states in the documentation by Microsoft:

    What customizations are possible?

       Customization of Opportunity Close entity to add custom fields, including of type Lookup.

    docs.microsoft.com/.../customize-opportunity-close-experience

  • Community Member Profile Picture
    on at

    As a reminder for other people: 

    This should work and it now works in our instance. Microsoft had to apply a script in the backed to get it fixed on our organization. It should work directly in a new vanilla environment. 

  • tledbetter88 Profile Picture
    5 on at

    Thanks for this post! I think this script issue may be a problem for our environment as well.

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 > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 80

#3
Martin Dráb Profile Picture

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans