g/l account hierarchy and fund one below the other in report

[Former Member]

Hi all,

I have a requirment wherin I have to have a G/L account hierarchy and under the hierarchy i need show a few fund accounts.

Can we do that in one query?

Thanks,

[Former Member]

Do you need to show some accounts that are included in the hierarchy or just some a/c's that have nothing to do with the hierarchy?

[Former Member]

Sri,

It has nothing to do with the hierarchy. Those are two comepletely differents objects.

Thanks for the reply

[Former Member]

Why not create a new FSV showing the funds accounts undernath the normal hierarchy?

[Former Member]

Hi SImon,

we have to do that in the BW side right ?

Now under my FSV, I have to include fund accounts which again are again restricted. Example

FSV

Fund (if fund is classified as X than in this row)

Fund (if fund is classified as Y than in this row)

Fund (if fund is classified as Z than in this row)

How can we achieve that, will using structure help?

Thanks again