As I prepare for my Dynamics 365 certification in sales (MB2-717), I am creating blog posts based on my revision. I hope that collectively these posts may prove useful to anyone also preparing for the MB2-717 exam. In this post I will review discount lists.

Recent posts have already covered other concepts related to the product catalog, this post will continue that theme by looking at 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 are completely optional. Often organizations will not offer volume discounts in this way but when volume discounts are needed their use will be essential.

Discount list maintenance can be found in the “Discount Lists” option with the product catalog. Found in the settings area of Dynamics 365.

A discount list can reduce the price based on a percentage or by a fixed amount. When you first create the list you’ll be prompted to pick which type of discount is required. Notice that if the discount is a fixed amount then the currency will also be required.

Having created the discount list you can add a number of possibly discount bands to each list. Each one is given a begin and end quantity. So 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 this 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’ve 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. (Rather than £6,000.)

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

Tip:
You might find discounting by percentage useful if operating in multiple currencies. As then the same discount list and be reused for all 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 MB2-717certification.
