Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sorting Invoices

Posted on by Microsoft Employee

We print about 1000 invoices each week. They use to print in Numeric and Alphabetical order. (i.e. IVC0700001111 AJAX, IVC0700001112 BEAN, IVC00001113 BURN, etc...)


Suddenly, the past few weeks, they have been printing in Numeric only order. (i.e. IVC0700001111 DAWN, IVC0700001112 XEROX, IVC00001113 CORD, etc...). The customer names are all over the place. What could have changed that and how do I fix it?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sorting Invoices

    Sorry, the invoice numbers are all the same. I simply mistyped them in my example.

    The sort order is by Document Number.

    The data for the invoices is imported from a third party software. We run a transfer process that magically creates the invoicing batches. I have tried to tell them that the issue is on their side but they insist it's Dynamics. I will go back to them and press harder. I don't think there is an answer on the GP side. I apologize for wasting your time. Thank you for the help anyway.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Sorting Invoices

    I am not aware of any option that control the sort order for printing invoices but just out of curiosity, if you click on the lookup for invoice number, what sort order is being used there? I am wondering if SmartList may be controlling the order.

    PrintSalesDocs2.png

    IVC0700001111 AJAX    IVC0700001111 DAWN

    IVC0700001112 BEAN   IVC0700001112 XEROX

    IVC00001113 BURN       IVC00001113 CORD

    Actually, looking at your invoice numbers they are of different lengths. What order are you expecting? How are these invoices generated? Are they imported?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sorting Invoices

    Thanks for the quick reply Richard. We print from the Invoice Batch Entry window (Transactions,  Sales, Invoicing Batches) and print an entire batch of invoices at one time.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Sorting Invoices

    Are you printing from this screen? Did you change the sort order? How do you print your invoices?

    PrintSalesDocs.png

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