Hi
Below Notification will work on the current record or it will chk all records.
IF EXISTS( SELECT T0.DocEntry FROM inv1 T0 inner join oinv t1 on t1.docentry = t0.docentrywhere T0.BaseType <> '17' and T0.DocEntry = @list_of_cols_val_tab_del) BEGIN SELECT @ERROR=1,@ERROR_MESSAGE='Sales Order !' END
Thanks