Creating Price Rule Entries
You can create Dimension or Condition type price rule entries as per the requirement.
Dimension
- Go to ADMIN SETUP > Pricing Administration > Price Rulesets. The Price Rulesets page is displayed.
- Click the required price ruleset name link to open the Price Rulesets details page.
- Click the Price Rules tab.
- If there are existing metrices, click the required price rule name link to open the price rule details page.
- If there are no metrices created, create a price rule. For more information, see Creating a Price Rule.
- On the Entries tab, click Add. A price rule entry is added.
- Enter the following details:
Field
Description
<dimension>
Enter a value for the dimension.
The number of dimensions depends on how many dimensions you have configured for the price rule.
CPQ now supports wildcard entries ('*') for dimensions.
Adjustment Amount
Enter a percentage or a number to adjust the price.
Adjustment Type
Select the kind of adjustment required if the criteria is met. For example, an override to a list price, markup, or discount.
Adjustment Amount Source
Search and select a field from where the adjustment must be sourced.
- Click Formula Builder icon
to define the adjustment amount on price rule entry as an expression to have a dynamic adjustment value.
- Go to the Field tab and search for your desired field from the list. Click the arrow next to the field name to view and select its related child fields. The formula expression, determined by the selected object-field and/or subfield, appears on the right panel of the formula builder.
- Click Insert to add it to the expression.
- Go to the Functions tab, select a function from the list, and click Insert to add it to the expression.
- Click any operator available below the expression window to add it to the expression.
- Continue building your expression.
- Click Clear to remove the entire expression, or manually remove it by pressing the Backspace key.
- Click Save.
- Turn the setting Copy the current data in new row on to copy the details of a price rule entry to the next entry.
- In the Number of rows field, enter a value of how many rows you want to add.
- Click the ellipsis icon (
) for the entry and click Delete.
- If there are no unsaved changes, the Delete Price Rule Entry pop-up is displayed. Click Confirm.
- If there are unsaved changes, the a pop-up is displayed prompting your confirmation. Click Discard Changes. The Delete Price Rule Entry pop-up is displayed. Click Confirm.
- Click Save.
Condition
- Go to ADMIN SETUP > Pricing Administration > Price Rulesets. The Price Rulesets page is displayed.
- Click the required price ruleset name link to open the Price Rulesets details page.
- Click the Price Rules tab.
- If there are existing metrices, click the required price rule name link to open the price rule details page.
- If there are no metrices created, create a price rule. For more information, see Creating a Price Rule.
- On the Entries tab, click Add. A price rule entry is added.
- Click Add Condition. The Charge Type Criteria pop-up is displayed.
- On the Line Items tab, enter the following details:
- Field: Select a field on the product. You can select custom fields also.
- Operator: Select an operator.
- Value: Enter a value.
- Click Add Criteria to add one more criteria.
- Click the remove icon (
) to remove a criteria.
- Click Remove All to remove all criteria.
- Turn the Logic button on and enter a value in the Logic field when you add multiple criteria.
- Click Save. A criteria is added under the Condition column.
- On the Product Attributes tab, enter the following details:
- Field: Select a field on the product. You can select custom fields also.
- Operator: Select an operator.
- Value: Enter a value.
- Click Add Criteria to add one more criteria.
- Click the remove icon (
) to remove a criteria.
- Click Remove All to remove all criteria.
- Turn the Logic button on and enter a value in the Logic field when you add multiple criteria.
- Click Save. A criteria is added under the Condition column.
- On the Line Items tab, enter the following details:
- Enter the following details:
Field
Description
Adjustment Amount
Enter a percentage or a number to adjust the price.
Adjustment Type
Select the kind of adjustment required if the criteria is met. For example, an override to a list price, markup, or discount.
Adjustment Amount Source
Search and select a field from where the adjustment must be sourced.
Note:You can add dynamic adjustment amounts to price rule entries, using the formula builder to define expressions for both static values and formula fields.
- Click Formula Builder icon
to define the adjustment amount on price rule entry as an expression to have a dynamic adjustment value.
- Go to the Field tab and search for your desired field from the list. Click the arrow next to the field name to view and select its related child fields. The formula expression, determined by the selected object-field and/or subfield, appears on the right panel of the formula builder.
- Click Insert to add it to the expression.
- Go to the Functions tab, select a function from the list, and click Insert to add it to the expression.
- Click any operator available below the expression window to add it to the expression.
- Continue building your expression.
- Click Clear to remove the entire expression, or manually remove it by pressing the Backspace key.
- Click Save.
- Turn the setting Copy the current data in new row on to copy the details of a price rule entry to the next entry.
- In the Number of rows field, enter a value of how many rows you want to add.
- Click the ellipsis icon (
) for the entry and click Delete.
- Click Save.
