Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Document template ,how to decide if there are 1: N relation. which record it should take to generate the document?

Posted on by 580

If there is a 1:N relation between account and contact , while generating doc for account with template how we can set the contact dynamically . 

I have a grid of contacts in accounts , I may select more than 1 contacts to generate the documents for the same in one button click.  

*This post is locked for comments

  • Suggested answer
    ajyendra Profile Picture
    ajyendra 1,730 on at
    RE: Document template ,how to decide if there are 1: N relation. which record it should take to generate the document?

    Hi Bhabani,

    As per my Understanding you are generating the word document for account which contains multiple contact in it(as in grid). Now you want when you generate doc for account , all the contact inside that account will display on Report(doc).

    So , when you create new template Go to Settings -> Go to Template -> Document Template -> Click on New Button A popup display then select "word template" 

    pastedimage1567077140262v1.png

    Click on New Button A popup display then select "word template" 

    pastedimage1567077243006v2.png

    then Click on "Select Entity" button then another popup open that display all the relationship exist with Account Entity

    For your Case select Contact Entity in 1:N relationship. then Download template After Open the document you can see the Developer tab in Ribbon of Microsoft Word. If not Go through below link 

    https://wordaddins.com/support/how-to-show-the-developer-tab/

    then click on XML Mapping Pane then the select your on Custom Xml part through dropdown. and add fields as per your needs.

    If you want repeater that multiple contact is display please refer that Video IT will explain everything in Brief.

    https://www.youtube.com/watch?v=Jwo0G7lcaXw

    Please make as verified if that answer is helpful .

    Thanks 

    Ajyendra

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans