Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Sort invoice by Item Class

Posted on by 35

I am looking to modify my sales invoice to sort by Item Class and subtotal each class.  Any ideas.  I have seen some posts but they don't quite get me there.  Also exporting a report to a template or word just doesn't seem possible.

  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: Sort invoice by Item Class

    Modifying the SOP invoices to sort the items in a specific order can be a bit tricky.  You can't add just the sort you want, but instead you need to add a bunch of sorts before your sort to ensure that the sorting of the documents themselves are not affected. This is different for the different SOP reports but in general you could start with a sort like the following and see if it works.

    Sequence Number

    Sop Type

    Sop Number

    Item Class

    You will know if the sorting is not right because you will see where the it will only print one item per page for some SOP documents and if that happens the sorting options need a bit more adjustment.

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

Product updates

Dynamics 365 release plans