You’re offline. This is a read only version of the page.
Is it possible to sort the PM Aged TB - Options - Detail report by Voucher Number? It looks like the only options are Due Date and Document Date.
Thanks,
Andrew
*This post is locked for comments
Now I'm puzzled. I checked through my version of the report and all of the INV documents were sorted. The only problem children were unapplied payments. I would be interested in looking at the package file if you would e-mail it to me. My e-mail address is leslievail@earthlink.net. Because I haven't received an e-mail from you before, you'll temporarily be put in EarthLink prison. EarthLink will generate a message that you click on to release the imprisoned e-mail. This process helps keep my mailbox from filling up with spam. So, send it my way if you would like me to look at it.
Kind regards,
Leslie
No, unfortunately not. All of the documents are invoices (Type = INV).
Andrew
Hi Leslie,
I tried your suggestion, but the document lines are not sorting by Voucher Number.
For example:
VCH0000068
VCH0000004
VCH0000005
Thoughts?
Andrew
Hi,
Sure, you'll need to open the report in Report Writer and then add a Sort on the Voucher Number of table PM Transaction OPEN File. You cannot change this sort from the report options window, if you want to sort it by date, for instance, you'll need to remove this 'hard-coded' sort by voucher number.
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (