2 Replies Latest reply on May 6, 2011 7:35 AM by santhosh177230

    How to see Sales Order Number on Back to Back PO

    643670
      We are implementing Back to Back to generate a Purchase Order from a Sales Order.

      Everything is working well except I can't find the sales order number on the PO and can't find if for the receipt.

      We want the item when received to be marked for the SO it is for?

      Ideas?

      Jean
        • 1. Re: How to see Sales Order Number on Back to Back PO
          User259662
          Please answer this
          Is this functioanlity avalable in oracle currently?
          I dont think we can see Corresponding SO in a PO for Back to back order.

          Thanks
          Pankaj

          Edited by: 856792 on May 5, 2011 5:21 AM
          • 2. Re: How to see Sales Order Number on Back to Back PO
            santhosh177230
            Hi,

            You can get the PO # for corresponding Sales order by using table (OE_DROP_SHIP_SOURCES).

            u can join the po_header_id (OE_DROP_SHIP_SOURCES) with po_header_id (PO_HEADERS_ALL).


            Hope this will help you

            Thanks
            --Sandy.