Can I find out which invoices are matched to a PO?

Answer Posted / ir

To find Invoices(more then one) to a particular PO going by
screen would be tedious.

This can be done by a simple SQL on AP_INVOICES_LINES_ALL
where po_header_id is equal to the PO in question. This
should list all the invoice lines.

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

We are running Oracle EBS 11i and yesterday whilst doing my month-end I forgot to select "calculate finance charge" on form ARXSUPST AR Print Statement run. I am struggling to get to My Oracle and was hoping someone out there might have experienced or heard of a similar problem. What are my options to rectify this situation... I look forward to you inputs..... Thank you Regards Salie

2158


what is the difference between before pages trigger and after parameter trigger in reports ?

1958


Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i need SQL to get badeget balance Acutal Balance Encumbrance Balance fund Avalable thanx ahmed

1617


What is the use of mo: security profile, while configure multiorg?

616


Hi guys, any person available ap,ar material pls send me this mail.id sreenathapps09@gmail.com

1435






What is Work Flow of AP,AR, Sales & Purchase

2001


difference between tds and income tax (India)

1376


what is VAT claim process?

2105


Explain Customization process?

1497


On what different real time issues you worked while doing P2P cycle implementation?

1011


When we run a GL Reconciliation Report, we also see the void payments in that report. Even though i disable the option of Show Void payments, its appearing in the report.How do i proceed so that i dont see those void payments in the GL Reconciliation Report?

2462


What is the Process of Reconciliation Between AP to GL

1165


What is the db number of a particular customer TCA?

930


We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?

1565


How to support projects life cycles details?

672