Download PDF
Download page Creating Price Rule Entries.
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 Validate to check your formula. The application verifies the formula and displays a confirmation message if it is valid. If the formula is invalid, an error message is displayed.
- 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. 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 Validate to check your formula. The application verifies the formula and displays a confirmation message if it is valid. If the formula is invalid, an error message is displayed.
- 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.