Oracle Purchasing - Version 11.5.10 to 12.1[Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 10-Jun-2013***
What are the steps required to utilizethe functionality provided by advanced pricing in Requisitions and PurchaseOrders ?
This note is designed to explain the steps to apply price lists and modifiersto purchasing documents and to provide sample data from a Vision environment tofacilitate testing.
Login tothe application using the username/password combination cbaker/welcome and thennavigate to the System Administrator responsibility. Open the System Profilesform and then query using both the application and profile criteria as shown inthe following screenshot :
In order to utilize advanced pricing with the purchasing application, the valueof the profile option must be set as shown :
Navigate to the Purchasing Responsibility : Purchasing Vision Operations (USA)and open the Item Master form. Select the copy from feature from the Tools menuas shown below :
Select the Item CM96713 as the Item from which the data is to be copied as seenin the following screenshot :
Click the Done button and then choose a name for the newly created item. Go tothe purchasing tab to the Purchasing tab to confirm that the item ispurchasable. Also note that the item list price (which should default on allpurchasing documents) is 0.006 as seen in the following screenshot :
The next step of the required setup is to create a Contract Purchase Agreementwhich will later be linked to the item ASL entry. To do this, navigate to thePurchase Orders form and enter a new Contract as seen below :
Approve the Contract and then navigate to the Sourcing Rules form and createanew rule for the item using the seeded supplier and site shown below :
The newly created Sourcing Rule can now be assigned to the Item using theSourcing Rule Assignments form as seen in the following screenshot :
Navigate to the Approved Supplier List form and create a new entry for the itemassociating it to the same supplier and site as show below :
Click the Attributes button and select the approved Contract created earlier asshown in the following screenshot :
Navigate to the Price Lists form under the Advanced Pricing menu and create anew price list entry. Specify the Item as shown below :
Specify a new Item price in the price list :
The price specified on the price list should take precedence over the listprice defined in the Item Master form. To test this, navigate to theRequisitions form and create a new Purchase Requisition and select the Itemfrom the LOV. The supplier/site specified in the sourcing rule shouldautomatically default and the price should default from the price list as shownbelow :
Navigate to the Source Details tab to confirm that the Contract linked to theApproved Supplier List has been linked to the Requisition as seen in thefollowing screenshot :
Purchase Orders work a little differently. Navigate to the Purchase Orders formand create a new Standard Purchase Order for the same supplier and site.
Select the Item and notice that the price does not default from the price listand instead defaults from the Item Master form as shown below :
This happens because the Contract information does not automatically default onto the Purchase Order.
Go to the Reference Documents tab and manually associate the Contract as shownin the following screenshot :
Now navigate back to the Line tab and the price has been correctly updated fromthe price list as shown below :
Modifiers can also be used to modify the Item price on the price list by addinga surcharge or discount to the original price. To add a surcharge, navigate tothe Modifiers form and specify the modifier and pricing phase as shown below :
Specify the amount of surcharge to be added to the original price as shown inthe following screenshot :
Note that no qualifier has been chosen for this modifier which means that thesurcharge specified will be applied to all items being purchased. In order tocontrol which conditions cause the surcharge to be applied (eg specific Itemsonly), a Line Qualifier would need to be created for this Modifier.
To test that the surcharge is applied correctly, create a new PurchaseRequisition and select the Item as shown below :
The price that defaults for the item is the price from the price list inaddition to the surcharge defined in the modifier.