Dear All
I have 2 tables,
1) Chart_of_account
2) GL_OPEN_BALANCE
i have fetched the data from "Chart_of_account" hirarchy wise and associate all the balances from "GL_OPEN_BALANCE".
The Problem is that, all the balances are occuring at the lowest level i.e level 4
Now i want to get the cummulative balance of level 4 to level3 with respect to their parent. Then accumulated balance of level 3 to level 2 and accumulated balance of level 2 to level1.
Please help me in this regard
my email address is "nadirpervez@gmail.com"
regards
Trial Balance Query
Who is online
Users browsing this forum: No registered users and 1 guest