Validate Selling Price for Item Against Purchase Rate or Valuation Rate not working

ERPNext Selling/CRM
1

The Validate Selling Price for Item Against Purchase Rate or Valuation Rate is not working.

I saw it work before so I don’t know why it doesn’t work now.

Maybe I forgot about something.

What are the requirements for it to work?

So far I tried:

  • Enabling it in the Selling Settings
  • Setting the Valuation of the Item for example 300€.
  • Setting the Item Price to 5€.
  • Trying to order it through the Webshop.

No Error about the value appears.

I know I had this working a few months ago and then I disabled it. Now I don’t know why and how to make it work again.

Some error is supposed to happen when ordering it right?

2

Hi @Smooth_Play,

You need to enable the “Validate Selling Price for Item Against Purchase Rate or Valuation Rate” option in the Selling Settings. Then, configure your items correctly. For instance, if you have an item “Item-123” with a valuation rate of ₹300 and you set its selling price to ₹5 in the price list, the system should check these values when you create a sales order or invoice. If the selling price of ₹5 is lower than the valuation rate of ₹300, the system will trigger an error message, preventing the sale at that low price.

We tested it in v15 and v14, it’s worked properly.

image
image1920×924 35.9 KB

I hope this helps!

3

Thank you for your quick response,

I saw it working before, now It doesn’t work at all. I’m on v15.

Already cleared-cache and bench build. Still nothing.

It also used to work on the Webshop for the Client when he sets the item in the Shopping Cart.

Nothing appears on the logs. Weird.

4

It will work on “Sales Order”, “Delivery Note”, and “Sales Invoice”. so check it.

5

It’s not working anywhere :S I even tried to recover an old backup from when it used to work, but strangely enough, it just doesn’t, not even on Sales Order.

Do I have to set some percentage anywhere? ( the tolerance )

6

again read it. check your last purchase rate and item valuation rate.

7

image
image1388×225 21.6 KB

image
image1388×437 25.2 KB

image
image1388×437 11.6 KB

With all this setup, the sales order was made without any error.

I tried deleting all Tax Rules and Price Rules to check if that was the cause.

Still not working for me.

8

Item valuation rate, not item master valuation rate. Please check it.

1 Like
9

It worked! Thank you!

My bad, my mistake.

Basically to Test it out one needs to make the Purchase to the Supplier, not setup the Item Master Valuation Rate.

Thanks again and forgive me for taking your time.