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

what is VAT claim process?

2109


What is Difference between Auto Copy Journal and recurring journal?

1306


What is the Use of Grouping Rule in Receivables ? is it mandatory field ?

1056


What is multi org? What is difference between 11i and 12i multi org structure?

652


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

1622






I am created credit memo in at but while trying to complete it showing error message-hz_party_location

968


can we define 2 different currency revaluation at a time??

1906


Can I do a payment of 50 bills on a post date. If yes, then how?

1324


difference between 11i&r12

1457


Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues

1265


I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.

1136


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

1962


difference between tds and income tax (India)

1380


How to support projects life cycles details?

674


How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?

2317