Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Show all quote lines total amount sum in TOTAL Field on word quote template

Posted on by Microsoft Employee

Hello Friends,

I am facing one issue when creating word template for quote.

Able to get all the products but I need to add all the total amount of all quote line in total field. I tried the default feature of Word 

i.e. SUM (ABOVE) but this doesn't worked at all.

I would really appreciate all your support. Please suggest if anyone have some solution.

Thanks

Kavita

*This post is locked for comments

  • Suggested answer
    CRMJetty Profile Picture
    CRMJetty 3,508 on at
    RE: Show all quote lines total amount sum in TOTAL Field on word quote template

    Hello Kavita Saini,

    You need to create a field for the Quote entity to summarize the quantity of the quote products, so it should be the rollup field. The rollup field won’t be calculated in time, so we’ll use the workflow to recalculate each updated quote. We can set the refresh time of the rollup field, which can be as short as 1 hour.

    Refer this detailed Blog for total amount of all quote line in total field.

  • Suggested answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: Show all quote lines total amount sum in TOTAL Field on word quote template

    Hello,

    Add a roll-up field on the quote entity that does the summation for all quote lines amount. and then use this field in your template.

    Check this link for more details on Roll-up fields: docs.microsoft.com/.../define-rollup-fields

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans