Page 1 of 1

Rollup Groups and Summary Accounts

Posted: Fri Mar 14, 2008 2:52 am
by nagesh
What is difference between Rollup Groups and Summary Accounts?
What is the use of those?

Regards
Nagesh

Posted: Fri Mar 14, 2008 3:33 am
by SIVAKUMAR_G
Hi Nagesh

To explain in simple way let us assume you have only three segments
in Key accounting Flexfield

Company Account cost center

Parent Values Mktg Exps 10 1000 100
Child Values Advt 01 0100 010
Travle 01 0200 020
Sales Promotion Exps 01 0300 030

You need to attach a Roll up Group at Parent Level. It is like
attaching a Notional name for your Parent account Say for Account 1000
You attach same code 1000 and create a Roll up Group and attach

Similarly create a Roll up Group 100 and attach it for Cost center

Now in Summary account You can create a Combination of Child Values from one segment and parent values from other segment and generate account inquiry balance

For example in the abve case if you want to know the total marketing expenses for Cost center 020, You can create a Summary Template

Summary Template for CC 020 = 01-1000(Roll up)-020

In account inquiry screen in GL, if you choose the summary Template

You will get the account combination of all the above as follows

01-0100-020
01-0200-020
01-0300-020

By Default in Summary Template you will find two values for each segment as 'D' and 'T'. If you choose "D' it stands for detail. So if you choose 'D' System will bring all child values individually and if you choose 'T' it will bring the total of all child values

This you can do any combination as follows
Co Account Cost Center
Child - Parent - Parent
Parent- child- parent
parent-parent-child
child-child-parent
child-parent-child
parent-child-child

Hope this helps

Regards
Sivakumar

Posted: Fri Mar 14, 2008 4:28 am
by nagesh
Thanks

Siva Kumar

Regards

Nagesh