Hello,
Is there a way to print a report that would show a list of vendor payments and the invoices that were applied to? Specifically, we're looking for a way to see by Vendor the payments made and what invoices it was applied to. We also need to see the check number.
I looked at the Historical Aged Trial Balance, but it doesn't allow me to add the Check Number next to the payment.
Any suggestions?
Thanks
*This post is locked for comments
Leslie, thanks for the shout out! :-)
Derrell, this is a very common question that I see both from our customers and on GP forums. I have not found an easy way to do this in GP out-of-the-box, but you can use my code that Leslie pointed you to and set this up in SmartList (if you have SmartList Builder) or Excel...or use Crystal or SRS as K Day suggested.
Victoria Yudin to the rescue!!!
Check out her SQL Queries. I think she has exactly what you need. Start with this one:
victoriayudin.com/.../sql-view-for-payables-payment-apply-detail-in-dynamics-gp
Kind regards,
Leslie
I would suggest doing this outside of GP. Do you use anything like Crystal Reports or SQL Reporting services? The table that you are looking for is the PM30300 Table. It is called the Apply Table (the history one). This will tell you the vendor, applied to doc number, applied from doc number (usually payments and credit memos), applied amount, and generally all that you need to see what was applied to what. Any other information you might need can be joined to that table. There are a whole bunch of good key fields you can join to.
I have given up on trying to use report writer. It just takes too long and is not intuitive enough for me anymore with all of the good reporting tools out there. At the very least, just query it from the SQL server and paste into excel.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (