Sunday 10 December 2017

What is the importance of Auto Allocate flag



Enable: After picking automatically pick wave move order generated and material will be automatically moved from source sub inventory to the staging area.
Disable: After picking pick wave move order generated but manually move stock from source sub inventory to the staging area.

What is the importance of Auto create delivery flag



Enable: After picking automatically delivery numbers generated.
Disable: After picking manually delivery numbers has to be generated.

query to find between Internal Requisition and internal sales orders



  SELECT   OOH.ORDER_NUMBER SO,

           OOH.ORDERED_DATE,

           OOH.ORG_ID,

           PRH.SEGMENT1 REQ

    FROM   OE_ORDER_HEADERS_ALL OOH,

           PO_REQUISITION_HEADERS_ALL PRH,

           PO_REQUISITION_LINES_ALL PRL

   WHERE   1 = 1

           AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID

           --AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

           AND PRH.REQUISITION_HEADER_ID = OOH.SOURCE_DOCUMENT_ID

           --AND ORDER_NUMBER = '66534' --SALES ORDER NUMBER

           AND PRH.SEGMENT1 = '300059130'-- REQUISITION NUMBER

           AND PRH.TYPE_LOOKUP_CODE = 'INTERNAL'

   ORDER BY   OOH.ORDERED_DATE DESC

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.