Customer experience | Sales, Customer Insights,...

Creating relationships with a custom entity

(0) Share

Report

Posted on by barbieruelas

Hello,

I've created a custom entity for a special sales program with our company. This new entity should capture events that bring in new leads, opportunities and accounts. This new custom entity also 'manages' everything done under this new sales program through custom system views and goals. I've created a custom entity under activities for other services done under this program too.

In essence I have to link the new entity that captures event info, the new activity entity, accounts, leads, opportunities and goals to the new entity created for this new sales program so I can track progress and records that are affected/created by events and activities entered. It think a good way to explain it is, I am trying to customize the "Campaign" function to my company's needs.

I've created custom fields on Accounts, Leads, Opportunities, to identify them as part of this program. (It's just a simple Yes/No field) And if I can, I will create a business rule that changes to "yes" if an "EVENT" information (per the sales program) is entered in the forms.

With the aforementioned in mind, I'm having a hard time creating relationships so I can link other entities and records to this new sales program. When I first tried, I used N:1 with Accounts and the new entity for the special sales program, and when I tried to test it creating a custom system view, I was not able to use Account records for the view.

Would a D365 ninja please help me?

I have the same question (0)

All responses (4)

Answers (0)

LuHao 40,892 on at

Like (1)

Report

Hi barbieruelas,

If the Account and the new entity are in a N: 1 relationship, then we can only use the fields of the new entity on the Account view.

Because the parent entity exists on the child record as a lookup field, the child entity view can display the fields of the parent entity by the lookup field.

In your environment, Account is a child entity, and the new entity is the parent entity, so the fields of the new entity can be displayed in the Account view, but the Account fields cannot be displayed in the view of the new entity.

If I misunderstood your problem, please correct me.

Was this reply helpful? Yes No
barbieruelas 4 on at

Like (0)

Report

Is there a way to change the new entity in a way a relationship is created and then it can show the Account fields?

I don't mind re-creating the new entity. Thanks for the help!

Was this reply helpful? Yes No
Suggested answer

LuHao 40,892 on at

Like (0)

Report

Hi barbieruelas,

We need to create a 1:N relationship for the Account entity and the new entity.

Go to the customizations panel, and click the new entity > N:1 relationship, new a relationship, select Primary Entity as Account.

After creating a relationship, go to new entity > views, edit a view, click Add Columns, select Record Type as Account, select its fields. Finally publish all customizations.

Was this reply helpful? Yes No
Suggested answer

Paul_Owen 2,027 on at

Like (0)

Report

Hi, just add lookup fields to the entities that Lookup to the Parent entity and it will automatically create N:1 relationships.

Regards

Paul

Was this reply helpful? Yes No