Skip to Content
0

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

Jan 16, 2017 at 07:34 AM

67

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers