Creating Price Lists

This section provides an overview of price lists and discusses how to set up price lists.

Understanding Price Lists

Price lists are groups of date-controlled product prices that are defined by currency code and linked to related business objects existing price rules. These product prices are intended to replace the product list price when they are associated with a transaction via the related business objects or price rules.

Price-list related business objects are a subset of the existing transaction price-by fields. They are used to define objects, which can be associated with a price list, to look up a list price. A price list can have more than one related business object, such as customer, customer group, product ID, and business unit.

The system uses the appropriate pricing transaction to determine the available price list related business objects. The system attempts to match a particular transaction to one or more price lists based on the transaction values and the price list related business objects. For example, if you are taking an order for customer ABC and customer ABC is defined as a related business object for a specific price list, that price list applies to this order. Furthermore, if any product on the order appears on this price list, the price from the price list is used as the base price for all further pricing calculations, instead of the product's list price. If more than one applicable list is found, the price list lookup defined for that transaction determines which price is used:

Lookup in priority order.

The system performs a search to match the related business objects in the defined priority order and then selects the first list price it finds.
Consider all prices.

The system performs a search to match the related business objects and their price lists and then selects the lowest price.

After locating the base price for the product, the system performs a separate search of the price rules to find the appropriate adjustments to that price. If you haven't set up price lists, or the system fails to find the product on an active relevant list, the system uses the list price defined for the product as the default base price for any further price adjustments.

Setting Up Price Lists

This section discusses how to:

Establish price lists.
Define related business objects.

Common Elements Used in This Section

Status

Values are:

Active: Product prices on this list automatically supersede the product list price in transactions involving any related business objects.

Inactive: This list is ignored when calculating product prices.

Product

Use to search for a product ID, enter a new product ID, and view the product IDs in a price list.

Unit of Measure

Each list price is defined by the unit of measure. The unit of measure must be a valid unit of measure for that product as defined in the product master.

Pages Used to Set Up Price Lists

Page Name	Object Name	Navigation	Usage
Price List	EOEP_PRICE_LIST	Pricing Configuration, Price List	Use to define a price list. You can set up price lists in multiple currencies and create start and end dates for each product's price.
Product Notes	EOEP_PRC_LIST_NOTE	Click the Recurring Note button on the Price List page.	Use to create and view product notes associated with a recurring price. These notes are used for information only and are separate from the standard product notes in the product definition component.
Related Objects	EOEP_PRCLST_ATTCH	Pricing Configuration, Price List, Related Objects.	Use to associate a price list with related business objects such as a customer, customer group or region and to associate price rules directly to a price list.
Search	EOEP_SEARCH_PAGE	Click the Find External Resource button on the Related Objects page.	Search for existing values for the field names on the Related Objects page.

Establishing Price Lists

Access the Price List page.

Currency Code

Use to establish the same price list with the same price list ID in multiple currencies. The price list is considered if the transaction is entered in the same currency as that of the price list.

Note. In PeopleSoft CRM, if a price is not available in a price list using the transaction currency, but a price list is available for the base currency, the system accesses the price from the price list in the base currency and converts it to the transaction currency. The currency is converted as long as there are conversion rates defined between the transaction and base currency. You must also define rate types for the customer and business unit for the currency conversion.

Search	Click to select the price list detail based on your search criteria and view additional price list information. The price list detail appears in the Pricing Information tab. Click the Clear Search button to remove the search criteria.
Description	Search for products using elements of the product description or product ID.

Add Product

Add

Click after you enter the product ID. This adds the product to the price list.

Pricing Information Tab

Select the Pricing Information tab.

Error	If an error exists in the price list definition, a red square box appears in this column. This field is only visible if an error exists. For example, if you entered an invalid value, the line is marked as an error. Correct the error as necessary.
UOM (unit of measure)	Use to define a list price for a particular UOM for that product.
Start Date and End Date	Use to define the effective period (start and end date) for the list price entry.
List Price	Use to enter a list price for the products on the price list.

Frequency

Use to select a recurring frequency in PeopleSoft Order Capture. If you select this option, the amount in the List Price field represents a recurring charge. If not, the list price represents a one time charge.

Valid options include: Annually, Daily, Monthly, Quarterly, and Weekly.

Additional Information Tab

Select the Additional Information tab.

Recurring Note

Click this button to enter and view notes relating to recurring charges for the product. These notes are informational only and separate from the standard product notes defined in the product definition component.

Protected

If you select the check box, the system does not apply adjustments to the price. The price protected flag on the transaction is activated.

Note. If a product with the same price is on two different price lists and one is price protected, the price protected one is used in the transaction.

Entering Related Objects

Access the Related Objects page.

Transaction

The option defaults and determines the list of available values to select in the Related Objects group box.

Field Name

Select a value to tie a business object to the price list. Define the valid list for the pricing transaction when you set up PeopleSoft Enterprise Pricer. Values include:

Business Unit, Customer Group, Region ID, Sold To Customer for the SO (sales order) transaction.

Business Unit, Customer Group, Region ID, Sold To Customer for the OC (order capture) transaction.

Identifier

Enter values for the business object or click the Find External Resource button to search for values.

If the field name and identifier criteria match those on a particular transaction, this price list is considered for that transaction.

Rule

Select a price rule to tie the price list to the price rule.

A price rule can be directly associated with the price list. The price rule conditions defines the part of the transaction that must match in order for this price list to be considered at pricing time.

Transaction	The option defaults and determines the list of available values to select in the Related Objects group box.
Field Name	Select a value to tie a business object to the price list. Define the valid list for the pricing transaction when you set up PeopleSoft Enterprise Pricer. Values include: Business Unit, Customer Group, Region ID, Sold To Customer for the SO (sales order) transaction. Business Unit, Customer Group, Region ID, Sold To Customer for the OC (order capture) transaction.
Identifier	Enter values for the business object or click the Find External Resource button to search for values. If the field name and identifier criteria match those on a particular transaction, this price list is considered for that transaction.
Rule	Select a price rule to tie the price list to the price rule. A price rule can be directly associated with the price list. The price rule conditions defines the part of the transaction that must match in order for this price list to be considered at pricing time.