Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to Sort in Word Template the Quote Lines of a Quote Alphabetically?

Posted on by 2

Dear, please, I need to know if there is a way to Sort in the Word Template the Quote Lines of a Quote By Alphabetical Order?

Scenario: I have a Word Template that displays a Quote summary, so in this template I have a table that displays the Products/Quote Lines, but the template always sorts Quote Lines by the Creation Date on which the Quote Lines were included in Quotation, which unfortunately is a native behavior of Dynamics365, however I need to know how do I order Quotation Lines Alphabetically instead of Creation Date?

I noticed that in the Quotation Lines there are the Sequence Number and Line Item Number fields by Dynamics, but even filling them, it does not reflect in the Ordering of the Quotation Lines when the Word Template is generated, it always continues to display the Lines of Quotation by the Creation Order in which they were included in the Quotation.

Does anybody know how to solve this?

  • CU23100303-0 Profile Picture
    CU23100303-0 2 on at
    RE: How to Sort in Word Template the Quote Lines of a Quote Alphabetically?

    Thank you very much for help. But, do you know one other solution that solve this case with other procedure?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Sort in Word Template the Quote Lines of a Quote Alphabetically?

    Hi Dani,

    Unfortunately, you can't achieve it.

    Note from Microsoft:

    Lists in created documents are not in the same order as records

    Lists of records created from a custom template may not appear in the same order in Word documents as the order in customer engagement apps. Records are listed in the order of the time and date they were created.

    https://docs.microsoft.com/en-us/power-platform/admin/using-word-templates-dynamics-365#lists-in-created-documents-are-not-in-the-same-order-as-records 

    Scott Durow proposed the idea in the past, but is not picked up by Microsoft.

    Microsoft Idea (dynamics.com)

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans