In our last few discussions we have focused on the Product Catalog enhancements. And in this discussion we will look at the Custom Price Calculation feature, which is related to the Product Catalog enhancement.
As we know, the pricing engine in Microsoft Dynamics CRM supports a standard set of pricing and discounting methods. These standard fields and methods might be a limitation on your business depending on your specific requirements for applying taxation, discounts, and other pricing rules for your products.
Suppose we need to identify and apply additional Taxes, like GST, VAT, Stamp Duty, or state and federal taxes independently on each line items. This would have been very difficult to achieve in previous versions of Dynamics CRM, because only one Tax field on line items was available. If we created custom fields for additional taxes, then it was really hard to include those in the calculation of the Extended Amount on each line item.
But now it is easy in CRM 2015, we can apply the Custom Price Calculation on the following entities.
- Opportunity Product
- Quote Product
- Order Product
- Invoice Product
To use the custom pricing for your opportunities, quotes, orders, and invoices, you need to do the following things:
1. Set the value of the OOBPriceCalculationEnabled attribute to false from System Settings, as shown below.
2. Create a plug-in that contains your custom pricing logic for calculating the price for your opportunity, quote, order, or invoice and on corresponding line items.
3. Register the plug-in on the CalculatePrice message on Post stage.
When the OOBPriceCalculationEnabled attribute is set to 0, every time an opportunity, quote, order, or invoice is created or changes, the plug-in registered on the CalculatePrice executes to calculate prices as specified in your custom code in the plug-in. The CalculatePriceRequest message doesn’t have any usage scenario of its own. It’s exposed so that you can plug in your own custom pricing calculation logic if you don’t want to use the out-of-box pricing provided by CRM.
If you want to revert to using the out-of-box pricing for your opportunities, quotes, orders, and invoices, set the value of the OOBPriceCalculationEnabled attribute to True.
We had one scenario in which we need to apply the GST and VAT based on the Amount and calculate the Extended Amount on the Quote Product, as shown below.
As you can see in the above screen shot, we are calculating GST and VAT based on the Amount, and all taxes have been included in calculating the Extended Amount.
For example, we used the following logic in our plug-in.
decimal total = 0;
decimal vat = 0;
decimal gst = 0;
decimal extended = 0;
total = total + ((decimal)e["quantity"] * ((Money)quoteItem["priceperunit"]).Value);
gst = total * (decimal)0.08;
vat = total * (decimal)0.1;
extended = total + gst + vat;
quoteItem["baseamount"] = new Money(total);
quoteItem["tax"] = new Money(gst);
quoteItem["new_vat"] = new Money(vat);
quoteItem["extendedamount"] = new Money(extended);
And we have registered that plug-in on Post stage of CalculatePrice Message of Quotedetail, as shown below.
If you want to implement the Custom Pricing calculation, then you can use the sample plug-in which is provided by Microsoft, and that will really help you and save your lot of time. Below I have given the URL of that plug-in example.
Again below we have given some important facts about the custom pricing calculations.
- You must set the OOBPriceCalculationEnabled value to False to enable the custom pricing calculation.
- You must register the plug-in on the Post Stage of the CalculatePrice message.
- Once you have enabled the custom pricing calculation, then the Amount and Extended Amount on line items and all totals on headers will no longer be system calculated. And you have to register your plug-in for these calculations.
- Also one most important thing is that, it seems that when you enable the Custom Pricing, then the calculation happens in asynchronous mode, hence you need to refresh the form to view the changes, if you change Price or Quantity within line items.