Wednesday 23 July 2014

Few Questions & Answers on Internal Sales Order Generation


Why is the Error message found: 'Destination location requires customer association'
The reason for this error is that the code is trying to match the Location that is currently entered on the form to a customer, and the customer association is not found. The solution to this error is to setup the employee record to default a location that was associated with the customer (Internal Requesting Org) or prior to entering the item, move to the destination section of the form and enter an inventory organization and location that is properly assigned to the customer.

Why the Shipping Inventory Organization is not showing the inventory organization which was setup in the shipping networks?
If the internal requisition is going to be for a cross operating unit scenario - then it should be noted that the HR: Security Profile is used.
Both operating units for which the inventory organizations belong to must exist in the HR: Security Profile.

How can the interface data for Internal Requisitions be viewed in the Order Management Module?
Navigate to Order Management Responsibility > Orders>Import Orders>Corrections
  • Choose an order type of Internal
  • In Order Reference use the List of Values to locate the Requisition Number
  • If the Requisition is not located - it has either been created into a Sales Order or not inserted into the tables by the Create Internal Orders program
When Running the Create Internal Sales Order Process - it completes with Success but no records are inserted into the Order Management Interface Tables? 
When the internal requisition is created the code needs to validate that the customer was created in the Operating Unit that the Source Inventory Organization belongs to. When the Create Internal Sales Order process runs, if the Deliver to Location is not tied to a Customer Ship To Site in the Operating Unit of the Source Inventory Organization used on the requisition - then it will not insert data into the oe_headers_iface and oe_lines_iface table.

Does the Purchasing Create Internal Orders process pass flexfield values from the Purchase Requisition?
Currently, the Create Internal Orders process does not pass any flexfields values from Requisition.

Can the price be updated adjusted during the Order Import?
The calculate price flag is frozen and the price cannot be changed.

Where is the schedule Ship Date coming from?
The scheduled ship date is passed from the requisition Need By Date, it cannot be defaulted any differently.

How is the Order Type being chosen for an ISO?
Order Type is chosen from the Purchasing Options - 
Purchasing Super User Responsibility > Setup > Organizations > Purchasing Options.

Saturday 19 July 2014

Short notes on Internal Sales Order Setup

Short notes on Internal Sales Order Setup

  • Item attributes - Internal Ordered, Internal Order enabled, Customer Ordered, Customer Order Enabled, Shippable, OE Transactable, Purchased & Purchasable should be enabled for an item
  • Create Shipping Network between the Requesting & Sourcing Organization
  • Transfer Type – Direct / Intransit to be selected based on the requirement

Direct - When the ISO is shipped from the source org and the receipt process in the requested org is done automatically
Intransit - When the ISO is shipped from the source org and the requested Org has to manually do the receipt process in Purchasing
  • Create the Internal Location for the Requesting Organization
  • Create the Internal Customer for the Requesting Organization in Sourcing Operating Unit
  • Assign the Internal Location to the Internal Customer
  • Purchasing Option for both Requesting & Sourcing Operating Units to defined
  • Internal Order type to be defined in Purchasing Option
  • Though price is calculated from Item cost for ISO, price to be defined for the item in the Price list which is already defined in Internal Order Type
  • Create Internal Requisition
  • After Approval process, Submit the Create Internal Orders Concurrent Request
  • Submit the Order Import Concurrent Request
  • Query the Order organiser with Order Source as Internal to check the ISO


Further Shipment from Sourcing Org and receipt at Requesting Org against the created ISO.