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.
Urgent help required in writing a query
-
- Posts: 26
- Joined: Mon Aug 13, 2007 4:38 am
- Location: United Arab Emirates
Who is online
Users browsing this forum: No registered users and 0 guests