Download PDF
Download page Configuring Price Matrix Entries.
Configuring Price Matrix Entries
Dimension
- Go to ADMIN SETUP > Pricing Administration > Price Lists. The Price Lists page is displayed.
- Click the required price list name link to open the Price Lists details page.
- Click the Price List Items tab.
- Click the advanced setup icon
next to a price list item name. The price list item details page is displayed.
- Click the Metrices tab. The list of existing metrices is displayed.
- Click the required price matrix name link (Dimension type matrix) to open the price matrix details page.
On the Entries tab, click Add. A price matrix entry is added.
Enter the following details:
Setting Description Start Date This field is visible only if you turn the Enable Date Range setting on while creating the price matrix.
Select a start date for the matrix entry. It is a mandatory field.
End Date This field is visible only if you turn the Enable Date Range setting on while creating the price matrix.
Select an end date for the matrix entry. It is a mandatory field.
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 Matrices 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 matrix 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 Matrix 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 Matrix Entry pop-up is displayed. Click Confirm.
- Click Save.
Condition
- Go to ADMIN SETUP > Pricing Administration > Price Lists. The Price Lists page is displayed.
- Click the required price list name link to open the Price Lists details page.
- Click the Price List Items tab.
- Click the advanced setup icon
next to a price list item name. The price list item details page is displayed.
- Click the Metrices tab. The list of existing metrices is displayed.
- Click the required price matrix name link (condition type matrix) to open the price matrix details page.
On the Entries tab, click Add. A price matrix 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.
- 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.
- On the Line Items tab, enter the following details:
Enter the following details:
Setting Description Start Date This field is visible only if you turn the Enable Date Range setting on while creating the price matrix.
Select a start date for the matrix entry. It is a mandatory field.
End Date This field is visible only if you turn the Enable Date Range setting on while creating the price matrix.
Select an end date for the matrix entry. It is a mandatory field.
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 Matrices 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 matrix 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 Matrix 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 Matrix Entry pop-up is displayed. Click Confirm.
- Click Save.
Usage
For Usage type price matrix entries, either Unit Price or Flat Price is required, not both.
- Go to ADMIN SETUP > Pricing Administration > Price Lists. The Price Lists page is displayed.
- Click the required price list name link to open the Price Lists details page.
- Click the Price List Items tab.
- Click the advanced setup icon
next to a price list item name. The price list item details page is displayed.
- Click the Metrices tab. The list of existing metrices is displayed.
- Click the required price matrix name link (usage type matrix) to open the price matrix details page.
On the Entries tab, click Add. A price matrix entry is added.
Enter the following details:
Setting Description From Enter a value. To Enter a value. Start Date This field is visible only if you turn the Enable Date Range setting on while creating the price matrix.
Select a start date for the matrix entry. It is a mandatory field.
EndDate This field is visible only if you turn the Enable Date Range setting on while creating the price matrix.
Select an end date for the matrix entry. It is a mandatory field.
Unit Price Enter a unit price.
If you enter Unit Price, do not enter Flat Price.
Flat Price Enter a flat price.
If you enter Flat Price, do not enter Unit Price.
Is Included Turn this setting on to indicate if the entry is included. - Turn the setting Copy the current data in new row on to copy the details of a price matrix 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 Matrix 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 Matrix Entry pop-up is displayed. Click Confirm.
- Click Save.