Here we will learn how to change the price of the item by formula.The formula here would be some calculation based on the Client requirement.
Like adding some tax to the actual Item price.
For instance if Item A price is 10$, the requirement is like make it 12$ by adding the Tax.
This can be accomplished by doing the following steps.
1) There is a package QP_CUSTOM, which is a Oracle standard package, modify it and add the formula there for calculating the New price.
2) return the price as the parameter.
3) Navigate to Order Management Super User and create a new Pricing Formula and the Component Should be "Get Custom Price"
4) Create a new price list and attach the New Formula to the Price List, also check the Item where the price list need to be affected.
Like adding some tax to the actual Item price.
For instance if Item A price is 10$, the requirement is like make it 12$ by adding the Tax.
This can be accomplished by doing the following steps.
1) There is a package QP_CUSTOM, which is a Oracle standard package, modify it and add the formula there for calculating the New price.
2) return the price as the parameter.
3) Navigate to Order Management Super User and create a new Pricing Formula and the Component Should be "Get Custom Price"
4) Create a new price list and attach the New Formula to the Price List, also check the Item where the price list need to be affected.
No comments:
Post a Comment