Skip to main content

Notifications

Microsoft Dynamics CRM forum
Suggested answer

I try to create custom template to show Opportunity & Opp Product Line Item, but I can't get any output from Opp Prod Line Item, pls. help

Posted on by 10

OppProdLine.jpg

Then I select generate Word Template as below;

pastedimage1610453688738v1.png

But no any output information from Opp Prod Line Item (show only table header) as below;

NoOppProdLineInfo.jpg

  • Suggested answer
    RE: I try to create custom template to show Opportunity & Opp Product Line Item, but I can't get any output from Opp Prod Line Item, pls. help

    Hi Joom,

    Based on your custom relationship, you can retrieve Opportunity Products fields (details) in your template but not Product Line items (as an associated entity of the Opp Product) child entity. So you can bring fields from directly related entity. This is an expected limitation.

    Kind regards,

    Dragos

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at
    RE: I try to create custom template to show Opportunity & Opp Product Line Item, but I can't get any output from Opp Prod Line Item, pls. help

    As per your relationship on the template,  you can bring the opportunity product details only on the template, not the product line items.. In templates you can bring only parent entity and it's child entity only(Not child's associated entity details.

  • Joom Profile Picture
    Joom 10 on at
    RE: I try to create custom template to show Opportunity & Opp Product Line Item, but I can't get any output from Opp Prod Line Item, pls. help

    Please help me to solve this problem

  • Joom Profile Picture
    Joom 10 on at
    RE: I try to create custom template to show Opportunity & Opp Product Line Item, but I can't get any output from Opp Prod Line Item, pls. help

    I've already followed the above link, but it still not work.

    may I give u more information, I use the below relationship , not sure it it correct??

    pastedimage1610953713122v1.png

    pastedimage1610953883932v2.png

    Thx u

    Joom

  • Suggested answer
    RE: I try to create custom template to show Opportunity & Opp Product Line Item, but I can't get any output from Opp Prod Line Item, pls. help

    Hi Joom,

    I have tested a similar scenario on my side using a vanilla organization. I have configured a Word Template for Opportunities based on the official documentation: docs.microsoft.com/.../manage-word-templates

    I have then exported my existing data into the Template and it worked as expected.

    5047.Capture.JPG

    Please use the guidelines in the official documentation and follow all the required steps. Please pay attention to the relationship required and also to the precise fields included in the template.

    Afterwards, if you will face the same challenge, please share details in regards to the precise entity, relationship between entities, fields used and the full template configuration so that we can analyze the exact scenario or open a Support Ticket for in depth review if customizations are involved.

    Regards!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans