What is difference between Rollup Groups and Summary Accounts?
What is the use of those?
Regards
Nagesh
Rollup Groups and Summary Accounts
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
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
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
Who is online
Users browsing this forum: Semrush [Bot] and 0 guests