Hi,
I have created a query to change the price in the Sales Order that looks like:
SELECT CASE A WHEN COND1 THEN 120.0 ELSE $[$38.17] END FOR BROWSE
This means, when A <> COND1 I want the existing price ($[$38.17])to be maintained (no modification). And, I want to modify the price to 120.0 only when A=COND1.
However, the above query results in the price getting modified to its own value when A <> COND1 and sales order identifying this as a field value change; and, the OK button changes to Update.
To avoid this, is there a way to write a query such that price field is left untouched when A <> COND1?
Thanks.