Sunday 20 August 2017

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