Establishing Pricing Options and Values

To define pricing dates, pricing variables, and price rounding rules, use the Pricing Dates, Pricing Variables, and Price Rounding Rules components, Use the EOEP_DATE_VAR_CI, EOEP_PRICE_VAR_CI, and EOEP_ROUND_RULE_CI component interfaces to load data into the tables for these components.

The section provides an overview of pricing options and values.

Page Name

Definition Name

Usage

Price Key Fields Page

EOEP_APPKEY_FIELD

Select the price by fields that are used to price the transaction.

Price List Fields Page

EOEP_APPLIST_FLDS

Select valid price list-related business objects that are used when creating price lists.

Pricing Dates Page

EOEP_DATE_VAR

Set up date variables that can be used in defining price rule conditions and arbitration plans.

Pricing Variables Page

EOEP_PRICE_VAR

Set up variables that are used in price rule formulas when defining mathematical expressions.

Price Rounding Rule Page

EOEP_ROUND_RULE

Set up the rule that is used for rounding purposes during net price calculation.

Price lists and price rules are two important elements in the pricing process; price lists are used to determine list prices and price rules used for computing the price adjustments when applied. Prior to defining price lists and price rules, you establish components that are referenced in price lists and price rules for a number of purposes: setting up related objects in price lists, building rule conditions, specifying date ranges and mathematical expressions in rule formulas, as well as the rounding option for use in price rules.

Transaction Price-by Keys

Transaction price-by keys are used in defining conditions in price rules. When Enterprise Pricer is called to compute pricing for an order, it looks for all price rules with conditions that match the order lines for applying price adjustments and price lists (in case when a price list is specified in a price rule).

Price List Fields

Price list fields are used in defining related objects in price lists and are a subset of transaction price-by keys. When Enterprise Pricer finds a list price of the product on an order line that is not list price protected, it retrieves all price lists with related objects that match the order. If multiple matching price lists are available, you can set up to either take the best (lowest) product list price found among these price lists, or to use the product list price that comes from the price list with the highest priority score.

Pricing Variables

Pricing variables are used for calculating the net price using mathematical expressions. This table lists the pricing variables that Enterprise Pricer delivers and specifies the ones that are enabled for the Order Capture transaction:

Variable Name

Variable Type

Enabled For Order Capture Transaction

EXT_RECUR_LIST

Extended Recurring List Price

Yes

EXT_RECUR_NET

Extended Recurring Net Price

Yes

LIST_PRICE

List Price

(List price of the transaction line)

Yes

NET_PRICE

Net Price

(Current calculated net price)

Yes

ORDER_LIST

Order Extended List Price

(List price x Quantity)

Yes

ORDER_NET

Order Extended Net Price

(Net price x Quantity)

Yes

RECUR_LIST

Recurring List Price

Yes

RECUR_NET

Recurring Net Price

Yes

-

Rollup Amount

-

-

Rollup Quantity

-

-

Rollup Volume

-

-

Rollup Weight

-

-

User Variable

-

Mathematical Expressions

Enterprise Pricer supports the use of these operators and functions when creating custom mathematical expressions:

Operator/Function

Description

Example

Notes

+

Add

1 + 2

value: 3

If you use negative numbers, do not enter a space between the negative sign and the number.

Subtract

2 – 1

value: 1

*

Multiply

2 * 3

value: 6

/

Divide

6 / 3

value: 2

**

Exponential

2 ** 3

value: 8

( )

Parenthesis

(1 + 2) * 3

value: 9

You can use operation grouping.

Truncate(a,b)

Truncate

Truncate(123.45,1)

value: 123.4

You must enter a value for both “a” and “b,” and “b” cannot be a negative number.

Round(a,b)

Round

Round(123.45,1)

value: 123.5

You must enter a value for both “a” and “b,” and “b” cannot be a negative number.

Enterprise Pricer provides the ability to validate the syntax of mathematical expressions and evaluate them with the inputs you provide.

Pricing Dates

Pricing dates are used in arbitration plans and in defining date breaks that are referenced in price rule formulas for Order Capture transactions. This table lists the pricing dates that Enterprise Pricer delivers and specifies the ones that are enabled for the Order Capture transaction:

Date Name

Date Type

Enabled For Order Capture Transaction

ARRIVEDATE

Requested Arrival Date

Yes

FULFILLDATE

Fulfillment Date

Yes

ORDERDATE

Order Date

Yes

PRICEDATE

Price Date

Yes

SYSTEMDATE

System Date

Yes

-

Effective Date

-

-

User Date

-

Rounding Rules

Price rounding rules identify the number of decimal points to use based on the base price that is used in the pricing calculation. You can associate each price rule with a rounding rule or use the default rounding rule from the arbitration plan. You can also define whether each adjustment is rounded before it is applied, the net price is rounded after adjustments are applied, or both.

Use the Price Rounding Rules page to specify rounding rules. If rounding rules are not established, the system rounds according to how each application uses Enterprise Pricer. In the case of PeopleSoft CRM, prices are rounded by currency.

Use the Price Key Fields page (EOEP_APPKEY_FIELD) to select the price by fields that are used to price the transaction.

Image: Price Key Fields page (1 of 2)

This example illustrates the fields and controls on the Price Key Fields page (1 of 2).

Price Key Fields page (1 of 2)

Image: Price Key Fields page (2 of 2)

This example illustrates the fields and controls on the Price Key Fields page (2 of 2).

Price Key Fields page (2 of 2)

Price-by Key Fields

This section lists the price-by fields that can be selected for use in the specified OC transaction.

Field or Control

Definition

Build Price-by Key Fields

Click to add fields to the Price-by Key Fields grid after selecting them from the Select Price-by Key Fields grid.

