Suppplier Invoice

SELECT a.companyid,a.serialNo,a.supplierid,a.journalno ,b.journalid,b.acctcode  
FROM `comp_supplier_invoice` a 
left join `comp_journal_detail` b ON a.journalNo = b.journalID
WHERE a.`companyID` = 3 
AND b.acctCode = 32802
ORDER BY `a`.`supplierID`  ASC


Supplier Payment

SELECT a.companyid,a.serialNo,a.supplierid,a.journalno ,b.journalid,b.acctcode  
FROM `comp_payment` a 
left join `comp_journal_detail` b ON a.journalNo = b.journalID 
WHERE a.`companyID` = 3 
AND b.acctCode = 32802
ORDER BY `a`.`supplierID`  ASC


Supplier table

SELECT id,companyid,suppliername,linkedAPAccountID FROM `supplier` WHERE `ID` = 50 AND `companyID` = 3

or

SELECT id,companyid,suppliername,linkedAPAccountID FROM `supplier` WHERE `ID` in (32,38,66,67,68,69,78,92,104,108,116,131,141,143,171,172,173,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,196,197,198,199,200,201,202,203,208,209,210,211,212,215,218,219,222,225) AND `companyID` = 3

SELECT id,companyid,suppliername,linkedAPAccountID FROM `supplier` WHERE `ID` in (1,3,7,8,9,10,11,12,14,15,16,117,118,119,120,121,126,127,138,145,146,147,161,162,164,165) AND `companyID` = 2


8946