Skip to Content
0
J S
Nov 03, 2020 at 05:39 AM

Stored Procedure Notification

60 Views

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