Create Sales Rule Formula

Explanation

This activity is used to create a sales rule formula for use in the configuration sales rules. A sales rule formula allows you to define a mathematical expression or an alphanumeric expression using configuration values, values and operators to create a value used during sales rules evaluation.

The formula is comprised of elements. Each element represents one piece of the mathematical expression that makes up the formula. Elements are defined by their item type. Possible item types are displayed below.

Item Type

Description

Operator

An mathematical operator, including the following values: + Plus, - Minus, / Divide* Multiply, ( Open Paranthesis, ) Close Paranthesis and , Comma.

Function

A common SQL function used for operations, for example, ROUND, a function to round the value of an expression. Different functions are available depending on the formula type.

Value

A constant entered into the formula (e.g., 50).

Char Value

The value of a configuration characteristic, from the configuration of the evaluated part.

Char Quantity

The value of a configuration characteristic quantity, from the configuration of the evaluated part.

Formula

Other formulas defined for the configuration family can be used within a formula. The return value for the selected formula will be used in the calculation.

Order Info

Different order information from sales quotation or customer order can be used as a value for the formula, (e.g., sales quantity).

By placing elements in a sequence, a formula is created to calculate a numeric value to be used as a value to be presented in the configuration or in another sales rule. For example, the formula to round a entered value for height of a door defined as [ROUND (HEIGHT / 50) * 50] would be expressed as 8 elements:

Function ROUND
Operator ( Open Parantesis
Char Value HEIGHT
Operator / Division
Value 50
Operator ) Close Parantesis
Operator * Multiply
Value 50

To create a new sales rule formula first create a new record with information about the formula. The chosen configuration family defines the set of configuration characteristics that can be used within formula. The created sales rule formula will be in status Planned, indicating it is not yet ready to be used. Create new items in the Element section to define the formula elements of the sales rule formula.

Finally, to release the sales rule formula click Release.

If you want to test the sales rule formula click Test Formula.

Prerequisites

System Effects

As a result of this activity, a formula is created for use in the configuration sales rules.