Skip to Content
0
Former Member
Oct 14, 2005 at 10:14 AM

Creating a Query to Change Price

37 Views

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.