How to Use the ‘Use Value from Entity’ 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 entity values. For example, you may have discounts or markups for customers that are negotiated but change periodically. The “Use Value from Entity” option allows a Price Calculation to easily calculate based on an existing entity and the value assigned. Rather than creating a Price Filter for each discount percentage, it is based on a field from the entity and can easily be changed in Acumatica/Dynamics GP 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 values from an entity to further define pricing. The attributes from those entities, 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. Going forward, changes made in the Acumatica/Dynamics GP 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 Use Value from Entity option may be used with the following entities.

• Attribute Map
• Customer Attribute
• Document Attrubute
• Item Attribute
• Price Book (Price Sheet Detail – Amount)

The following steps detail how to create a single Price Calculation with the “Use Value from Entity” 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 Acumatica/Dynamics GP 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 Acumatica/Dynamics GP 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.

7. Click Customers from the Acumatica/Dynamics GP Data menu to see the list again.
8. Select a different Customer and click Edit.
9. Click Add New from the Customer Attribute Values grid.
10. From the Customer Attribute lookup, select Loyalty Discount.
11. Enter -20 as the Value.
12. 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 Entity 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.

 

Pricing Test 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.

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

6. Still in Pricing Scenarios, click Input Values tab.
7. Use the Customer lookup and select the Customer from step 13.
8. Select Item Cost w/ Cust Discount as the Price Schedule.
9. Click Execute.

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