Setting Up Price Rules

Select a value from the available options to create a new price rule. Select a value to populate the list of values for the field names.

This field is visible only in add mode. Once the rule is created for a transaction, you cannot change the transaction.

Values are:

Deployed: Activates the price rule so that it is used to determine price adjustments. You must enter data on the Formulas page before you can save the price rule in this status. You can also use the simulator to test price scenarios in this status.

Inactive: The price rule is no longer active. Use to cancel a rule that was previously in use.

Pending: This status appears by default. You can save the price rule in this status without adding data on the Formulas page. Use this status when you want to save the price rule but you don't want the system to process any edits on the rule. You cannot use a rule in this status in the simulator.

Ready to Test: Use this status to test the rule with the simulator. The rule is available to the pricing system.

Enter a descriptive text for the price rule.

Use for the short description of a rule. The first 20 characters of the description appear by default. This field is used as the label on pages and inquiries.

If an error exists in the price rule definition, a red square box appears in this column. Correct the error. This field appears only if an error exists.

Select the price by field to use with the rule condition. The valid list of price by fields is established on the Transaction Price By Keys page by the PeopleSoft Enterprise Pricer system administrator. The list of fields available when you create the price rule is determined by the transaction.

Enter values for the corresponding price by field. This value is available only if you are using the advanced mode.

Click to access the Search page (EOEP_SEARCH_PAGE) to find valid values for the selected price by field in the price rule condition.

After selecting two or more combined conditions, select either operator to combine the conditions. This option is available if you are using the Advanced mode.

After selecting the conditions to use and the conditional operator, click this button to build the rule definition. The new condition is added to the Combined Conditions grid, and the definition appears in the Rule Definition section.

Select the action that the price rule performs when the rule is applied to a transaction.

Enterprise Pricer delivers a list of price action types and you specify the ones that are supported by a transaction on the Price Transaction Code page of that transaction. The complete list of action types includes:

Discount/Surcharge: Apply discounts or surcharges to order lines. It is selected by default.

Free Period Promotion: Define periods and frequency for which a recurring charge is not applied. The Apply to Recurring Price field is by default selected and unavailable for edit when this price action type is selected.

Giveaway/Product Add: Apply free or discount products that can be based on the line or order.

Min/Max Target Discount (minimum/maximum target discount): Compare the discount adjustment and apply a target discount.

Min/Max Target Price (minimum/maximum target price): Compare the price adjustment and apply a target price.

Min/Max Target Surcharge (minimum/maximum target surcharge): Compare the surcharge adjustment and apply a target surcharge.

Price List Only Condition: Use the product list price from the price list that is returned as a result of matching the price rule condition with related objects of price lists.

Price Override: Apply a new price to replace the existing price.

Rollup Only Rule: Indicate that the rule is used for rolling up quantities.

Total Order Discount/Surcharge: Apply discounts or surcharges to orders.

See Price Transaction Code Page.

Select to indicate that the price rule applies to recurring price calculation.

This field is only available for edit if the corresponding pricing action type is enabled for recurring pricing on the Price Transaction Code page.

See Price Transaction Code Page.

Determines how the system applies the adjustment for the Discount/Surcharge price action type.

Cascading: Applies the adjustment as the discounts are found. A second discount is applied to the previously discounted price, a third discount is applied to a price that was previously discounted twice, and so on. For example, if the system encounters two discounts, 10 percent and 20 percent off the list price of 100.00 USD, the system applies the discounts in this way: 10 percent off of 100.00 USD and 20 percent off of 90.00 USD. Thus, the unit price for the order schedule line is 72.00 USD.

Summed: When the system finds multiple discounts, it adds them together and applies the discounts once. For the summed example, the system would combine the 10 percent and 20 percent discounts for 30 percent off of 100.00 USD. The resulting unit price for the order schedule line is 70.00 USD.

Select to prevent the system from applying further price adjustments when the system finds a match with a price rule. This occurs for total order or line adjustments. The system stops applying price adjustments after encountering the first price rule match that has this option selected.

Select to limit the applicability of the rule to only once.

Values are:

No: The rule is not a one-time rule.

Per Customer: The rule can only be applied once for each customer.

Per Rule: The rule can only be applied once in the system.

One-time rules are typically used for price discounts that are so good they are not allowed on multiple orders. The are effective for encouraging large first orders instead of many smaller orders.

