Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Leah Nolan]

I am trying to pull amount paid to vendors in 2016.  I know table PM00201 has amount paid last year; however, this amount is not the same as what is showing in the Vendor Summary Inquiry window.  Additionally, when I run the following script, I get entirely different numbers.

SELECT  V.VENDNAME AS Vendor,
   V.VENDORID AS VendorID,
   CAST(SUM(S.DOCAMNT) AS decimal(12, 2)) AS VendorSpend
FROM  PM00200 V
INNER JOIN PM30200 S
ON   V.VENDORID = S.VENDORID
WHERE  YEAR(S.DOCDATE) = 2016
AND   S.DOCTYPE = 6
GROUP BY V.VENDNAME, V.VENDORID
ORDER BY Vendor

What am I missing? 

——————————
Leah Nolan
Financial Systems Analyst
Med Fusion
Lewisville TX
——————————

[Steven Mayhue]

Victoria Yudin has a fantastic report for total payments to vendors for prior year.  It is located at https://victoriayudin.com/2015/01/20/sql-view-for-total-payments-to-1099-vendors-in-the-prior-year/

——————————
Steven Mayhue
Lead Developer/DBA
My Florida Regional MLS
Maitland FL
——————————
——————————————-