You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL gives me wrong purchase order number for invoice

Received Response
27
Views
5
Comments
edited Oct 29, 2019 6:56PM in Reporting and Analytics for ERP 5 comments

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.segment1
FROM 
ap_invoices_all aia, -- AP_INVOICES_ALL contains records for invoices you enter
po_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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!