Balance Sheet Grouping

[neetu_singh]

Dear All,

I have a query, i want to create a group for Balance Sheet in Finance Module but that grouping should be dynamic. As, i m having ledger code and ledger description. Example:

LdgrCode LdgrName

10000 A

10001 B

10002 C

11000 D

11001 E

It means "B and C" are sub group of A and "E" is the sub group of D. then, how we can create that grouping dynamically.

If anyone know the solution. please reply me ASAP. its urgent

Thanks in advance

Regards

Neetu Singh

[tresesco]

Hi mam'm,

Please have look at attached application. Hope the logic would help you.

Thanks & regards,

tresesco

[neetu_singh]

Hi Tresesco,

Thanks for your reply but my problem is something different. I attached a test application which help you to understand the scenario.

So, Please have a look on that. i am very thankful to you if you are able to sort out.

Thanks

Neetu Singh

[tresesco]

Hi,

As far as i have understood, you need another recursion (Group->SubGroup->Desc). Please find the modified application. The proper use of string functions would give you the desired result i believe.

Thanks..

[#5 · Accepted solution]

Hi Neetu,

I think to achieve this you should have the parent code in the transactions.

LOAD * INLINE [
LedgrCode, Name, ParentCode
110000, Land,
110250, Owned Land, 110000
110260, Owned Land, 110000
110270, Additional OL, 110250
110280, Deletion OL, 110250
];

To make a result set as requested. After that you can use hierarchy function to create the same hierarchy as you need for this balance sheet.

Hope it iwll help you.

Regards,

Raj Kishor

[neetu_singh]

Hi Raj,

Thanks.

[#7]

Hi

I am trying to create the following look from my table. These two columns are available and properly populated as parent and child. How can I get this look?