1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Account Analysis Report (Subledger Accounting)

Discussion in 'Oracle Financials' started by tomloera, Oct 20, 2011.

  1. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hi Friends;

    Anything help me in the next question;

    How I can link the information of the table GL_JE_LINES with the AP o AR module?

    I generate the report "Account Analysis Report" and have the column 'Trasaction Number' in the case of the AP have the number of the check of payables to provider and the case of the AR have the receive number of the customer.

    I want development a simple report with sql query but not fund how link the table GL_JE_LINES with the AP Invoice or Schedule Invoice or Checks

    ¿Anything working in similar report?

    Thanks a lot by your help

    Regards
    Tomas
     
  2. jasongschwartz

    jasongschwartz Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Vienna, VA
    Tomas,
    Your post is nearly 5 years old, but I have nearly the same question.
    Running Oracle Fusion Cloud....and cannot get to tables that easy.
    Trying to find SQL for a report or link.
    Let me know if you ever found an answer.


    Thank you.
    Jason
    jschwartz@myeyedr.com