Financials – General

Get Involved. Join the Conversation.

Topic

    Koteswararao Yenikepalli
    Sql Script to get the invoices status from the invoice...
    Topic posted June 11, 2019 by Koteswararao YenikepalliSilver Medal: 2,000+ Points, tagged Financials, Help Center, Invoice Imaging, Payables, Reports, Sample Reports, Subscriptions, Tip 
    126 Views, 1 Comment
    Title:
    Sql Script to get the invoices status from the invoice validation hyperlink
    Summary:
    Sql Script to get the invoices status from the invoice validation hyperlink
    Content:

    We have written the SQL query(Seeded Means package) to get the status of the invoice either it is accounted or unaccounted or paid or unpaid or approved or workflow approval but some time that package is not giving the correct results 

    Anyone come across this kind of situation please guide me to get the correct values here I have attached the screen to what are the fields I am looking for 

     

    Thanks,

    Koteswararao.

    Version:
    19A
    Image:

    Comment

     

    • Sudhakara Rao Kovuru

      Hi Koteswararao,

      You can try with below tables/package to get those details.

      ap_inv_aprvl_hist_all
      ap_lookup_codes alc 
      ap_invoices_utility_pkg.get_approval_status(aia.invoice_id,
                                                              aia.invoice_amount,
                                                              aia.payment_status_flag,
                                                              aia.invoice_type_lookup_code)

      Thanks,

      -Sudha.