Defining Price Lists
You can define and maintain multiple price lists. Price lists are used to derive selling prices automatically during on-line order entry. You can also attach payment terms, freight terms, and freight carriers to a price list so that you can default them on orders to which that list is assigned.
Suggestion: You must designate a currency for each price list. You can copy a price list to create corresponding price lists with different currencies. See: Copying Price Lists.
Prerequisites
To define price list header information:
1. Navigate to the Price Lists window.
2. Select the way in which you want the price list items to be displayed. Select from:
Not Sorted: Items are listed in the order in which they are entered.
Item: Items are sorted alphanumerically by item name and then by effective date.
Effective Date: Items are sorted by effective date and then alphanumerically by item name.
3. Enter a name for the price list.
4. Enter the currency code for the price list.
The default is the functional currency assigned to your set of books.
The rounding factor for a price list must be greater than or equal to the currency precision in use for the currency on the price list. The currency precision in use can be either the Standard or Extended precision of the currency and is determined by setting the OE: Unit Price Precision Type profile option. For example:
-2 = round to the nearest $.01
-1 = round to the nearest $.10
0 = round to the nearest $1.00
1 = round to the nearest $10.00
2 = round to the nearest $100.00
When you run pricing rules, the prices reflect the rounding factor. If lines with rule-based prices already exist on the price list when the rounding factor is added, you do not see the updated prices until you rerun the rules.
If prices are manually entered after the rounding factor is entered, the prices automatically round on entry. If manually entered prices already exist on the price list when the rounding factor is added, the price on the price list does not change, but as the item is ordered, the price on the order reflects the correct rounding factor.
If discounts are used on orders against price lists with a rounding factor, the selling price (list minus discount) reflects the rounding factor. For example, if the list price of an item is $100 and the discount is 33.5%, the next result on a price list with a rounding factor of 0 would be $67.
6. Optionally, enter effective dates for the price list.
7. Optionally, enter a secondary price list.
The secondary price list is used if the item you enter during order entry is not on this price list. The secondary price list must be in the same currency as the price list you are defining.
Warning: Secondary price lists only go one level deep. Oracle Order Entry/Shipping does not look on the secondary price list's secondary list for the item. Also, line-level discounts that apply to the primary price list do not apply to the secondary price list.
8. Optionally, enter payment terms, a freight carrier, or freight terms for the price list.
To define price list lines for items:
1. Enter an item in the Price List Items region in the Price Lists window.
2. Enter the unit of measure for the item. If the item has multiple units of measure, enter a separate price list line for each unit.
3. Optionally, enter pricing attributes for the order line according to how you set up your Pricing Attributes descriptive flexfield.
If you use pricing rules and must quickly add an item to a price list, enter both a pricing rule and the list price. After you save, you can order the item immediately without having to run the pricing rule program. Subsequently running the pricing rule program overrides the entered list price.
If you choose a pricing rule to calculate the price, you can also enter a list price for this line. However, when the Pricing Rules are run next, the list price entered here is overridden by the rule-derived price. If you leave the pricing rule blank, you must enter a list price.
You can enter a set price for a service item in the Price field, or you can base the service price on the serviceable item's list price. For example, you provide the same extended warranty for both a $100 base-line model and a $200 luxury model. By setting the extended warranty's price to 15 percent of the serviceable item's price, you can charge less for the base-line model's warranty than for the luxury item's warranty. You can define either a list price or a list percent price, but not both.
7. Optionally, enter effective dates for the price list lines.
See Also
Overview of Pricing
Copying Price Lists
Rule-Based Pricing