My Portfolio

Query To Get PO Number, Invoice Number and Receipt Number With one of the Input SELECT distinct pha.segment1 po_number        ,aia.invoice_num invoice_number        ,rsh.receipt_num receipt_number   FROM po_headers_all pha        ,po_distributions_all pda        ,ap_invoice_distributions_all aid        ,ap_invoices_all aia        ,rcv_shipment_lines rsl        ,rcv_shipment_headers rsh  WHERE pha.po_header_id=pda.po_header_id    AND aid.po_distribution_id=pda.po_distribution_id    AND aia.invoice_id=aid.invoice_id    AND rsl.po_header_id=pha.po_header_id    AND rsl.shipment_header_id=rsh.shipment_header_id    AND pha.segment1=nvl(:P_PO_NUM,pha.segment1)    AND aia.invoice_num=nvl(:P_INVOICE_NUM,aia.invoice_num) ...

Invoice Matching functionality To answer some common questions surrounding Invoice Matching functionality. Questions and Answers I Am Very Confused By Invoice Matching And Don't Really Understand It. Where Can I Find An Overview Of The Process To Help Me Get Started? A: Please review Doc ID 1441364.1 - which is a white paper on Invoice Matching that includes screenshots and helps you understand the basics. The Payables User Guide also contains a lot of more detailed specific information on this topic. How Can I Find Out Which Invoices Are Matched To A Purchase Order? A: In Payables, run the Matching Detail Report from Other > Request > Run. This report will show you detail of how an invoice, purchase order, or receipt was matched. This report is especially helpful when an invoice is on hold and you are trying determine why the hold was placed. What Reports Are Available To Check If A Credit Memo Is Matched To An Invoice? A: In Payables, run the Credit Memo Matching Report fro...

Table relationships between PO tables and rcv_transactions and rcv_receiving_sub_ledger remain the same as in R11i. The following reference fields are used to capture and keep PO information in RCV_RECEIVING_SUB_LEDGER REFERENCE1 Source (PO or REQ) REFERENCE2 PO Header ID or Requisition Header ID (from po_headers_all.po_header_id or po_requisition_headers_all.requisition_header_id) REFERENCE3 Distribution ID (from po_distributions_all.po_distribution_id or po_req_distributions_all.distribution_id) REFERENCE4 Purchase Order or Requisition number (from po_headers_all.segment1 or po_requistion_headers_all.segment1) REFERENCE5 (Autocreated Purchase Orders only) Backing requisition number (from po_requisition_headers_all.segment1) RCV_TRANSACTION_ID Receiving transaction unique identifier (from rcv_transactions.transactions_id) The receiving package that populates this table is RCV_CreateAccounting_PVT (RCVVACCB.pls) Release 11i Mapping Ref Note.461103.1 - Mapping Between PO Tables And Gene...