How to get a reason for win or loss to appear in a view for opportunities?

(0) Share

Report

Posted on by Community Member

Hi Experts, I have a customer request to show the reason for win or loss of an opportunity on the opportunity view. All opportunities. . Anyone know how to capture this field? It is not showing in the list of columns you can add to an opportunity view. I believe it is the Opportunity close.

Thanks in advance.

Debbie

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Wahaj Rashid 11,321 on at

Like (0)

Report
Hi,

Thank you for your query.

You are right, the Win/Lost reason is stored in Opportunity Close activity.

You need to create a view on the Activity table and set Activity Type to Opportunity Close. The reason is stored in the Activity Description column.

Then expand your query to Regarding(Opportunity) to add columns from Opportunity.

Here is how to look for this info in Advanced Find:

Look for Activity.

Add filter, Activity Type equals Opportunity Close.

Add the Description column from the Activity table to see the reason.

.

Add the Opportunity columns from Regarding Opportunity.

Here is the final query:

Results ( I removed the extra activity columns in the view):

Please note, you cannot go from the Opportunity route to get win/lost reasons, you have to start from Activity. This means the view will be on Activity, instead of Opportunity.

It's better if you create a report (using report wizard) for this purpose.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi Partner,

The opportunity and opportunity close is 1:N relationship, so you want to show fields from child records(opportunity close) in the view of parent records(opportunity).

In general, you can add fields from parent records into view of child records directly, which is very easy, but the opposite seems to be impossible.

So the best option is creating a report if you want to view opportunity close fields in opportunity view.

You can then create a report which reports on the Opportunity Entity and the Opportunity Close Entity:

This will allow you to add fields from either the Opportunity screen or the Opportunity Close screen to the report.

This is an example:

You can add fields you want.

Finally, we have a final result as per the following:

You can refer following link to know more details about Report Wizard:

Create a report using the Report Wizard - Power Apps | Microsoft Docs

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Leah for the step by step for the report. Very helpful!

Was this reply helpful? Yes No