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

 

image_pdfimage_print
Per |2018-08-11T12:43:24+00:0018/12/2017 19:14|Fragments, SAP Business One, SII, SQL Server|
Aquest lloc web utilitza galetes per millorar el rendiment i la experiencia de navegació. D'acord