I'm looking for a report, or help creating one (or Smartlist), which will show me Vendor ID/Vendor Name/Vendor Address/Amount Paid to in Previous Year to Current. Any suggestions?
Very helpful, I appreciate it, thank you!
Hi Adam,
If you didn't need the exact date, you could use the sum of the paid totals per period from the previous year to the current year.
select * from PM00201 where VENDORID = 'ACETRAVE0001' --Vendor Summary
select * from PM00202 where VENDORID = 'ACETRAVE0001' --Vendor Period Summary
These would be the tables that the Vendor Yearly Summary Inquiry is pulling from. (Purchasing >> Inquiry >> Vendor Yearly)
You could create a SQL view and then pull that into SmartList Designer.
If you wanted to get down to the exact date, it would be more challenging as you would most likely have to look at the the PM20000 and PM30200 for all payments for that vendor by a specified document date range and sum those.
select * from PM20000 where DOCTYPE = 6 and VENDORID = 'ACETRAVE0001' --Open Payments
select * from PM30200 where DOCTYPE = 6 and VENDORID = 'ACETRAVE0001' --Fully Applied Payments
The closest report that I can think of on the top of my head would be the Check Information Report where you could pull all of the checks you issued for a specific vendor/check date range.
Purchasing >> Reports >> Check Information >> New or Modify button
I hope these help in your search for a report that fits your exact needs!
Isaac Olson
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156