Skip to main content

Notifications

Announcements

No record found.

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

Sales Pricing with multiple hierarchy

Posted on by 219

Hi:

We have the below sales pricing setup hierarchy:

For one specific item, the price is:

For all customers: 10.00.

For a specific Customer Pricing Group:20.00

For a specific Customer:30.00.

I create a SO for that specific Customer,

It seems the standard function of NAV is picking up the lowest price , in this case, the 10.00. but what I need is 30.00.

Could you please help to advise, how to resolve this? thanks.

Regards,

Lanqing.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Pricing with multiple hierarchy

    Lanqing,

    Adding to Nitan's reply... NAV will select the Lowest Price based on the Sales Price and Discount setup. If you have a Sales Price for the Customer for 100.00 which is defined directly to the customer and you have included that customer in an ALL Sales Price for a lower price, it will select the lower price if the Sales Price is effective and the same UOM.

    Is this the case? If yes, not sure why 1 Customer is higher, but I would create a Sales Price Group that includes all Customers except the one you want to charge a higher price. You can use the Sales Price Worksheet to help create the Group.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Sales Pricing with multiple hierarchy

    Hi,

    Have you defined any price group in Customer card, can you share me Invoicing tab screen shot from customer card?

  • qjwlq Profile Picture
    qjwlq 219 on at
    RE: Sales Pricing with multiple hierarchy

    Hi,

    It looks like standard function of NAV, the system is picking up the lowest price, per my test:

    1. All customer price=10

      specific customer price=20

    then the program picks 10 for this specific customer.

    2. All customer price=30

      specific customer price=20

    then the program picks 20 for this specific customer.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Sales Pricing with multiple hierarchy

    Please check if you have not put any Unit of measure on Sales Line, Also please check your customer invoicing tab.

  • qjwlq Profile Picture
    qjwlq 219 on at
    RE: Sales Pricing with multiple hierarchy

    ask_2D00_0.png

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Sales Pricing with multiple hierarchy

    Can you please show me screen shot of your Sales price setup? Also please share Customer card screen shot of Invoicing tab.

    It must be like this

    pastedimage1650609539281v1.png

    Thanks

  • qjwlq Profile Picture
    qjwlq 219 on at
    RE: Sales Pricing with multiple hierarchy

    Hi,

    The Below is my setup:

    For all customers: 10.00.

    For a specific Customer Pricing Group:20.00

    For a specific Customer:30.00.

    The 30.00 is assigned to one specific customer, but NAV is picking 10.00 instead of 30.00

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Sales Pricing with multiple hierarchy

    Hi,

    Can you please share your Sales Price setups for your customer?

    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