PeopleSoft Enterprise Pricer 9.1 for CRM PeopleBook

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 transaction. They are associated with business objects (by price-by key field and value pairs) and can be linked to existing price rules. These product prices are intended to replace the product list price defined in the Product Price component 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:

Look up 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 that 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.

Note. Enterprise Pricer supports the definition of zero-valued (0.00) list prices in the Price List component.

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 if the system fails to find the product on an active relevant list, the system uses the list price defined for the product in the Product Price component as the default base price for any further price adjustments.

PeopleSoft CRM provides an advanced search capability for looking up existing price lists by price rule conditions in the related business objects.

See Searching for Price Lists.

Quantity Breaks within Price List

Price lists support multiple list price entries for different quantity breaks. When the Use Quantity in Price List option is enabled for the Order Capture transaction, Enterprise Pricer looks for the list price that is associated with the matching quantity break as it processes order pricing. To find out which quantity break to use to obtain the list price, the sum of the product by UOM for the whole order is used.

Here is an example of a price list with multiple quantity breaks:

Product ID	List Price	Quantity Break
10050	USD 4.00	1–50
	USD 3.00	51–100
	USD 2.00	101 or more

Quantity breaks are defined by specifying low and high quantities on the Price List page.

If a customer purchases 120 units of product ID 10050 on an order, the customer will receive the units at the 2.00 per unit price.

In addition to supporting multiple list price entries for different quantity breaks using the Price List component, you can also specify different list prices for a product based on time periods, as illustrated by this table:

Product ID	List Price	Time Break
10050	USD 4.00	01/01/2008 - 03/31/2008
	USD 3.00	04/01/2008 - 06/31/2008
	USD 2.00	07/01/2008 - 09/31/2008

Last but not least, you can set up one-time and recurring list prices for a product, for example:

Product ID	List Price	Pricing Nature
10050	USD 50.00	N/A (one-time charge)
USD 10.00	Monthly (recurring charge)

Product ID

List Price

Pricing Nature

10050

USD 50.00

N/A

(one-time charge)

USD 10.00

Monthly

(recurring charge)

You can also set up product recurring prices with different frequencies (daily, weekly, monthly and so on) using the Product Price component.

By default, a price list entry for a product is for one-time charge and the list price is intended to apply to all quantities (with one quantity break) at all times (with one time break). You can update existing or create new entries to include additional list prices for various time frames, quantity breaks, and charge types as needed.

Setting Up Price Lists

To set up price lists, use the Price List (EOEP_PRICE_LIST) component.

This section lists common elements and discusses how to:

Establish price lists.
Define related business objects.
Search for price lists.

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 valid for that product, as defined in the product master.

Pages Used to Set Up Price Lists

Page Name	Definition Name	Navigation	Usage
Price List	EOEP_PRICE_LIST	Pricing Configuration, Price List, Price List	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.	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	Associate a price list with related business objects, such as a customer, customer group, or region. Also associate price rules directly to a price list.
Search page	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.
Price List Advanced Search	EOEP_PLST_SRCH_PG	Pricing Configuration, Price List Advanced Search, Price List Advanced Search	Search for existing price lists using related object conditions.

Establishing Price Lists

Access the Price List page (Pricing Configuration, Price List, Price List).

Currency Code

Displays the selected currency when you create this price list. This value is used 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. For Order Capture transactions, 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 conversion rates are defined between the transaction and base currencies. You must also define rate types for the customer and business unit for the currency conversion.

See Calculating Currency Exchange.

Product ID and Description	Enter a product ID or product description to search for any of its price list available in the system.
Search	Click to select the price list detail based on the search criteria and to view additional price list information. The price list detail appears on the Pricing Information tab. Click the Clear Search button to remove the search criteria.

Add Product

New Product ID	Search for a product to add to the price list.
Add Product	Click the button after you enter the product ID to add the product to the price list.

Pricing Information

Access the Pricing Information: Pricing Information section.

Error	If an error exists in the price list definition, a red square box appears in this column. This field is visible only 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	Specify the effective period (enter start and end dates) of the list price entry.
Low Quantity and High Quantity	Specify the product quantity break (enter low and high quantities) to which the corresponding list price applied. Note. In order to use the list price in the price list, the quantity of the products on the order must fall within the quantity break for the specified UOM. Also, if the Use Quantity in Price List option is not enabled on the Price Transaction Code page, the quantity break is ignored.
List Price	Enter the product list price that applies to the corresponding quantity level during the specified effective period. Specify a list price with a non-negative value, including zero (0.00).
Frequency	Select how often does the recurring charge occur, if the corresponding price list line is for recurring pricing. If selected, the amount in the List Price field represents a recurring charge. If this option is blank, the list price represents a one-time charge. Valid values are Annually, Daily, Monthly, Quarterly, and Weekly.

Access the Pricing Information: Additional Information section.

Recurring Note

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

Note. This button appears if a recurring frequency is selected in the list price entry.

Protected

Select to not stop the system from applying any pricing adjustment to the list 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.

Defining Related Business Objects

Access the Related Objects page (Pricing Configuration, Price List, Related Objects).

Related Business Objects

Transaction

Displays the transaction to which the price list applies. This value determines the list of available values to select in the Related Objects group box. PeopleSoft CRM supports the Order Capture transaction only.

Field Name

Select a value to tie a business object to the price list. Available values in this field are specified on the Price List Fields page for the 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.

Related Price Rule

Rule

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

Note. When you directly associate a price rule with the price list, the price rule conditions define the part of the transaction that must match in order for this price list to be considered at pricing time. Price rules are used to define more complicated conditions. Business objects are used to define simpler, less complex conditions.

Searching for Price Lists

Access the Price List Advanced Search page (Pricing Configuration, Price List Advanced Search, Price List Advanced Search).

In addition to the search fields that are available on the search page of the Price List component, the Price List Advanced Search page provides the ability to find price lists by related object conditions. You can enter price-by key field and value pairs as criteria of a price list search.