8 Replies Latest reply on Jul 19, 2011 6:31 PM by Sandeep Gandhi, Consultant

    link from ap_invoices_all to inventory tables

    user11969650
      Hi all,

      I want to get the invoice number from ap_invoices_all table to show the items against each invoice taken into inventory.

      I am using the below tables in my report to get the data.
      mtl_material_transactions+
      rcv_transactions+
      rcv_shipment_headers+
      po_vendors+
      po_headers_all+
      mtl_parameters+

      Here I am not get the join for ap_invoices_all and the inventory table.. Please help me out

      Thanks