Daily Use Querry

No Transactions for Vendor in a Report

SELECT T0.CardCode, T0.CardName
FROM ocrd T0
WHERE T0.CardType= 'S' and T0.CardCode NOT IN (SELECT cardcode FROM OPOR WHERE DateDiff(dd,docdate,GetDate()) < 180)

Want query for ,All suppliers that have had NO transactions

 

SELECT T0.[CardCode], T0.[CardName], sum(T1.[Debit] - T1.[Credit]) FROM OCRD T0 left join JDT1 T1 on  T1.[ShortName]  = T0.cardcode WHERE T0.[CardType] = 'S' and  T1.[RefDate] >= [%0] GROUP BY T0.[CardCode], T0.[CardName] having sum(T1.[Debit] - T1.[Credit]) = '0'

 T0.[GroupCode]