Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / sales Quote Sorting Pr...
Customer experience | Sales, Customer Insights,...
Answered

sales Quote Sorting Print rows

(2) ShareShare
ReportReport
Posted on by Samantha73 2,684
Hi All
Is there a way to change the row order once a quote is created for example line 1 move down ? This is for printing so the printout comes with sorting of rows however we like. Can the word print designer handle and extra field with numeric values for sorting? I could nt find and on screen option to do so. Can a customisation work with a column for manual numbers for sorting
Categories:
Microsoft Dynamics CRM
  • Verified answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 851 on at
    sales Quote Sorting Print rows
    I might offer an alternative solution that I'm hoping is a bit easier for you to implement. Custom PCF controls are bits of code, typically offered in a managed solution, that change the way users interact with fields or grids in CRM.
     
     
    The linked PCF Control above was written to change the subgrid behavior and allow users to drag and drop lines to rearrange them. There is some setup to make this work, but putting this in place should meet what you are looking for and give ultimate flexibility to the users.
     
    • Download and install the managed solution that includes the PCF Control
    • On your quote lines table, create a new field called "Sort Order" and that has a type of Whole Number
    • On your Quote form, go to the Quote Lines subgrid and Add the custom component. Update the settings to define your new sort field, autosave, stuff like that.
    • Make sure your subgrid view is set to sort on your new Sort Order field, smallest to largest
    • Save and publish your changes
     
    Once set up, users should be able to drag and drop to rearrange and you have a sorted number field by which to create your documents and such.
     
    If this answer helped, please consider marking as verified.
  • Suggested answer
    Daivat Vartak (v-9davar) Profile Picture
    Daivat Vartak (v-9d... 3,110 Super User 2025 Season 1 on at
    sales Quote Sorting Print rows
    Hello Samantha,
     
    You're right, there's no direct drag-and-drop or built-in reordering of Quote product lines (Quote Line Items) within the Dynamics 365 Sales Quote form. 
     

    Here's a simple way to use Power Automate to print your quote lines in a specific order:

    1. Save your quote template in OneDrive: Store your quote print template in your OneDrive.

    2. Use Power Automate: Create a Power Automate flow.

    3. Fill the template: Use Power Automate to fill in the template with your quote data.

    4. Sort the lines: In Power Automate, sort the quote lines how you want them.

    5. Make a PDF: Use Power Automate to turn the filled template into a PDF.

      6.  

    Important: This takes time to set up, but it gives you control over the order of your printed quote lines.

     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.
     
    My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.
     
    Regards,
    Daivat Vartak
  • Samantha73 Profile Picture
    Samantha73 2,684 on at
    sales Quote Sorting Print rows
    The field created on doesn't work as we are trying to re=sort after creating so the original order of rows need to be changed something like UP/DOWN arrows in other ERP systems where you can re-sort or some customisation if its possible 
  • Suggested answer
    Jimmy Passeti | MVP Profile Picture
    Jimmy Passeti | MVP 323 Super User 2025 Season 1 on at
    sales Quote Sorting Print rows
    Hello,
     
    There is a field called "Created on" that is always updated with the date and time that the record is created.
    What about use this field to sort your view?
     
    Regards,
    Jimmy Passeti | Microsoft MVP
    ✅ Please mark as Verified if this answered your question!

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,925 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans