Cerca les comptes contables que no tenen definit un concepte SII (del plà comptable)
SELECT la.Account from OJDT a join JDT1 la on la.TransId=a.TransId and (la.Account like '6%' or la.Account like '7%' or la.Account like '555%' or la.Account like '230%') join OACT pc on pc.AcctCode=la.Account where (a.U_INTRX_SIIConcepto is null or a.U_INTRX_SIIConcepto='') and a.TransType in (13,14,18,19) group by la.Account