SAP Business One need a list of all AP documents which have been paid by check

[Former Member]

Hi All,

I am trying to create a report for all AP documents (both invoices and credit memos) which have been paid by check.  I am looking for vendor name, vendor code, invoice no or credit memo, check number, amount paid by check, check date.

from which tables can i pull these or any ready made report available.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check below threads:

Thanks & Regards,

Nagarajan

[Former Member]

can i get the check number also using this query

SELECT T1.[DocNum], T1.[CardCode], T1.[CardName], T1.[DocTotal], T2.[DocNum], T2.[DocTotal] FROM VPM2 T0 left join OPCH T1 on t0.docentry = t1.docentry INNER JOIN OVPM T2 ON T0.DocNum = T2.DocEntry WHERE T1.[CardName] = [%0] GROUP BY T1.[DocNum], T1.[CardCode], T1.[CardName], T1.[DocTotal], T2.[DocNum], T2.[DocTotal]

i am not able to get the check number

[kothandaraman_nagarajan]

Link VPM1 to get check number in above query.

[Former Member]

can you help with tis please where do i have to link.