Urgent help required in writing a query

[raoofbasheer]

I have the following level accounts

10000
11000
11100
11101
..
..
11200
11201
..
..
..
12000
12100
..
..
..
12101
12102
12103
..
..
..
20000
21000
21100
21101
..
..
22000
22101
..
..
..
.
21200
21201
..
..

I have to take the amount of the child account and sum it to the parent account as below:

11100 = 11101 + 11102 - 11103+.........

11000 = 11100 + 11200 + 11300+.........

10000 = 11000 + 12000 + 13000+.........



21100 = 21101 + 21102 - 21103+.........

21000 = 21100 + 21200 + 21300+.........

20000 = 21000 + 22000 + 23000+.........

Please help...

Thanks in advance.

[oteixeira]

Hello.

To which segments do these accounts belong to? What do you want to sum? Debit? Credit? For which period?

Octavio