web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 106
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)
  • Jim Oskarsson Profile Picture
    106 on at
    Price logic - why is Business Central not using the lowest price?
    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
  • Suggested answer
    Valentin Castravet Profile Picture
    28,361 Super User 2025 Season 2 on at
    Price logic - why is Business Central not using the lowest price?
    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.
  • Suggested answer
    YUN ZHU Profile Picture
    90,019 Super User 2025 Season 2 on at
    Price logic - why is Business Central not using the lowest price?
  • Jim Oskarsson Profile Picture
    106 on at
    Price logic - why is Business Central not using the lowest price?
    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
    Valentin Castravet Profile Picture
    28,361 Super User 2025 Season 2 on at
    Price logic - why is Business Central not using the lowest price?
    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.
     
  • Suggested answer
    YUN ZHU Profile Picture
    90,019 Super User 2025 Season 2 on at
    Price logic - why is Business Central not using the lowest price?
    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

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,725 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,610

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,221

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans