Skip to Content
0
Former Member
Jan 13, 2011 at 05:22 PM

Trial Balence amount is different with query of JDT1 amount

28 Views

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'