Small and medium business | Business Central, N...

Minimum Quantity for Item range versus single items

(3) Share

Report

Posted on by JC-15070655-0

I am looking for a solution or App that makes it possible for volume discounts to be applied for multiple items in the same range. For example if I have a Pallet deal with a minimum of 96 cartons i can set this up on the individual line level but also want the discount to be applicable when someone orders for example 12 CTNS of 8 different colours in the same range.

Is there any way to do this in business central latest version?

Cheers

Joseph

Categories:

Dynamics 365 Business Central

All responses (9)

Answers (0)

Vahid Ghafarpour 10,722 Super User 2025 Season 1 on at

Like (1)

Report

Minimum Quantity for Item range versus single items

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!
Suggested answer

Suresh Kulla 47,212 on at

Like (0)

Report

Minimum Quantity for Item range versus single items

If you’re indicating that some discounts are applied based on other items, then it requires a different module or customization. I made a similar modification earlier, and we have separate price and discount tables to manage them.

I highly recommend checking App Source, as there are some apps that offer enhancements beyond standard discounts and pricing.
Suggested answer

Jainam M. Kothari 7,355 on at

Like (1)

Report

Minimum Quantity for Item range versus single items

It will require Customization as per your requirement.
Suggested answer

Saif Ali Sabri 1,997 Super User 2025 Season 1 on at

Like (0)

Report
Minimum Quantity for Item range versus single items

https://learn.microsoft.com/en-us/dynamics365/commerce/retail-discounts-overview

https://learn.microsoft.com/en-us/dynamics365/commerce/optimal-combination-overlapping-discounts
follow the above link.
To apply volume discounts for multiple items within the same range in Microsoft Dynamics 365, you can utilize the supplementary categories feature. Here's how:

Create a Supplementary Category: Group the items that you want to include in the volume discount into a single supplementary category. This allows you to treat these items as a single entity for discount purposes.

Configure Quantity Discount for the Category: When setting up the quantity discount, instead of applying it to individual items, configure it to apply to the supplementary category you created. This way, the system will consider the combined quantity of all items within that category to determine if the discount should be applied.

This approach allows you to offer volume discounts when a customer orders a combined quantity of different items within the same range, addressing the scenario described in the forum thread.
Suggested answer

Ben Baxter 5,661 Super User 2025 Season 1 on at

Like (1)

Report

Minimum Quantity for Item range versus single items

Please ignore the AI garbage from Saif Ali Sabri, that does not work. It will require a customization.

Best Regards,

Ben Baxter

Accent Software Inc
Suggested answer

Khushbu Rajvi. 16,027 Super User 2025 Season 1 on at

Like (1)

Report

Minimum Quantity for Item range versus single items

it will require customization.
Suggested answer

Saif Ali Sabri 1,997 Super User 2025 Season 1 on at

Like (0)

Report
Minimum Quantity for Item range versus single items

Yes, in Microsoft Dynamics 365 Business Central (latest version), you can achieve this using Sales Line Discounts with "Discount Groups" or by leveraging Extended Pricing Management. Here’s how:
Solution Options:
1. Use Item Discount Groups (Standard Functionality)

Navigate to Sales & Marketing > Pricing & Discounts > Item Discount Groups.

Create a discount group and assign all color variations of the item.

Set up Sales Line Discounts based on the total quantity within the discount group.

When a customer orders different colors (but reaches the minimum quantity), the discount applies.

2. Use Extended Pricing (For More Flexibility)

If using "Pricing Experience = Advanced" in Feature Management:

Set up Special Prices based on item category or attributes.

Define price breaks based on total quantity across variations.

Business Central will automatically apply discounts when multiple colors meet the total quantity.

3. Custom Extension (If Needed)

If the standard options don’t fully meet your needs, a Power Automate flow or AL extension could be developed to sum quantities across multiple lines before applying a discount.
Suggested answer

Teddy Herryanto (Th... 13,535 Moderator on at

Like (1)

Report

Minimum Quantity for Item range versus single items

It's not available in standard.

I haven't heard of any third party apps in AppSource that deals with it.
Suggested answer

YUN ZHU 82,093 Super User 2025 Season 1 on at

Like (0)

Report

Minimum Quantity for Item range versus single items

As far as I know, this cannot be done in BC26, and customization is still required.
I hope other experts can give you better suggestions.

Thanks

ZHU