Click to make the price rule the only one that applies to an entire order, if the price rule is found to match the order during arbitration. No other discounts or surcharges apply to the order even if other eligible price rules are available.

Mutually exclusive rules are typically used for discounts that are so good no other discounts are allowed in conjunction with the discount provided by this rule. An example of a mutually exclusive price rule is “Spend USD 10,000 or more, and get 25 percent off the order. No other discounts allowed.” If more than one mutually exclusive price rule is matched, only the first (use the arbitration plan to specify the order) mutually exclusive price rule is applied. All other price rules are ignored, including the normal price rule that is sorted before the applied mutually exclusive rule.

Specify the manner in which rollup (totals to select price formulas) is calculated. Values are:

Line: Rollup value is the order line quantity.

Rollup Rule: Rollup quantity is calculated using the rollup only price rule that is specified in the ID field.

Transaction: Rollup is calculated by adding all lines (which match the same price rule) within the Order Capture transaction.

Rollup is not available to these price action types: Free Period Promotion, Price List Only Condition, and Rollup Only Rule. For Total Order Discount/Surcharge price rules, the Rollup By field is not editable, and the rollup method is always by transaction.

Enter the rule whose rollup is used to select the matching price formula for the current price rule.

Select to set the rollup to be based on the unit of measure of the transaction.

This field appears if the rollup method is by transaction.

Identify a specific rounding rule to use when determining values such as net price and adjustments.

Select which calculations should have a rounding rule applied to them before arriving at a final value. Values are:

Adjustment: Round each adjustment.

Both: Round both adjustments and the net price.

Net Price: Round only the net price.

None: Do not round adjustments or the net price.

Select the date of the transaction used for defining the date break.

Available values are established on the Pricing Dates page. For the Order Capture transaction, delivered values are:

Arb Plan Price Date

Fulfillment Date

Order Date

Requested Arrival Date

System Date

In order to apply a price rule to an order transaction, the actual value of the selected pricing date for that transaction must fall within the date break that is specified in the price rule formula.

Enter the start and end date to form a date break.

Select the type of transaction value used for defining the formula break.

Available values for the Order Capture transaction are:

Extended Price: Indicates the formula range defined pertains to the order value of the item purchased in the minimum and maximum purchase ranges identified.

Quantity: Indicates the formula range pertains to the number of units of the item purchased in the minimum and maximum purchase ranges identified.

In order to apply a price rule to an order transaction, the actual transaction value (price or ordered quantity) must fall within the formula break that is specified in the price rule formula.

Enter the lower and higher limits of the range, quantity or purchase total, for the corresponding price type to form a formula break (formula range).

Enter the ID of the date range that transactions must match for the formula to apply. If you want to include multiple date ranges to a formula, separate the IDs by commas (for example, 1,2,3). If multiple IDs are specified, transactions must meet all the date range conditions in order for the price rule formula to apply.

Enter the ID of the formula range that transactions must match for the formula to apply. If you want to include multiple formula ranges to a formula, separate the IDs by commas (for example, 1,2,3). When multiple IDs are specified, transactions must meet all the formula range conditions in order for the price rule formula to apply.

Enter the unit of measure that transactions must match for the formula to apply. If not provided, all unit of measures are considered.

Specify how often and the number of times that price adjustments by this recurring price rule need to occur. If recurrence is not specified, price adjustments on the recurring charge are offered as long as the customer of the order has the service. Frequency is required for recurring price rules.

These fields appear if the price rule is set to apply to recurring price calculations.

Specify the currency in which the price formula is measured. If not provided, apply to all currencies.

Select how the discount or surcharge adjustment is performed. This field appears if the selected price action type is Discount/Surcharge or Total Order Discount/Surcharge.

Values are:

Amount: Indicates that the adjustment is by amount.

Amt & Expr (amount and expression): Indicates that the adjustment is a calculated value derived by the amount or an expression.

Expression: Indicates that the adjustment is derived from a specific expression.

Ext Class (external class): Indicates that the adjustment is derived from an external class.

Pct & Expr (percentage and expression): Indicates that the discount is a calculated value derived by a percent or an expression.

Percentage: Indicates that the adjustment is by percent.

Enter the adjustment amount (or percent) if the discount (or surcharge) by value is either Amount or Amt & Expr.

Enter the external class (or mathematical expression) to use in the price formula. This field appears if the discount (or surcharge) by value is Amt & Expr, Expression, Ext Class, and Pct & Expr.

Specify which net price (smaller or larger) to use as the final net price.

