Hi all,
I try to get summary from JDT1 for a period, but I find the debit amount is different with Trial Balance. does anybody knows what's happen ? please help.
the queries is this :
SELECT sum(T1.[Debit]), sum(T1.[Credit]) FROM OJDT T0 INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId INNER JOIN OACT T2 ON T1.Account = T2.AcctCode WHERE T2.[FatherNum] = 'A01' and T0.[DueDate] >= '1/1/09' and T0.[DueDate] <= '12/31/2009'