web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Sales invoice discount...
Small and medium business | Business Central, N...
Unanswered

Sales invoice discounts - for all items sold

(0) ShareShare
ReportReport
Posted on by VISOL - Sanja Laban 10

Hello everyone... we need an advanced setup of sales invoice discounts, so I'm interested in your experiences and idea:
1. how to solve it in standard BC solution, if possible
2. which improvements (customization) you think that would be best to solve this problem

Our client has groups of articles to which he wants to grant a discount if the sum of all quantities (lines) on the invoice (belonging to that group of articles) exceeds a certain minimum.

For example item from group A appears on the invoice in 4 lines (because selling location or dimension are different). In the first line the quantity is 100, in the second 50, in the third 50 and in the fourth 100. The adjustment of the discount is as follows:
if more than 100 items from group A were sold on the invoice, a 5% discount must be deducted from all items in group A. If 200 items were sold, the discount is 10%, etc.

Thanks in advance for your help!

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,772 Super User 2025 Season 2 on at

    This feel like a customization is needed. As standard system checks discounts only on line level and it is not possible to group items.

    I would say You need a customization - to create

    Item Groups (table and page, enough with just 2 fields - Code and Description)

    Add Item group field in Item card.

    In Item discounts (Sales/Purchase) (new version would be Price List Line (table 7001)) Add option in "Product Type" drop down list also for Item group and provide the minimum quantity 100 and discount 5%, and another line for Min=200, Discount 10%.

    Then on Sales Order - on Release button add code for re-calculating the discounts for Item Groups and adjust all lines.

    I am pretty sure there are at least a few extensions that can achieve this, but I haven't worked with such, so cannot advise any.

  • DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    hi

    look this

    community.dynamics.com/.../sales-order-invoice-with-payment-discount---belgium

    DAniele

  • VISOL - Sanja Laban Profile Picture
    VISOL - Sanja Laban 10 on at

    Dear Daniel,

    Thank you, but we do not need an payment discount. We need an group items discount not depending on one line.

    Thank you for your suggestions. BR, Sanja

  • VISOL - Sanja Laban Profile Picture
    VISOL - Sanja Laban 10 on at

    Dear Kaspars, thank you. I do not want to lost standard functionality to define discount on one item/gropu/customer etc. I think that I will on price list add an boolean which will said "calculate for invoice" and I will add new function "calculate line discount depending on invoice quantity"

    Do you think it will work? Beat regards, Sanja

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,772 Super User 2025 Season 2 on at

    With customization there are multiple ways how this can be achieved and without knowing business and scenarios, hard to tell the most effective to cover all cases.

    Talk with developer / or if You are the developer, talk with business user about the cases that could happen.

  • VISOL - Sanja Laban Profile Picture
    VISOL - Sanja Laban 10 on at

    Dear Kaspars, I am an Business Central system architect, but I wish to made consultation with community on this task. Usually, I am trying to keep standard solutions whenever I can, but I didn't find right way in this case. We will do extension for bulk items line discount.

    Thank you for your time and sharing experiences.

    Best, Sanja

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans