SQL gives me wrong purchase order number for invoice
Content
Hi,
When I go into the front end of Fusion, I can see that an invoice number of 26427 only has 1 purchase number matched against it which is PO 911753
When I do the following code, it gives me a PO of 90883 and 909615 which is wrong
SELECT DISTINCT pha.segment1FROMap_invoices_all aia, -- AP_INVOICES_ALL contains records for invoices you enterpo_headers_all pha, -- PO_HEADERS_ALL contains header information for your purchasing documents. You need one row for each document you create.XLA_TRANSACTION_ENTITIES xte -- This table contains a row for each transaction for which events have been raised in Subledger Accounting.
Tagged:
1