Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

sort order of payables checks

Posted on by

I'm trying to change the sort order on my payables check stubs to have the invoices listed in order by the invoice number on the check stubs.  It appears to be set up correctly with the sort order designated as "document number of table PM payment WORK".  However, when I print checks, the invoices are not listed in order by invoice number.  What am I missing?

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: sort order of payables checks

    Kerry - Can you send out any other information since it sounds as if you have it working? I just need the invoices on the remittance stubs to sort in Invoice number order as opposed to date order. Thought this would be a 10 minute fix but no such luck!

  • christinad Profile Picture
    christinad on at
    RE: sort order of payables checks

    I never did get it to work.  I don't know why everything has to be such a chore with this software!  We just upgraded to the 2018 version and there are no improvements to make simple tasks any easier.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: sort order of payables checks

    I also tried to get this to work sorting by the Payment Stub Duplicate table and had the same mess (multiple pages per check). Next I tried setting the first sort to the Doc Number from the PM Work table and secondly the Doc number from the Payment Stub Duplicate and it still does not work (again with the multiple pages per check). I cannot get it to work so any screen shots or additional information would help.

  • Nanook Software Profile Picture
    Nanook Software 587 on at
    RE: sort order of payables checks

    This works for me... Can you attach an export of the check report your are using so we can look...

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 10,996 User Group Leader on at
    RE: sort order of payables checks

    @Christinad Could you share screen shot because when I print on my GP, everything is in correct order.  : )

  • christinad Profile Picture
    christinad on at
    RE: sort order of payables checks

    We are not interested in purchasing a product to accomplish a task any accounting software should easily be able to accommodate straight out of the box.  Seems Dynamics GP needs many external programs just to do what other accounting software programs do easily on their own.

  • christinad Profile Picture
    christinad on at
    RE: sort order of payables checks

    When I did this, it caused all kinds of issues where the checks did not print correctly.  It would print only one invoice detail on the stubs and then use a bunch of extra paper to reprint the check, listing a different invoice detail on the check stub....

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: sort order of payables checks

    Shameless plug: Mekorma Payment Hub, which includes Mekorma MICR does this out of the box.

  • Nanook Software Profile Picture
    Nanook Software 587 on at
    RE: sort order of payables checks

    The 'Document Number' from the PM Payment Work table is the document of the check not the invoices. You need to set your sort to the Document Number from the PM Payment Stub Duplicate table.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans