Skip to main content

Notifications

Announcements

No record found.

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

Why NAV is picking cheapest price when multiple pricing conditions are defined

Posted on by 219

The below quoted are in the book: Microsoft DynamicsNAV2016 Financial Management, page 18

--------------

When multiple pricing conditions are met, the price that is used is the one

that is most favorable to the customer (the cheapest one).

Imagine Customer 10000 belongs to the RETAIL price group. On

20/01/2017 he buys 20 units of item 1936-S. There are three different

prices that could be used: the one defined for him, the one defined for its

price group, and the one defined to all customers when they buy at least

11 units. Among the three prices, 130.20 is the cheapest one, so this is the

one that will be used.

-----------------

we defined a price for all customers, and for several specific customer, say 100, we defined special price for his own, say 150,, NAV is picking the cheapest one 100, this is not we need.

could you please help to advise, how to resolve this? 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    RE: Why NAV is picking cheapest price when multiple pricing conditions are defined

    Hi, The problem of the Best Price Calculation has always existed in NAV. You can contact your Partner and comment out this part of the standard code to solve this problem.
    We have some clients that do this. But this requires customization.

    Also, as mentioned by several other experts, in Business Central, new sales pricing experience is available.

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-best-price-calculations

    pastedimage1651453532082v1.png

    pastedimage1651453543200v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Why NAV is picking cheapest price when multiple pricing conditions are defined

    qjwlq,

    Adding to the other replies... Dynamics NAV Sales Pricing will determine the lowest price eligible for the Customer. Your example shows ALL Customers at 100 and 1 Customer at 150. The Customer with 150 is also included in ALL therefore 100 is the price. Not sure why the price is higher but I would create a Customer Price Group, that excludes the Customer with 150.

    As Kim mentioned, in Business Central v19.5, you have additional Pricing options that you can define how it works for the old rule of Lowest.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Why NAV is picking cheapest price when multiple pricing conditions are defined

    By design NAV gives the customer the best price. The pricing structure in NAV 2018 does look for the best price to the customer, your scenario makes it hard to affect the desired price to the customer.

    In the version BC 19.5 there is a new pricing structure to help us price as desired and not live with the above pricing design of 'find the cheapest.'

    If you want to be assured of the price that each customer will get, define by customer by item. Which means that price groups are not used....This means a great deal more setup and maintenance but that's what is needed.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Why NAV is picking cheapest price when multiple pricing conditions are defined

    Hello,

    If you do not get further traction from the community, feel free to raise this issue to Microsoft via your partner or CSP.

    Thanks.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans