Validation rule to control Sales Price reduction

Question

I created the following VR in order to avoid that th user manually reduce the Sales Price once it has been calculated.

He/she can manually increase but price reduction can be obtained only by using the discount field.

Even if the formula is correct when I test it I can easlity reduce the price and any error message is displayed.

Any suggestion?

Akhil Anil · Accepted Answer

Hi Mimma,   Can you give this a shot ?     AND( ISCHANGED(UnitPrice), PRIORVALUE(UnitPrice) >  UnitPrice, OR( ISBLANK(Discount), Discount = 0 ) )

Data Management