Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Jim Sturgess
    What table joins required to link PO Receipts to GL lines in...
    Topic posted April 12, 2018 by Jim Sturgess, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, OBI Answers, OBIEE Answers 
    1179 Views, 2 Comments
    Title:
    What table joins required to link PO Receipts to GL lines in Data Model?
    Summary:
    Need to Extract GL lines with PO Receipt details, PO Number with Data Model
    Content:

    Hello,

    We are trying to create a custom GL Report that will show subledger details for GL lines posted from either the AP or Procurement subledgers.  We have developed a query that returns the AP Invoice details for the GL lines posted from AP, however we have been unable to determine what tables and joins are required to link a GL line that came from a PO Receipt.  We would like to provide the PO number for that receipt as part of the GL report.

    Can anyone tell us what tables and joins are required to join GL_JE_Lines to the PO Receiving tables?

    Thanks,

    Comment

     

    • Gerald Goodbody

      Receipt Accounting is the subledger application that creates accounting distributions and posts through to GL for PO receipts.  Taking a look at this navigation to see if it will help...

      Navigator > Reports and Analytics

      Select: Shared Folders… Supply Chain Management… Cost Management… Receipt Accounting

    • Zlatko Alvir

      Hello 

      please take a look at:

      https://cloud.oracle.com/opc/saas/datasheets/subledger-accounting-reporting-account-analysis-reports.pdf

      zlatko