Improve company productivity with a Business Account.Sign Up

x
?
Solved

Microsoft CRM 2011

Posted on 2011-09-20
4
Medium Priority
?
710 Views
Last Modified: 2012-05-12
I am trying to create a view from Opportunities and Opportunity products associated as Line Items with the Opportunity.  

From the Opportunity,I want to show the customer, the owner of the opportunity, the probability, the estimated amount

From the Opportunity Products (added as Line Items to an Opportunity when it is created), I want to show Product ID and Product Name.

I have tried modifying the views (Active Opportunities), creating relationships between the two entities (Opportunity and Opportunity Product), using Advanced Find and modifying the Advanced Find view in Opportunity entity.

This is the online version of CRM 2011 so it looks like I cannot use SQL Server Mgmt Studio to view the two tables and find the fields I need.

So if someone can tell me how to link Opportunity and the Opportunity Products Line Items so I can have create a View of this combined information, I would very much appreciate it.

Thanks for your help.
0
Comment
Question by:apollo7
  • 2
  • 2
4 Comments
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 36572447
I think you can do this without creating any new relationships. The trick is to base the Advanced Find on Opportunity Products. Then use Edit columns to add the required columns:

In Record type:
 select Existing Product (Product). This gives you the Product ID
 select Opportunity (Opportunity). This gives you the Estimated Revenue and Probability

Remember that Advanced Find can only return a list of records of one type but it can display fields from records immediately related to that type. For anything more complex you will need to write a report.
opp-product.JPG
0
 
LVL 1

Author Comment

by:apollo7
ID: 36573494
feridun

that works great - is there a way I can display this as a view under Sales > Opportunities or as a view available from my Opportunities dashboard view selector?

Not sure where I can call it from?  Products?

Thanks
0
 
LVL 30

Accepted Solution

by:
Feridun Kadir earned 2000 total points
ID: 36573558
I think not. Only views based on opportunities will shown under Sales | Opportunities.

You can create a system chart for opportunity products and then add that chart to a dashboard.
0
 
LVL 1

Author Closing Comment

by:apollo7
ID: 36573764
Thanks very much - this was very helpful
0

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …
Go through the video which explain the procedure to export Amazon WorkMail single or multiple mailboxes to Outlook with Kernel Export Amazon WorkMail to PST tool. User can see the simple steps to export. It has salient features like filters (Include…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question