If the selected price action type is either a discount or surcharge (discount/surcharge by value: Amt & Expr or Pct & Expr) , or a price override (price override by value: Prc & Expr), Enterprise Pricer performs two calculations and chooses either the larger or the smaller net price based on the selected value of this field.

For example, the product's list price is 100 USD. The formula is specified as discount by amount and expression and the smaller net price is used. The discount amount is -10 and the expression is LIST_PRICE * 0.95. Discount by –10 results in a net price of 90. The expression is evaluated as 100 * 0.95=95. Because 90 is smaller than 95, a discount of –10 is applied for a net price of 90.

This field appears if the selected discount (or surcharge) by value is either Amt & Expr or Pct & Expr, or if the selected price override by value is Prc & Expr.

Select Quantity as the criterion that is used to apply free promotions to orders with recurring charges. This field appears if the selected price action type is Free Period Promotion.

When you define a free period promotion price rule, specify the free period by value as well as the number of times that the recurring charge should be waived in the Quantity field. For example, if the specified quantity is 3, and the free period promotion price rule is applied to an order with a cell phone for 30 USD per month, then the first three months are free.

If you want the free period promotion price rule to be applicable only to transactions with certain UOM or frequency (or both), specify the values in the corresponding fields; transactions must match these values for the formula to apply.

Select how the giveaway or product add is performed.

Values are:

BOGO (buy one get one): Enterprise Pricer computes the quantity of the promoted item given away by summing the quantities from the order that match the price rule and dividing them by the BOGO factor, and taking the whole number.

BOGO & Prc: Discounted giveaway, for example, buy one product and get another product at half price. Specify the BOGO factor used to calculate the quantity of the selected product to be given away at a price that is computed using a mathematical expression.

Qty & Prc: Specify the product add quantity to be given away at a price that is computed using a mathematical expression.

Qty Expr: Specify the mathematical expression used to calculate the product add quantity to be given away.

Quantity: Specify the product add quantity to be given away.

Enter the quantity to be used in the product add formula, or the factor that is used to calculate the product add quantity in the BOGO-specific product add formula.

This field appears if the selected product add by value is any but Qty Expr

This is the formula used to compute the final product add quantity for BOGO-specific product add formula:

The resulting number derived from the calculation is truncated so that only the whole number is used. For example, with a BOGO factor of three, when the customer buys two they get zero free. When they buy three, four, or five items, they get one free. When they buy six, seven, or eight items, they get two free items, and so on.

Select how target discount (or target surcharge) is calculated, by amount or by percent.

The Target Discount By field appears if the price action type is Min/Max Target Discount; the Target Surcharge By field appears if Min/Max Target Surcharge is the selected action.

Select Price, indicating that the target price is matched by item unit price

This field appears if the price action type is Min/Max Target Price.

Enter the lower and upper amounts or percentages for the corresponding target discount/surcharge by value.

This field appears if the selected price action types is Min/Max Target Discount or Min/Max Target Surcharge.

Enter both of these values if the selected price action type is Min/Max Target Price.

Select how price override is performed. Values are:

Expression: Indicates that the price is derived from a specific expression.

Ext Class:Indicates that the price is derived from an external class.

Prc & Expr: Indicates two prices, one on the Price field that appears and the other derived from an expression. The value of the Small or Large field determines which of the two prices to select as the final net price.

Price: Indicates item price is defined by the price in the Price field.

Enter the new price, if the price override by value is Price.

This field appears if the price override by value is Prc & Expr or Price.

Select the ID of the product to be given away for free or at a discounted price for the corresponding price formula.

At the time when an order is being evaluated for pricing, if a product add/giveaway price rule is found to be applicable to an order, the specified giveaway product will be added automatically to the Line Summary grid of the Order - Entry Form page, as well as on the Line Details page.

Select the UOM for the product that is given away or added to the order.

Applies to only giveaways. Specify whether the giveaway is applied to each line of the transaction (sales order) or applied only once to the header of the transaction.

Per Line: The system applies this giveaway to every line.

Per Order: The system applies this giveaway only once to the entire sales order.

Enter a value for a variable to be used to test the expression.

Click to calculate the result of the expression using the test value.

Displays the number of customers to whom this price rule has applied.

If the price rule has applied to the only one customer multiple times, the customer count is 1.

Displays the number of orders to which this price rule has applied.

Displays the total adjustment value that has been made thus far by this rule.