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:
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.
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.