Rollup Groups and Summary Accounts

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
nagesh
Posts: 35
Joined: Sun Oct 28, 2007 4:27 am
Location: India

Rollup Groups and Summary Accounts

Post by nagesh »

What is difference between Rollup Groups and Summary Accounts?
What is the use of those?

Regards
Nagesh
SIVAKUMAR_G
Posts: 194
Joined: Tue May 15, 2007 7:45 am
Location: United Arab Emirates

Post 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
nagesh
Posts: 35
Joined: Sun Oct 28, 2007 4:27 am
Location: India

Post by nagesh »

Thanks

Siva Kumar

Regards

Nagesh
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 0 guests