Difference between Drop Ship and Back to back

Drop Ship	Back to Back
Shipping Source --> External	Shipping Source --> Internal
Vendor is responsible for shipping	company is responsible for shipping
Inventory is not affected	Inventory is affected
Logical Receipts	Physical Receipts
Interaction b/w customer & supplier	No interaction b/w customer & supplier

Query to find out the Requisition and PO number from Order Number in B2B Order?

SELECT   DISTINCT OOHA.ORDER_NUMBER,

                  OOHL.LINE_NUMBER,

                  PRHA.SEGMENT1 REQUISITION_NUMBER,

                  PRLA.LINE_NUM REQUISITION_LINE_NUMBER,

                  PHA.SEGMENT1 PO_NUMBER,

                  PLA.LINE_NUM PO_LINE_NUMBER

  FROM   OE_ORDER_HEADERS_ALL OOHA,

         OE_ORDER_LINES_ALL OOHL,

         PO_REQUISITION_HEADERS_ALL PRHA,

         PO_REQUISITION_LINES_ALL PRLA,

         PO_REQ_DISTRIBUTIONS_ALL PRDA,

         PO_DISTRIBUTIONS_ALL PDA,

         PO_HEADERS_ALL PHA,

         PO_LINES_ALL PLA

 WHERE   OOHA.HEADER_ID = OOHL.HEADER_ID

         AND PRHA.INTERFACE_SOURCE_LINE_ID = OOHL.LINE_ID

         AND PRHA.REQUISITION_HEADER_ID = PRLA.REQUISITION_HEADER_ID

         AND PRLA.REQUISITION_LINE_ID = PRDA.REQUISITION_LINE_ID

         AND PRDA.DISTRIBUTION_ID = PDA.REQ_DISTRIBUTION_ID

         AND PDA.PO_HEADER_ID = PHA.PO_HEADER_ID

         AND PHA.PO_HEADER_ID = PLA.PO_HEADER_ID

         AND ooha.order_number = '10128192'

setups required for back to back sales order

Shipping source --> Internal

ATO Flag required

List price required

Purchasable, customer orders, shippable flags need to be enabled

Describe the header and line status during the Back to Back order?

Entering the sales order                                     Entered (Header)

                                                                           Entered (Line)

Booking the sales order                                     Booked (Header)

                                                                           Supply Eligible (Line)

Progress order à Create supply order eligible    Booked (Header)

                                                                            External req requested (Line)

Run Requisition import                                       Booked (Header)

                                                                           External Request open (Line)

Auto Create Purchase order                              Booked (Header)

                                                                           PO Open (Line)

Create Receipt for PO                                        Booked (Header)

                                                                           Awaiting Shipping (Line)

 

Back to Back order Cycle?

• Create a sales order and book the sales order.
• Right Click --> Progress order  --> Create supply order eligible.
• Run ‘Requisition import program’ from purchasing resp by selecting import source as --> CTO.
• Based on the generated requisition auto create purchase order and get the approvals for the PO.
• Receive the material against PO.
• Pick & ship the material to the customer.

Setup Required for Dropship?

Shipping source a External

List price required

Purchasable, customer orders flags need to be enabled

Logical Sub Inventory Required to perform logical receipts