As I prepare for my Dynamics 365 certification in sales (MB 210), I’m creating blog posts based on my revision. I hope that collectively these posts may prove useful to anyone also preparing for the MB 210 exam. This time I will cover the concepts around discount lists.

Below you can see the skills measured statement that refers to the product catalog. From this we can learn that the product catalog covers many topics including product families, bundles, price lists, discount lists and much more. Because of this I intend to take several posts to cover all of the details connected with the product catalog. In this post I’ll cover the concept of discount lists.

I have already described how to create products, define the units they will be sold in and define associated price lists. But what if you want to discount based on the volume quoted / purchased. This is when discount lists come into play.

The use of Discount lists is completely optional. Often organizations will not offer volume discounts in this way but when volume discounts are needed their use will may be essential.

Discount list maintenance can be found in the “Discount Lists” option. Within the Sale Hub App, if you select “App Settings” will be able to find the discount lists option.

A discount list can reduce the price based on a percentage or by a fixed amount. When you first create the list you’ll need to pick which type of discount required.

Tip: If the discount is an amount then the currency will also be required!

To access the discounts to be applied on a discount list, use the related tab and select discounts. (You do this once you have saved the list!)

Having created the discount list you can add a number of discount bands to each list. Each one is given a begin and end quantity. For example, you might give a £2 discount if the customer purchases between 300 and 500 items. Then £5 is they purchase 501 to 1000 items. (per item)

Note: Ranges can’t overlap. Meaning only one discount will ever apply.

This same logic is applied to a percentage discount list when the percentage amount might grow based on a sliding scale of the volume required.

Having created the discount list and the bands of discounts within it, you can assign this discount list to each price list item that requires a volume discount. Below you can see that I have added a discount list to my product “Sweetcorn”.

As an example, below you can see that on my opportunity I have added 1 case, 300 cases and 600 cases of sweetcorn. The unit price of one case is £10. Making 300 cases worth £3,000. Without any discount.

But because I offered a £2 discount for 300+ units. My final price is £2,400 for 300 units. (Equating to £8 per unit instead of the default £10.) And because I offered a £5 discount for 501+ units, the price for 600 units becomes £3,000.

Discounting by percentage would work in a similar way but that a percentage amount would be deducted.

You might find discounting by percentage useful if operating in multiple currencies. As then the same discount list could be reused for multiple currencies.

Hopefully you can see that discount lists are pretty simple to create and associate with price list items. It is important to ensure you are aware of the concepts behind discount lists for the MB 210 certification.