Invoice and purchase order
Posted: Sun Jun 17, 2007 11:40 pm
While AP_INVOICES_ALL has invoice info, what table can I join with it to get the Purchase order number for the invoice?
Answered my own question with Metalink research:
If invoice is matched to a PO, then the po_distribution_id will be populated in ap_invoice_distributions_all table. po_distribution_id is the link between ap_invoice_distributions_all table and PO_Distributions_All table.