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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Price logic - why is Business Central not using the lowest price?

(1) ShareShare
ReportReport
Posted on by 152
Hi,
 
We have customer that want to use a pretty simple and common price strategy but to our surprise we are not able to solve that with standard functionality in Business Cental.
 
Here is the case:
 
Standard price:
The price that is registered on the items. Let's say 100 $ in this example.
 
Discount:
Discounts are set on item discount groups and combined with customer discount groups. In this example the combination of customer discount group and item discount group gives a discount of 20%.
 
Campaign price:
A sales price list for all customers that contain prices for some items that are valid for a limited time period. In this example the campaign price is 90 $.
 
The problem:
Some customers have good discounts through their customer discount group which means their normal net price (standard price minus discount) is better than the current campaign price. But BC does not honor this, it gives the campaign prize even if that gives some customers a higher net price than they are entitled to through their customer discount group.
 
In the example above we would like the price to be 100 $ minus 20 % = 80 $ but Business Central gives us the price 90 $.
 
Is there any way to change this behaviour so that the customers always get the lowest net price that they are entitled to?
 
Thanks,
Jim
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    99,086 Super User 2026 Season 1 on at
    As far as I know this can't be done.
    The system will only take the lowest price, but not the lowest price after calculation. This should require some customization.

    Hopefully other experts can give you better advice.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    32,208 Super User 2026 Season 1 on at
    The system uses a 'Best Price Calculation' logic to determine the lowest price, factoring in both unit prices and line discounts. More info here: Record special sales prices and discounts - Business Central | Microsoft Learn
     
    Some possible reasons its not working for you - are the discounts line discounts or invoice discounts? As far as I know the system will calculate the best price based on line discounts and not invoice discounts. Also, perhaps you checked off allow line discounts?
     

    Edit: I misread the question initially. Yes, it appears you’ll need to customize the system. The standard best price logic is somewhat simplified, in a way that it stops as soon as it finds the lowest price and doesn’t account for all scenarios i.e. a 2nd scenario where a higher price + discount leads to a lower overall unit price.
     
  • Jim Oskarsson Profile Picture
    152 on at
    Thanks for your answers Valentin and Yun,
     
    I believe we will have to extend the price calculation (https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-best-price-calculations) to be able to solve the customer's issue.
     
    If somebody has a suggestion how to solve it without coding, please share it.
     
    Best regards,
     
    Jim
  • Suggested answer
    YUN ZHU Profile Picture
    99,086 Super User 2026 Season 1 on at
  • Suggested answer
    Valentin Castravet Profile Picture
    32,208 Super User 2026 Season 1 on at
    I misread the question initially so I think you're right, Yun. The standard best price logic is simplified; it stops as soon as it finds the lowest price without considering all scenarios, such as cases where a higher price combined with a discount might result in a lower overall unit price.
  • Jim Oskarsson Profile Picture
    152 on at
    We are already using the new price experience for this customer.
     
    Thanks again Valentin och Yun for your input on this issue. Good for us to know that this demands customizing before we decide what to do.
     
    Best regards,
     
    Jim

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,993 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,116 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans