Pricing in Dynamics 365 Business Central, Part III: Sales Line Discounts

By Noelle Super | April 17, 2019

While setting up your varied pricing rules at the item level and updated your pricing in bulk using Dynamics 365 Business Central tools will enable you to manage sales prices, you may want to set up sales discounts separately. Discounts allow you to show savings to the customer separately from the item price on the sales quote, order or invoice.  Discounts can be used in combination with sales prices, or independently.

Sales Line Discount Setup

From the desired item card, go to Special Sales Prices & Discounts -> Set Special Discounts.

Sales Line Discounts

In the Sales Type field, choose who the pricing should be assigned to.  You may choose a specific customer, a customer group (as assigned on a customer card), all customers, or for a campaign.

Sales Line Discounts

In the Sales Code field, choose the value related to the selection in Sales Type.  For example, if we choose to assign a sales price to a customer, the Sales Code drop down will bring up the customer list.

Sales Line Discounts

You may choose a minimum quantity that must be purchased for this discount to be valid.

Sales LIne Discounts

Enter the discount percent in the Line Discount % field.

Sales Line Discounts

If desired, select a Starting Date and Ending Date.

Item Groups

Sales line discounts can also be assigned by item discount groups.  The item discount group is assigned in the Prices & Sales FastTab of the item card.

Sales Line Discounts

To assign the sales line discount by item group, from the Sales Line Discounts screen, update the Type Filter in the header to Item Discount Group.

Sales Line Discounts

Complete the fields in the lines section of the Sales Line Discounts card as usual.

Sales Line Discounts

Allowing and Disallowing Discounts

If you are using special prices in combination with line and invoice discounts, you may wish to prevent the combination of these two settings on a sales document.  You may also have exception cases, where you do not want a discount to apply to a specific customer, item or item group.  There are several places in Business Central where you can manage the eligibility of discounts:

  • Sales Prices
  • Customer Price Groups
  • Customer Cards
  • Item Cards
  • Sales Lines

In the example below, on the customer price group table, we have disabled invoice and line discounts on the “Small” customer group.

Sales Line Discounts

Being able to easily tailor pricing and discounts speeds up the quote to cash process and helps your sales team add to your bottom line while increasing customer satisfaction. Learn more about managing pricing in Business Central or by reach out to the professionals at Stoneridge Software.


Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.

Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!