Skip to Content
avatar image
Former Member

Trial Balance Query (Grouping account Level 3) with drill down

i am using following query: Need to summarize it at level 3.........

SELECT T1.Debit, T1.Credit,T3.AcctCode, T3.AcctName, T1.TaxDate

FROM OJDT T0

INNER JOIN JDT1 T1 ON T0.[TransId] = T1.[TransId]

INNER JOIN OACT T2 ON T1.[Account] = T2.[AcctCode]

INNER JOIN OACT T3 ON T3.[AcctCode] = T2.[FatherNum]

tb-query.png (157.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers