Sunday, 10 December 2017

Mandatory setups for IR ISO Flow



1.      In item master form internal ordered and internal orders Enabled  flag should be enabled and  assigned to both the orgs

2.      List price required

3.      Shipping networks (specify source and destination organization).

4.      Customer ship to location should be destination org location

5.      In the purchasing options attach Internal Order Transaction type

IR ISO Cycle



1.     Create internal requisition from destination organization.

2.     Run ‘Create Internal Orders’ from purchasing responsibility (OE_HEADERS_IFACE_ALL)

3.     Run Order Import Program from order management responsibility from source organization.

4.     Sales Order will be created with the Entered status

5.     Book the sales order.

6.     Pick the material.

7.     Ship the material.

8.     Perform Receipts at destination organization.

Link between OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL interface tables?



SELECT ohi.*
  FROM  oe_headers_iface_all ohi,
  oe_lines_iface_all oli
  WHERE  ohi.orig_sys_document_ref = oli.orig_sys_document_ref
  AND ohi.orig_sys_document_ref = 375768

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