-->

Tuesday, October 10, 2017

How to Update Sales Order Quantity for an Internal Sales order

This tutorial will explain the steps on how to update the sales order quantity for internal sales order 


In this blog i will walk you through the newly available feature as a part of standard feature. 


Note - This blog will not cover End to End Internal Sales Order Cycle


Without configuring the setups if user tries to update the Sales Order quantity system wont allow to update the quantity and will throw an error stating "This is an internal order you cannot update the quantity"


In order to understand the feature completely this blog is divided in three parts
  • First Part - Checking Existing Transactions (Internal Requisition & Internal Sales Order) for Quantity
  • Second Part -  Setup configuration in system
    • Updating the Processing Constraints
  • Third Part - Updating the Existing Transactions (Internal Sales Order) for Quantity 
  • Fourth PartChecking Existing Transactions (Internal Requisition) for Quantity


First Part - Checking Existing Transactions (Internal Requisition & Internal Sales Order) for Quantity

Select the Purchasing Super User Responsibility 

Navigate - Oracle Purchasing -->Requisitions-->Requisitions Summary


Query the Internal Requisition 

Internal Requisition - Header Level


Update Internal Sales Order Quantity


Internal Requisition - Line Level


Update Internal Sales Order Quantity


Please note here the Internal requisition approved was with quantity as 150


Now query the existing Internal Sales order created 


Navigation - Order Management Super User-->Order, Returns-->Sales Orders 

Internal Sales Order - Header Level


Update Internal Sales Order Quantity

Internal Sales Order - Line Level


Update Internal Sales Order Quantity


Second Part -  Setup configuration in system

  • Updating Processing Constraints 

Select the Order Management Super User Responsibility 

Navigation - Oracle Order Management -->Setup-->Rules-->Security-->Processing Constraints 

Update Internal Sales Order Quantity


Click on the open button


Update Internal Sales Order Quantity


Select the application as Order Management and Entity as Order Line


Update Internal Sales Order Quantity


Query until you find the Operation Update in the Constraints block and Validation Template as Internal Order under the Conditions block


Update Internal Sales Order Quantity


Now user has to Uncheck the Enabled check box and save the form

  
Update Internal Sales Order Quantity


Third Part - Updating the Existing Transactions (Internal Sales Order) for Quantity 

Query the Existing Sales Order

Navigation - Order Management Super User-->Order, Returns-->Sales Orders 

Internal Sales Order - Header Level


Update Internal Sales Order Quantity


Internal Sales Order - Line Level


Update Internal Sales Order Quantity

Note - Here we will update the Sales Order Quantity to 200 

Save the form 

System will prompt with the message as shown below 

Update Internal Sales Order Quantity


Prompt Message - Ordered Quantity, Supply Picture and corresponding internal requisition line have been updated

Now requery the Internal Requisition 

Navigation - Purchasing Super User-->Requisition-->Requisition Summary 

Update Internal Sales Order Quantity

Here with the configuration done in processing constraints shown above users will be able to update the quantity in the Internal Sales Orders and automatically the Internal Requisition quantity will get updated inline to the Internal Sales Order changes. 

We have achieved the standard functionality without performing any typical adjustment transaction.

No comments:

Post a Comment

Thanks for your valuable comments it encourages me further !!!!!!!!!!


About Author


Hello Friends, By profession i am Supply Chain (SCM) Functional Consultant into Oracle domain. I am not a regular blogger but believe in sharing knowledge. I believe learning is a never ending journey throughout our life and in regards to me this blog is a perfect example. I started this blog to share my learning in field of Oracle Application.

I do posses skills of writing poems to read my poems please do visit and like my blog Maaze Shabd

Let's Get Connected:- Twitter | Facebook | Google Plus

Followers

Join us for Free Oracle SCM Tutorials
Sociliaze with Us

©2017,All rights reserved.

Oracle SCM Functional Guide. is an online knowledge sharing blog which provides online free knowledge on oracle applications functionality. This blog has been created keeping only one intention of sharing knowledge and for learning purpose only. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Prasad Pakhare.