60
Hello,
When running a general inquiry in GP (for exampled, "Receivables Transaction Inquiry - Customer" or "Payables Transaction Inquiry - Vendor) the default sorting is always done by Document Number
9 times our of 10, my team and I are in need to have sorted by Document Date -- is there a way to easily adjust the default sorting method so it is already by Document Date when running an inquiry?
Thanks much,
Jim
*This post is locked for comments
Have a look at M4 Systems' Batch & Document Inquiry app. It's pretty slick and would give you what you're looking for, in addition to enhanced batch contents inquiry. www.m4systems.com
Do you need Modifier for this change?
We could really save quite a bit of time by changing the default sorting method to Document Date.
Thank you for your assistance.
Loan Nguyen
CyberCoders, Inc.
Can this not be done in Report Writer? I would have thought you could open the report and under the Sort option, you would be allowed to choose how to sort, but maybe your idea is too complicated for Report Writer. We use the standard report, so I have not tried to use the Sort option for this report.
I can only think of modifying that window with VBA code. We do this exact same thing at my work. Basically you select the "Window - After Open" Event and add some code to change it. For example, if you put in the Payables Transaction Inquiry - Vendor window
Documents.Value = 2
It will switch it to by Document Date.
Same applies to the other windows. Just use the After Open Event and figure out what the name of the object is, then set it to what you want.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
