Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Barbara Harvey
    Date an Invoice is Accounted (Posted to the GL)
    Topic posted April 25, 2019 by Barbara Harvey, tagged BI Publisher, Fusion Financial reporting, Reports 
    94 Views, 3 Comments
    Title:
    Date an Invoice is Accounted (Posted to the GL)
    Summary:
    Date an Invoice is Accounted (Posted to the GL)
    Content:

    I need to build a BI Publisher report for accounted invoices that includes the date an invoice was accounted.  I'm aware that I can use AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID) = 'Y' to determine if an invoice is accounted.  Is there a similar package/API to get the date an invoice is accounted?  If not, what table stores this date?

    Comment

     

    • Ramesh Nayak

      Hi Barbara,

      In the below table column name GL_DATE is nothing but invoice accounted date.

      AP_INVOICES_ALL

      I hope this will help you.

      Thanks and Regards,

      Ramesh

    • Barbara Harvey

      Hi Ramesh,

      Thank you for responding.  I'm not able to use AP_INVOICES_PKG.GET_POSTING_STATUS because it causes the SQL run time to exceed the limit.  Is there a table that stores the posting status of an invoice?

      Thank you.

      Barbara

       

    • Soumya Parhi

      Hi Barbara,

      Then you need to consider the XLA tables that will definitely cost more as compared to AP_INVOICES_PKG.GET_POSTING_STATUS .

      Thanks,

      Soumya