Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Andriy Y
    Query for AP Invoice Liability
    Topic posted March 7, 2017 by Andriy YGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, OTBI, Reports 
    374 Views, 2 Comments
    Title:
    Query for AP Invoice Liability
    Summary:
    queries for AP Invoice Liability
    Content:

    Good afternoon,

    Are there sources for Fusion-specific financial queries  - for instance:

    1. AP Invoice liability, calculating PO, Invoice, and PO Remaining Amount

    2. Subledger GL along with  PO and Invoice information.

    BIP or OTBI.

     

    Thank you

    Comment

     

    • Usman Askofare

      Hi Andriy,

      In OTBI in Payables Real Time Folder there is a Liability Column that can be used, or in BI Publisher you can look for account_type = 'L'

      Bu the Out of the Box, Payables Invoice Register will provide you with the outstanding Total Liability for the Time Frame Requested

      If the Invoice Lines came from the PO Match then the PO Details is on the Invoice Line Level and can be queried either via OTBI or BIP

       

       

    • Andriy Y

      Usman,

      Thank you for your response. I'm actually trying to add PO Amount Remaining and Total PO Amount to Invoice Register report

      Do you know the best way to do it? should i calculate it on the report level with sql - or can I pull it from somewhere ?

      Thank