How to Use the ‘Use Value from Attribute’ Option on a Price Calculation in RPM for a Specific Discount or Markup

Subject

This article describes how to set up pricing in RPM to accommodate changes to attribute values. For example, you may have discounts or markups for customers that are negotiated but change periodically. The “Use Value from Attribute” option allows a Price Calculation to easily calculate based on an existing Customer/Item Attribute and the value assigned. Rather than creating a Price Filter for each discount percentage, it is based on the attribute assigned and can easily be changed in the ERP without having to maintain it in RPM.

The steps in this article are specific to customer discounts, follow the same steps if you want to use markups for your pricing. These same steps also apply to Item Attributes.

More Information

When setting up pricing in RPM, you can use Customer Attributes and/or Item Attributes to further define pricing for customers and items. Those attributes, combined with other Pricing Filters and Price Calculations, provides an automated and powerful price generation process. For example, a company offers a discount amount that varies by each customer. During the implementation, these attributes are assigned to the Customers and Items. Going forward, changes made in the ERP related to the values for those attributes are captured in RPM. This makes it easy to maintain your pricing without having to go into RPM and updating the price information.

The following steps detail how to create a single Price Calculation with the “Use Value from Attribute” option in RPM to accomplish unique discounts for 2 different customers.

Note: The steps here include how to create a new Customer Attribute, but this is for testing purposes. Typically, the Customer Attribute is included from the ERP during the implementation.

Create Customer Attribute

  1. In RPM, open Customer Attributes from the ERP Data menu.
  2. Click Add New.
  3. Enter a Name and Description to specify the Customer Attribute.
  4. Select a Data Type of Number.
  5. Click Save.

Assign to Customer

  1. Open Customers from the ERP Data menu.
  2. Select a Customer and click Edit.
  3. Click Add New from the Customer Attribute Values grid.
  4. From the Customer Attribute lookup, select Loyalty Discount.
  5. Enter -10 as the Value.
  6. Click Save.

  1. Click Customers from the ERP Data menu to see the list again.
  2. Select a different Customer and click Edit.
  3. Click Add New from the Customer Attribute Values grid.
  4. From the Customer Attribute lookup, select Loyalty Discount.
  5. Enter -20 as the Value.
  6. Click Save.

Create Price Calculation

  1. Open Price Calculations from the Pricing menu.
  2. Click Add New.
  3. Enter a Name for the Price Calculation.
  4. Select Percent Adjustment as the Price Mode option.
  5. Mark the Modify Unit Price checkbox.
  6. Mark Use Value from Attribute checkbox.
  7. Select Customer as the Entity.
  8. Select Loyalty Discount as the Customer Attribute.
  9. Click Save & Close.

Assign to Price Schedule

  1. Open Price Schedules from the Pricing menu.
  2. Click Add New.
  3. Enter a Name for the Price Schedule.
  4. Mark Is Active checkbox.
  5. Select Item Cost as the Price Source Option.
  6. Click Save.
  7. Click Add New from the Price Calculations grid.
  8. Highlight Loyalty Discount and click Select.
  9. Click Save & Close to close Price Schedules.

Test Pricing Scenario

  1. Open Pricing Scenarios from the Tools menu to run a pricing test within RPM.
  2. Click Add New.
  3. Make the following selections
    • Item Cost w/ Cust Discount as the Price Schedule.
    • Item.
    • Unit of Measure.
    • Currency
    • Select the Customer from step 7.
  4. Click Execute.

  1. On the Results tab, click View Diagnostics and see the item price calculation, along with the customer discount.

  1. Still in Pricing Scenarios, click Input Values tab.
  2. Use the Customer lookup and select the Customer from step 13.
  3. Select Item Cost w/ Cust Discount as the Price Schedule.
  4. Click Execute.

  1. On the Results tab, click View Diagnostics and see the item price calculation, along with the customer discount.