AP Query

APPAYMENT for the vendor number, payment number and payment date. Link to APVENMAST for the vendor name.

Below SQL returns the data for one vendor for all checks cut in 2018:

SELECT ap.vendor AS vendor,
TRIM (v.vendor_vname) AS vendor_name,
TRIM (ap.invoice) AS invoice,
ap.tran_chk_amt AS check_amount,
ap.check_date AS check_date
FROM lawson.appayment ap, lawson.apvenmast v
WHERE ap.vendor = v.vendor
AND ap.void_seq <> 9999
AND TO_CHAR(ap.check_date, 'YYYY') = '2018'
AND ap.vendor = ' 36600'

Thank you for the help. I have a query that is pulling total spend for an accounting unit for 2017. This results in many vendors being pulled into my query. Any thoughts on how to accomplish this from AP items coded to an accounting unit during a year.

Table APDISTRIB is going to have the coding, column DIS_ACCT_UNIT is the accounting unit it was coded to.

Any idea where payment is stored so that it can be linked?