SII: Comptes sense concepte

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