Price List Concept
A Price list is useful for maintaining the prices and other pricing details of products and services.

• It serves as a repository of items with their related pricing details. You can call up a price list and add/edit/delete related items and item categories.
• You can also use the price list to define attributes for the products, which will then determine the pricing action.

• The pricing engine requires that all items, services, models, option class and options should be selected and displayed on price list.
  
• Fields such as payment terms, freight terms and freight carrier are available on the price list form. By defining the OM defaulting rules to use these fields from the price list window, you are able to default values directly into the SO based upon which price list has been selected for the order.

Price List Form Details

Price List Currency
For international sales, you can record transactions in different currencies by defining a price list for each currency. After entering the currency for an order or return, you must choose a price list in the same currency.
 
Multi-Currency Conversion Lists
For pricing in different currencies, multi-currency conversion lists enable you to maintain a single price list for multiple currencies. However, this is an Oracle Advanced Pricing feature which is available only if Oracle Advanced Pricing is
fully installed and multi-currency lists are enabled.

Round To Factor
You can define the number of places to the right or left of the decimal point to which the pricing engine rounds prices from price lists and modifiers from modifier lists. If you enter a negative number, you increase the number of characters to the
Note: The pricing engine does select inactive price lists when doing a pricing request. Other applications can call an inactive price list and use relevant information.

right of the decimal point. If you enter a positive number, you affect more columns to the left of the decimal point. If you enter zero, rounding occurs to whole decimals. Rounding factor -3 indicates rounding to the nearest thousands (for example,.1007 rounds to .101). Rounding factor of +2 indicates rounding to the nearest hundred; for example 107 rounds to 100).

Secondary Price List
The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order. Primary and secondary price lists have the same currency.

1. You can assign the same secondary price list to multiple price lists but you can not assign a secondary price list to a secondary price list.
2. If the item that you are ordering is not in the primary price list, the pricing engine uses the highest-precedence secondary price list (the secondary price list with the lowest value for the precedence field).
3. Line-level discounts and modifiers that apply to the primary price list do not apply to the secondary price list.
4. If an item appears on both the primary and a secondary price list with the same effective dates, the pricing engine uses the primary price list to price the item.
5. If an item appears on the primary price list but is not active (the effective end date has passed), the pricing engine uses the price on the secondary price list.

Enter the price list line details as given below
1.  Product context is always item.
2.  Depending on the value of Product Attribute, select an item number or an item category for the Product Value.
3.  Select a UOM (unit of measure).
Select Primary UOM if this price list line UOM is the primary pricing unit of measure for the item. Oracle Pricing uses the primary pricing unit of measure and the Oracle Inventory unit of measure conversion information to price an order whose unit of measure does not have a price list line.
Select an Application Method. Use Unit Price for inventory items and either the Unit Price or Percent Price for service items
4. Enter Value and Formula as follows:
■ For inventory items, enter the base list price of the item in Value.
■ For service items, enter a value in the Value field. If Application Method is Unit Price, enter the base list price of the item. If Application Method is Percent Price, enter a percent of another item's price.
■ Enter the name of a previously defined static formula in Static Formula.
If you enter a static formula, you must submit the concurrent program Update Formula Price’s to calculate the value. The result of the calculation changes the value of Value.
5. Enter the starting and ending effectivity dates of this price list line in Start Date and End Date.
The dates should be within the start and end effectivity dates of the price list.
6. Enter a numeric value in Precedence; this is the product precedence. When the pricing engine is trying to locate a price, it uses precedence to resolve conflicts when it selects more than one price list line from a price list.
7. Save your work

Copying a Price List
You can quickly create a new price list by copying an existing price list. Only active price list lines (those with an effective end date later than the current date) can be copied.

Adjusting a Price List
Use this process to adjust the prices for a price list. You can adjust prices for the entire price list or selected items, item category sets, and item categories. You can define your criteria further by selecting the item status or creation date of the items to adjust.
For example, you can specify a category so that only the price list lines for the selected category are adjusted. If you leave any of the fields blank, pricing adjusts the price list regardless of that field. You can adjust the price by either an amount or percent:
■ Percent: Enter a value to adjust list prices by a certain percentage. For example, when adjusting by a percentage, entering 10 raises list prices by 10 percent while -10 lowers list prices by 10 percent.
■ Amount: Enter a value to adjust list prices by a fixed amount. For example, when adjusting by an amount, entering 5 increases list prices by five whole units of currency. Entering -5 decreases list prices by five whole units of currency.