Price Lists
Price lists are essential to ordering products because each item entered on an order must have a price. Each price list contains basic list information and one or more pricing lines. Basic information includes the price list name, effective dates, currency, pricing controls, rounding factor, secondary price list, and shipping defaults such as freight terms and freight carrier.
Effective Dates
Price lists can have starting and ending dates. This allows you to prepare price lists ahead of when they are valid and to ensure they will not be used until their start dates.
Price List Currency
If you have 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. Oracle Order Entry/Shipping interfaces the currency, along with the selling price, to Oracle Receivables for each order or return, resulting in an invoice or credit with the same currency as the order or return.
Rounding Factor
You can define the number of places to the right or left of the delimiter that a price is rounded on a price list. If you enter a negative number, you increase the number of characters to the right of the delimiter. Using dollars, a rounding factor of -3 indicates that you want prices rounded to the nearest thousandth, or $1.000. If you enter a positive number, you are affecting the number of characters to the left of the delimiter. In dollars, a rounding factor of 3 indicates that you want prices rounded to the nearest hundred dollars. A price of $105.00 would be reflected as $100.00.
Note: The rounding factor is limited by the number of positions allowed in the extended precision format of the price list's currency. Zero indicates rounding to the delimiter.
Secondary Price Lists
Oracle Order Entry/Shipping uses secondary price lists when an item is not on the primary price list assigned to an order. Primary and secondary price lists share the same currency.
If an item appears on both the primary and secondary price lists with the same effective dates, Oracle Order Entry/Shipping uses the primary price list to price the item. If an item exists on the primary price list but is not active (the effective end date has passed), Oracle Order Entry/Shipping uses the price on the secondary price list.
The same secondary price list can be assigned to multiple price lists. Since discounts are price-list-specific, a discount for the item on the primary price list is not used if the price is found on the secondary price list. 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.
See Also
Overview of Pricing
Copying Price Lists
Defining Price Lists
