I need to correct the following query.
SELECT T0.Number, T0.[RefDate],t0.ref1, T2.[Credit],T2.[Debit],T3.[AcctName],T2.LineMemo, T3.[FormatCode],T0.Memo , T0.Project , case when T2.[Credit] = 0 then 'DR' else 'CR' end as 'DRCR'
FROM OJDT T0 left JOIN JDT1 T2 ON T0.[TransId] = T2.[TransId] left JOIN OACT T3 ON T2.Account = T3.AcctCode
where t0.number = 10006071
i get the desired result
but when i want the entries related to one particular account i get just ONE line data.
I need whole entries in which this *('PREPAID IMPORT EXPENSES (KHI, GTS)')* particular account is used between selected dates.