Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 8 Vote(s) - 2.63 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to define summary account
#1
Hello guys,
I want to define summary account template. For example, if I want to have summary account by each of expense account only (not include the account type Asset, Liability, Equity and Revenue)? How can I define….?

 
Reply
Thanks given by:
#2
Please proceed as 

-Define the Rollup Groups for Natural Account value set by following steps
      - Follow the Nevigation Gl Setup-->Financials-->Key Flexfields-->Key-->Groups
      - Through Group Function a Query WIndow will open provide your relevant info. of Application: General Ledger, Title: Accounting FlexField, Structure: Your GL Accounting Flexfield Name, Segment: Account  and reach to Rollup Group Screen.
        - Give Code, Like Capex, Opex etc
        - Enter name and description
  - Then assign these rollup groups to your relevant Parent Values in Natural Accounts Value Set. One rollup Group for one parent.

- Define the Summary Accounts on Following Nevigation -- Gl Setup-->Financials-->Accounts-->Summary

- Then  On Summary Accounts screen in Template field all the segment of Accounting Flexfield will open. Provide the value as
          - Select D- for all Segments except Account segment
          - Select Rollup Group Name in each line for Account Segment.
          - Provide Budgetray Control as per flexibility of your business operations like below

                - Absolute :  for Capex Line
                - Advisory: for the Opex Line
                
If you still find any problem please write. thanks
 
Reply
Thanks given by:
#3
i am agree with above ans because it is better you need to create Rollup Group for every expense account as compare to go another way.
Reply
Thanks given by:
#4
Thanks for your ans.its very helpful.
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Change bank account for supplier payment Danuj Ganesh 2 1,363 10-05-2016, 05:20 PM
Last Post: waelmadj
  Want to add different suppliers as Primary Account Owners Ryan Adam 1 928 05-24-2015, 03:55 PM
Last Post: Zishan Ali
  How t query AR on Account Receipts Mukhtar Ali 1 1,931 02-01-2015, 08:03 PM
Last Post: Gopal Ayog
  Unable to find end date for bank account Balin Chakra 1 857 01-02-2015, 12:39 AM
Last Post: M Irfan
  Customer and customer account should create automatically from Supplier Emily Sarah 1 942 12-04-2014, 07:36 PM
Last Post: Saleem Akhtar
  Retained earnings should be a balance sheet account Archita Jartin 1 2,405 09-02-2014, 06:21 PM
Last Post: M Irfan
Question Purpose of translation adjustment of account in oracle r12. Divya Omkar 2 1,304 07-23-2014, 09:19 PM
Last Post: Divya Omkar
  Steps for define Payables trial balance report in R12 Oracle payables.... sgtakwale 2 19,345 05-12-2013, 09:45 PM
Last Post: shirfanarshad
  Change FA clearing account Kashif Manzoor 2 7,849 05-31-2011, 05:31 PM
Last Post: shirfanarshad
  online GL Account Analysis inquiry Sara Khan 2 5,190 12-12-2010, 11:21 PM
Last Post: nandu



Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!