I am trying to create a smartlist to pull a number of payments for a vendor. I can see number of invoices, and number of paid invoices under PM vendor master summary. Is there an easy way to pull this information (is it on any tables)?
Thanks!
*This post is locked for comments
Use this TSQL and run against your company database. You can create a view with this TSQL and attach to smartlist, Excel or SSRS.
select [vendor id], [vendor name], sum([Document Amount]) as 'Tot of Payments',count([Document Number]) as 'No of Payments'
from payablestransactions where [document type] = 'payment' and voided = 'no'
group by [vendor id], [vendor name]
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
