Skip to main content

Notifications

Dynamics 365 Community / Blogs / Dynamics CRM Tip of the Day / Tip #326: Defaulting to “Ex...

Tip #326: Defaulting to “Existing” Opportunity Products

Community Member Profile Picture Community Member Microsoft Employee

In Dynamics CRM 2013 and 2015, if you use the opportunity line item (opportunity products) subgrid, when you click the + sign, you get the choice to add an existing product or a write-in product.

Screenshot 2015-02-16 20.35.36

But sometimes you don’t want users to use write-in products. If the users must sell something from the price list, the option to use write-in products presents a potential issue, as it can allow users to create unauthorized opportunity products. That is why some CRM implementers decide to remove the standard opportunity product subgrid and add a custom opportunity product subgrid to the form, or display the Opportunity Products navigation bar item.

In CRM 2013, if you create an opportunity product from the navigation bar or a custom subgrid, the Opportunity Products form will open and the “Select Product” two-option field will default to “Existing.” This makes the product lookup available and the write-in product field disabled.

In CRM 2015, users have noticed that if you create an opportunity product from the Opportunity Product form, the “Select Product” field will now default to “Write-in,” which makes the Product lookup field disabled and enables the Write-in product field.

To change this behavior back to the way it used to work, you can use a business rule. Note the “set default’ business rule action will not apply here, as two option fields naturally have a default value. However, you can force the use of existing products with a business rule that changes “Select Product” to “Exisitng” if “Select Product” equals ‘Write-in.”

Screenshot 2015-02-17 07.14.05

Note that this approach effectively prevents users from ever using write-in products.

Comments

*This post is locked for comments