Announcements
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?
*This post is locked for comments
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!
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.
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.
This works for me... Can you attach an export of the check report your are using so we can look...
@Christinad Could you share screen shot because when I print on my GP, everything is in correct order. : )
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.
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....
Shameless plug: Mekorma Payment Hub, which includes Mekorma MICR does this out of the box.
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.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156