Note: If a price-by field is currently assigned to a price rule or an arbitration plan, you cannot remove it from the list of values assigned to the pricing transaction.

Select Price-by Key Fields

This section lists price-by key fields that are currently selected for the transaction, as well as the ones that can be added to the list. For example, if you add a new field to the All Price-by Key Fieldnames page, it is added automatically to this list.

Note: You can define an unlimited number of pricing keys; however, system performance is affected as the number of keys increases.

Use the Price List Fields page (EOEP_APPLIST_FLDS) to select valid price list-related business objects that are used when creating price lists.

Image: Price List Fields page

This example illustrates the fields and controls on the Price List Fields page.

Price List Fields page

Field or Control

Definition

Price List Lookup

Select how you want the system to perform price list lookup. Values are:

Consider all prices: The system considers all matching price lists based on the related business objects and price rules that you have attached to the price lists. It then selects the lowest price for the product.

Lookup in priority order: The system establishes the order for the price list lookup based on the values in the Price-by Key Field Names by Priority section. Use this method to establish a hierarchical method for selecting the list price for the transaction.

Note: When using the hierarchical method, price rules tied to price lists are not used, unless a price is not found using the hierarchical method.

Key Field code

Select price-by keys to define the valid related business objects for a price list. These values are available to you as related business objects on the Related Objects page of the Price List component.

Priority

Establish a hierarchical order to price list lookups by entering a numeric value. This field is available only if you select Lookup in priority order in the Price List Lookup field.

Use the Pricing Dates page (EOEP_DATE_VAR) to set up date variables that can be used in defining price rule conditions and arbitration plans.

Image: Pricing Dates page

This example illustrates the fields and controls on the Pricing Dates page.

Pricing Dates page

Use this page to define valid dates that can be used by price rules to create date breaks in rule formulas. Delivered pricing dates are available. You can define multiple rule formulas using multiple date breaks in a price rule.

Field or Control

Definition

Date Name

Enter a date variable name. The date name must:

  • Start with an alpha character (for example, A-Z)

  • Consist of only alphanumeric characters (for example, A-Z, 0-9)

Optionally, you can add “&” to the front of the date name.

Date Type

Select the date type for the variable.

Effective Date: The date the transaction takes place.

Order Date: The date that the order header is created.

Fulfillment Date: The date when the order is fulfilled in the supply chain management system.

Price Date: The date specified on the arbitration plan.

Requested Arrival Date: The date when the customer wants the order to be arrived on site. This date type is not used in PeopleSoft CRM.

Schedule Ship Date: The date the order line is scheduled to ship.

System Date: The current server date.

User Date: A user defined date. When used, provide a record and field name from where the date value is pulled. A customization of the system is needed to gather and process values properly, if the record and field pair that is selected for the user-defined date is not available in the component buffer.

Record

Select the record from which you wish to pull the date value. Applies only when the pricing variable selected is User Date.

Field Name

Select the field from which you want to pull the date value. Applies only when the pricing variable selected is User Date.

Use the Pricing Variables page (EOEP_PRICE_VAR) to set up variables that are used in price rule formulas when defining mathematical expressions.

Image: Pricing Variables page

This example illustrates the fields and controls on the Pricing Variables page.

Pricing Variables page

Use this page to specify valid variables that can be used in mathematical expressions for calculating pricing adjustments. Delivered pricing variables are available.

Field or Control

Definition

Variable Name

Enter a variable name. The guidelines for naming pricing dates apply to pricing variables as well.

Pricing Variable Type

Select a variable type. All of the variable types, except for User Variable, are Pricer variables whose values are known to Enterprise Pricer.

Extended Recurring List Price: Sum of the recurring list prices for the whole order.

Extended Recurring Net Price: Sum of the calculated recurring net prices for the whole order.

List Price: The list price of the transaction line.

Net Price: The current calculated net price (running net price).

Order Extended List Price: Sum of the extended list price for the whole order.

Order Extended Net Price: Sum of the extended net price for the whole order.

Recurring List Price: The recurring list price of the transaction line.

Recurring Net Price: The calculated recurring net price of the transaction line.

Rollup Amount: The rolled-up amount of the transaction lines that match the price rule. This value is used to select the price formula breaks.

Rollup Quantity: The rolled-up quantity of the transaction lines that match the price rule. This value is used to select the price formula breaks.

Rollup Volume: The rolled-up volume of the transaction lines that match the price rule. This value is used to select the price formula breaks.

Rollup Weight: The rolled-up weight of the transaction lines that match the price rule. This value is used to select the price formula breaks.

User Variable: A user defined variable. When used, provide a record and field name from where the variable value is pulled.

Use the Price Rounding Rule page (EOEP_ROUND_RULE) to set up the rule that is used for rounding purposes during net price calculation.

Image: Price Rounding Rule page

This example illustrates the fields and controls on the Price Rounding Rule page.

Price Rounding Rule page

Use this page to specify the rule that is used for rounding during net price calculation.

A rounding rule cannot be deleted if it's currently used by an arbitration plan.

Field or Control

Definition

Rounding Rule ID

Enter the name of the rounding rule. This name appears as an available value of the Rounding Rule ID field that appears in the Arbitration Plan page and Formulas page.

Minimum Price and Maximum Price

Enter the lowest and highest prices to establish different rounding levels to which the corresponding rounding position applies.

Levels should not overlap.

Rounding Position and Decimal Position

Select the rounding method. Values are:

Decimal Point: Rounds prices to a specific decimal point. When selected, specify the number (from 0 to 4) of decimal points to use in the Decimal Position field that appears.

By Currency: This defines the decimal precision for the currency code of the transaction. This option is the default value.