Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Lana Barei
    Paid Status for invoices
    Topic posted July 10, 2019 by Lana Barei, tagged BI Publisher, Fusion Financial reporting, Reports 
    141 Views, 5 Comments
    Title:
    Paid Status for invoices
    Summary:
    Looking for the table that holds the field displaying the Paid Status for invoices
    Content:

    Hi,

    I am looking for the Oracle table that has the field that displays the Paid Status on the Payment window. There is a payment_status_flag in the ap_payment_schedules_all table but I am not sure if this is the correct one.

    thanks,

    Lana

    Image:

    Comment

     

    • Vishnu Singireddy

      Hi,

      Use the column PAYMENT_STATUS_FLAG from ap_invoices_all table join with AP_LOOKUP_CODES

    • Sudhakara Rao Kovuru

      Hi,

      You need use like below

      SELECT Decode(aia.payment_status_flag, 'Y', 'Fully Paid', 
                                             'N', 'Unpaid', 
                                             'P', 'Partially Paid') INVOICE_STATUS 
      FROM   ap_invoices_all aia

      Thanks,

      -Sudha

    • Sudhakara Rao Kovuru

      This will also works

      SELECT Decode(aia.payment_status_flag, 'Y', 'Fully Paid', 
                                             'N', 'Unpaid', 
                                             'P', 'Partially Paid') 
             INVOICE_PAYMENT_STATUS, 
             displayed_field 
             INVOICE_PAYMENT_STATUS 
      FROM   ap_invoices_all aia, 
             ap_lookup_codes alc 
      WHERE  aia.payment_status_flag = alc.lookup_code 
         AND lookup_type = 'INVOICE PAYMENT STATUS' 

    • Lana Barei

      thank you so much for the help!!

    • Sudhakara Rao Kovuru

      Resolve the case if you satisfied with it?