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, Simple and Absolutely Free.

Thread Rating:
  • 24 Vote(s) - 3.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
online GL Account Analysis inquiry
#1
is there any online inquiry that displays all transactions against a single Account Code Combinition e.g. 01.110.6160.1400.110 and during a specific period e.g. between 01-JAN-2010 to 14-APR-2010?

Further, is there a drill down available in this Form which takes us to the source transactions from AP/AR/FA/INV etc.

Is there any standard Form / Report available, without any customization?
Reply
Thanks given by:
#2
you can try below option for online enquiry
1) Use General Ledger Super User resp.
2) Go Inquiry --> Account
3) Mention the date in Accounting Period From & To date
4) Mention the a/c detials
5) You can see balances/journal details of this a/c for the above period

Hope this will help



Reply
Thanks given by:
#3

You can, use Account Analysis and Drilldown function
Reply
Thanks given by: socadepaido


Possibly Related Threads...
Thread Author Replies Views Last Post
  Change bank account for supplier payment Danuj Ganesh 2 1,238 10-05-2016, 05:20 PM
Last Post: waelmadj
  Want to add different suppliers as Primary Account Owners Ryan Adam 1 861 05-24-2015, 03:55 PM
Last Post: Zishan Ali
  How t query AR on Account Receipts Mukhtar Ali 1 1,611 02-01-2015, 08:03 PM
Last Post: Gopal Ayog
  how to define summary account Ali Rizwan 3 1,016 01-15-2015, 06:17 PM
Last Post: Ali Rizwan
  Unable to find end date for bank account Balin Chakra 1 786 01-02-2015, 12:39 AM
Last Post: M Irfan
  Customer and customer account should create automatically from Supplier Emily Sarah 1 865 12-04-2014, 07:36 PM
Last Post: Saleem Akhtar
  Retained earnings should be a balance sheet account Archita Jartin 1 2,160 09-02-2014, 06:21 PM
Last Post: M Irfan
Question Purpose of translation adjustment of account in oracle r12. Divya Omkar 2 1,211 07-23-2014, 09:19 PM
Last Post: Divya Omkar
  Change FA clearing account Kashif Manzoor 2 7,632 05-31-2011, 05:31 PM
Last Post: shirfanarshad
  Capital Lease Analysis - Fixed Assets admin 0 5,609 12-16-2010, 08:13 PM
Last Post: admin



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!