Hi All,
I can' believe it. I created this following approval query :
SELECT distinct 'true' from rdr1 T0 inner join ordr t1 on t1.docentry = t0.docentry inner join oitm1 t2 on t2.itemcode = t0.itemcode inner join itm1 t3 on t3.itemcode = t2.itemcode WHERE T3.[price] < $[rdr1.price]
where it will be used to request approval if the price in the sales order line before it created is higher than item price defined in the item master data, but it passes. The SO still created automatically. Please give advice if my query is not correct. TIA
Rajh