2 Replies Latest reply on May 27, 2009 2:41 PM by 578444

    PO issue

    user550686
      hey

      can anyone let me know how can i join a PO to the invoice and receipts from apps tables.I mean what are all the joins we required and between which tables.

      Thanks
        • 1. Re: PO issue
          641947
          Pls check
          po_distributions_all table.
          • 2. Re: PO issue
            578444
            Hi,

            You need to join the following table.

            po_headers_all (Get/pass the PO Number)
            po_distributions_all ( Get the quantity Received/quantity invoiced)
            ap_invoices_all (Get the Invoice_num)
            ap_invoice_distributions_all (join this table with po_distributions_all table so as to get the exact quantity matched & invoiced)
            rcv_shipment_headers( get the receipt number)
            rcv_transactions ( Get the receipt transactions)

            Please try to join these tables to form your query as per your requirement & let me know if you are still facing any issue

            Regards,
            Jyoti