Product Property with Price Influence
- Anne Krieg
- Oleh Horbach
- Phu Nguyen (Unlicensed)
Simplify the configuration using the Lightning Page Layout Product_Property_with_Price_Influence_Dynamic_Layout, which automatically displays the required fields for the respective property type. Assign this to the record type Produktoption_mit_Berechnung in the setup.
Introduction
Product Properties with Price Influence are suitable for specifying products in the offer more precisely in terms of content, and these properties also influence the price calculation.
Create a new product property of the record type "Product Property with Price Influence". The mask for configuring the product property opens:
Basic Configuration
The exact basic configuration is as follows:
Field Name | API-Name | Function |
|---|---|---|
Product Property | Name | Under this name the product property is displayed in the offer |
Property Type | sf42_quotefx__SF42_PropertyType__c | The property type determines the way the property is queried in the quote editor. Possible characteristics are:
|
Preassigned Value | sf42_quotefx__SF42_PreassignedValue__c | Optional, at this point a value can be specified with which the property is preset. In the case of a checkbox, the available values are 'true' and 'false'. |
Unit Text | sf42_quotefx__SF42_UnitText__c | Optional, this text appears in the offer after the payment input for more precise specification, e.g. a unit of measurement. |
Mandatory | sf42_quotefx__SF42_isMandatory__c | Optional, if this checkbox is set, it is mandatory to specify the product property. Otherwise it could also be skipped in the product dialog |
hidden | sf42_quotefx__SF42_isHidden__c | If set to 'true', the product property will appear in the Quote Editor, but not in the printout. |
Order | sf42_quotefx__SF42_CalcOrder__c | Optional, determines the query order for multiple product properties of the same record type for a product. For more details, see the Calculation section. |
Opp Lineitem API | sf42_quotefx__SF42_OppLiAPIfieldname__c | Optionally, here you can define on which field of the opportunity product the determined value should be written (esp. property type Table/Relation). |
Relations
The Relations section specifies the product(s) or product group(s) to which the product property relates:
Field Name | API-Name | Function |
|---|---|---|
Product | sf42_quotefx__SF42_Product__c | The product property refers to this product |
Product Group | sf42_quotefx__SF42_Product_Group__c | As an alternative to the "Product" category, the price calculation can also refer to products of a product group. |
secondary Product Group | sf42_quotefx__SF42_Product_Group_2__c | Indicates the secondary product group, if applicable. Important: The product property then only applies to products that have exactly this combination of parent and child product group. |
The sections "Basic Configuration" and " Relations" are to be filled in the same way for all property types.
Calculation
Der Abschnitt "Kalkulation" legt den Operator , den Typ (Prozent oder Betrag) sowie den Kalkulationswert der Eigenschaft fest.
Field Name | API-Name | Function |
|---|---|---|
Operator | sf42_quotefx__SF42_calc_Operator__c | Sets the operator, and thus whether it is a markup or markdown. The choices are + , - , = |
Value Type | sf42_quotefx__SF42_calc_ValueType__c | Determines whether the value is absolute or relative. The choices are amount or percent. |
Calculation Value | sf42_quotefx__SF42_calc_Value__c | This value is used to calculate the property. For example, a configuration with the calculation value 100, the operator + and type Amount (€) calculates a markup of 100 € |
All three fields are mandatory, see the individual property types below for more details.
Special feature of the operator =
A product property with operator = overwrites the list price of the underlying product together with all previously entered product properties with price influence. So here the order of the different properties plays a role! Product Properties with Price Influence, which are inserted afterwards, are calculated on the basis of the new list price.
Property types
Property type “Number”
The specification of the "Number" type property is done in the "Additional for Number" section. The following fields are to be filled in here:
Field Name | API-Name | Function | Example |
|---|---|---|---|
Value 1 enabled | sf42_quotefx__SF42_Value1Enabled__c | Mandatory field, to be able to query a number, value 1 must be active |  |
Value 1 minimum | sf42_quotefx__SF42_Value1Min__c | Optional, at this point a lower limit can be defined | 2 |
Value 1 maximum | sf42_quotefx__SF42_Value1Max__c | Optional, an upper limit can be defined at this point | 15 |
Value 2 enabled | sf42_quotefx__SF42_Value2Enabled__c | Optional, with this checkbox another number field can be activated |
|
Value 2 minimum | sf42_quotefx__SF42_Value2Max__c | see above |
|
Value 2 maximum | sf42_quotefx__SF42_Value2Min__c | see above |
|
Calculation logic property type “Number”
Operator | Type | Example Calculation Value | Example Value 1 | Example Price Book Entry product (PBE) | Product property calculation | Example Calculated Value of property | End price in the quote | Example |
|---|---|---|---|---|---|---|---|---|
= | % | 10 | 25 | 1000 | = (PBE/100 * Calculation Value * Value 1) | 0 | Value of the property overwrites list price | 2500 |
+ | % | 10 | 25 | 1000 | + (PBE/100 * Calculation Value * Value 1) | 2500 | PBE + Value of property | 3500 |
- | % | 10 | 25 | 1000 |
| -2500 | PBE - Value of property | -1500 |
= | € | 10 | 25 | 1000 | = (10 * 25) | 0 | Value of the property overwrites list price | 250 |
+ | € | 10 | 25 | 1000 | + (10 * 25) | 250 | PBE + Value of property | 1250 |
- | € | 10 | 25 | 1000 |
| -250 | PBE - Value of property | 750 |
The sections - "Additional for Dropdown/Multipicklist", "Additional for Relation/Table" - do not matter for type "Number".
Property type “Checkbox”
With the property type "Checkbox" you can insert a checkbox as a product property. Only when this is set does the calculation defined in the “Calculation” section take effect.
The sections - "Additional for Dropdown/Multipicklist", "Additional for Relation/Table" and "Additional for Number" - are irrelevant for the "Checkbox" type.
Property type “Dropdown”
The specification of the "Dropdown" type property is done in the "Additional for Dropdown/Multipicklist" section. Here, the values available for selection must be entered in the "Dropdown Values" field - separated by commas, without spaces. At the same time, the associated calculation values must be entered in the "Dropdown Calculation" field.
Field Name | API-Name | Function |
|---|---|---|
Dropdown Values | sf42_quotefx__SF42_DropdownValues__c | Captures the characteristics available for selection, e.g. size, color, length... |
Dropdown Calculation | sf42_quotefx__SF42_DropdownCalc__c | With this value and the operators and types specified in the “Calculation” area, the property is calculated. A configuration of + 100 € calculates a markup of 100 € |
Calculation logic for type “Dropdown” and “Checkbox”
Operator | Typ | Example Price Book Entry product (PBE) | Example Calculation Value | Product property calculation | Example Calculated Value of property | End price in the quote | Example End price |
|---|---|---|---|---|---|---|---|
= | % | 75.000 | 50 | PBE/100 * Calculation Value | 0 | Value of the property overwrites list price | 37.500 |
+ | % | 75.000 | 50 | PBE/100*Calculation Value | 37.500 | PBE + Value of property | 112.500 |
- | % | 75.000 | 50 |
| -37.500 | PBE - Value of property | -37.500 |
= | € | 75.000 | 50 | Calculation Value | 0 | Value of the property overwrites list price | 50 |
+ | € | 75.000 | 50 | Calculation Value | 50 | PBE + Value of property | 75.050 |
- | € | 75.000 | 50 |
| -50 | PBE - Value of property | 74.950 |
Property type “Relation” and “Table”
Display in quote editor
Product Properties with Price Influence are requested in the quote editor when inserting the product and can also be edited later via the Product Details dialog:
The sum of the calculated properties is shown in a separate column in the product detail dialog:
In the quote itself, the product properties appear in a separate line, where the calculation value is also listed separately: