[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Microsoft CRM 2011

Posted on 2011-09-20
4
Medium Priority
?
706 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about how to approach blogging and about ways to do it right. Stand out from the crowd and let your knowledge be consumed by a large audience. This article aims to explain how your blog should look like,  the most important things to do while b…
A big percent of today’s marketing activity is performed through the online environment. The marketing strategies that have existed a decade ago no longer relate to what’s happening today. We’re currently facing a revolutionary era, called the digit…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

649 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