Sorting options for "Check with two stubs on top"

(0) Share

Report

Posted on by DominicBeland

330

I'm trying to modify the body section of the "Check with two stubs on top" so that it sorts the listing of paid invoices by voucher number instead of vendor invoice number.

I tried by going to the "sorting" in the report definition:

I added the "Voucher number" from the PM Payment Stub Duplicate so it's on the right side

The result is a page for every voucher number. If I have 13 vouchers, I have 13 pages with the same check # but each with its own voucher paid. But all 13 pages are sorted by voucher number. How do I group the vouchers so they are all on 1 page ?

*This post is locked for comments

All responses (2)

Answers (1)

christinad on at

Like (0)

Report

RE: Sorting options for "Check with two stubs on top"

Justin, I want to sort by invoice number. Following the above, I would think the final step would be apply to document number of table pm payment stub duplicate, but that is not an option. Please advise.
Verified answer

Justin Thorp 2,265 on at

Like (0)

Report

RE: Sorting options for "Check with two stubs on top"

Hi,

You need to make the sorting as follows:

Document Number of table PM Payment WORK

Sequence Number of table PM Payment Stub Duplicate

Apply To Voucher Number of table PM Payment Stub Duplicate

Thanks,

Justin