You’re offline. This is a read only version of the page.
You can go to Cards->Purchasing->Summary and punch in a vendor and then hit the print button and get the annual summary for a vendor. However, I am looking for a report where I can enter the year and then get a vendor summary for all vendors on one report. Sure, I could drop down to SQL and query the PM00201 table but I just tried clicking on every payables report option I could find and there appears to be no one report that gives you, per year, the number of invoices and payments and the summary dollar value of the invoices and payments. Before I start to write my own using SSRS does such a report exist in GP 2010.
*This post is locked for comments
I have the same question (0)
Richard,
In GP? No.
On my blog? Yes. In two different flavors even:
victoriayudin.com/.../sql-view-for-vendor-yearly-totals-in-dynamics-gp - Shows calendar year totals for all vendor transactions – results are one row per vendor with the years in columns.
victoriayudin.com/.../sql-view-to-show-yearly-totals-for-dynamics-gp-vendors - Shows calendar year totals for all vendor transactions – results are one row per vendor per year with the columns being the different possible yearly totals.
Share
Report
75,852
All responses (
Answers (
