ERPstuff - Oracle EBS Community

Posted: **Sat Nov 15, 2008 4:29 am**

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.

Posted: **Mon Nov 17, 2008 2:28 pm**

Hello.

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

Octavio

ERPstuff - Oracle EBS Community

Urgent help required in writing a query

Urgent help required in writing a query