Hi All,
I would like to get the same result (SQL QUERY) as in Accounts Payable - Common - Vendor Invoices - Open Vendor Invoices datagrid but my SQL query returns more lines than in the datagrid.
Export to Excel = 1421 lines
SQL Query = 1575 lines
Here is my query :
SELECT 'Open Vendor Invoices' AS INVOICETYPE
,VTO.ACCOUNTNUM
,VTO.AMOUNTCUR
,VTO.AMOUNTMST
,VTO.DUEDATE
,VTO.TRANSDATE
,VTR.INVOICE
FROM VENDTRANSOPEN VTO
JOIN VENDTRANS VTR ON VTO.REFRECID = VTR.RECID AND VTO.ACCOUNTNUM = VTR.ACCOUNTNUM
JOIN VENDTABLE VTA ON VTR.ACCOUNTNUM = VTA.ACCOUNTNUM
WHERE VTR.APPROVED = 1
OR VTR.TRANSTYPE = 36
OR VTR.TRANSTYPE = 3
OR VTR.TRANSTYPE = 14
Thanks in advance.
*This post is locked for comments
I have the same question (0)
