Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Show details from the Product Entity RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I want to show some details from the Product Entity on an Advanced Find on Contacts (details about the product the contact has on their invoice) Ihave created a relationship and I can see the field but no data is returned.
    Thursday, February 16, 2012 10:49 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    If you are using Advanced Find to search for contacts then you will only be able to show fields from the contact entity or fields from any parental entities, but not child entities. For example, you can show some contact fields and some fields about the contact's owner (because owning user is parental to the contact). But you can't show fields from the contact entity and the contact's invoices and the invoice's items and the invoice item's product because all of these are child entities of each other.

    Neil Benson, CRM Addict and MVP at Customery Ltd. Join me on Twitter. Join over 20,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.

    Thursday, February 16, 2012 3:28 PM
    Moderator

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    If you are using Advanced Find to search for contacts then you will only be able to show fields from the contact entity or fields from any parental entities, but not child entities. For example, you can show some contact fields and some fields about the contact's owner (because owning user is parental to the contact). But you can't show fields from the contact entity and the contact's invoices and the invoice's items and the invoice item's product because all of these are child entities of each other.

    Neil Benson, CRM Addict and MVP at Customery Ltd. Join me on Twitter. Join over 20,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.

    Thursday, February 16, 2012 3:28 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Neil

    OK that makes sense - is it possible to do what I am trying to do ?

    Thursday, February 16, 2012 3:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    No, not with Advanced Find. If you're trying to show some details about the products associated with a contact's invoices then you'll need to develop a custom report.

    Neil Benson, CRM Addict and MVP at Customery Ltd. Join me on Twitter. Join over 20,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.

    Thursday, February 16, 2012 6:35 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    OK Thanks - I was hoping to used Advanced Find as I want to use it for Marketing Lists.
    Thursday, February 16, 2012 6:56 PM