Create and Maintain Sales Price Formula

Explanation

This activity is used to create a sales price formula to be used in the configuration pricing. A sales price formula is used to define a mathematical expression using configuration values, quantities, mathematical operators, SQL functions, Characteristic Prices, other price formulas, and price combination tables.

The formula is comprised of element lines. 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 Parenthesis) Close Parenthesis and,Comma.

Built-in Function

A common SQL function used for numeric operations, for example, ABS, a function to return the absolute value of an expression, e.g., ABS(2).

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.

Char Price

Characteristic Prices of the other characteristics belongs to the same configuration family can be used with in a price formula.

Price Formula

Other price formulas defined for the configuration family and with the same currency code can be used within a formula. The return value for the selected formula will be used in the calculation.

Price Combination

price combination defined for the configuration family and with the same currency code can be used within a formula. The return value for the selected price combination will be used in the calculation

By placing elements in a sequence, a price formula is created to calculate a numeric value which is included in the configuration pricing.

For example, the formula to calculate the price of a door based on the unit area price. The formula is defined as  [Char Value (HEIGHT) * Char Value (WEIGHT) * 50] would be expressed as 5 elements:

Char Value

HEIGHT

Operator

* Multiply

Char Value

WEIGHT

Operator

* Multiply

Value

50

To create a new sales price 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 price 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.

Release the sales price formula to connect it to the characteristics. Price formula can be connected at Sales Part/ Configuration Based Pricing tab, Configuration Price List or Sales Price List/ Configuration Based Pricing tab.

Test Formula option can be used to simulate the formula based on the test values defined in the elements section.

Note:

  1. Inside the formula it is possible to use Char Price in the element section. When connecting the sales price formulas to the characteristics, there can be situations that connected formula has the same characteristic in the element section. This creates a closed loop, and it is not possible to get correct results. This type of setup is not acceptable, and the user should avoid this type of closed loops during the set up.

  2. The Apply command in Create Configuration and Edit Configuration pages will run the price calculation one more time. This is to include the last changes to the price formulas which has Char Price in the element section. Therefore, the characteristic price can be changed when Apply command is performed, if the characteristic has a price formula connected including the Char Price in element section.

Prerequisites

·       IFS/Configuration Back Office and IFS/Configuration Characteristic must have been installed.

·       A configuration family must exist to be referenced by this formula.

System Effects

As a result of this activity, a price formula is created to be used in the configuration pricing.