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

Sales Pricing with multiple hierarchy

(0) Share

Report

Posted on by qjwlq

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.

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Nitin Verma 21,684 Moderator on at

Like (0)

Report

RE: Sales Pricing with multiple hierarchy

Hi,

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

Thanks

Was this reply helpful? Yes No
qjwlq 219 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,684 Moderator on at

Like (0)

Report

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

Thanks

Was this reply helpful? Yes No
qjwlq 219 on at

Like (0)

Report

RE: Sales Pricing with multiple hierarchy

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,684 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
qjwlq 219 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,684 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No