Stored Procedure Notification

[former_member645084]

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

[mgregur · Accepted solution]

Hi,

@list_of_cols_val_tab_del is a parameter which queries the DocEntry of the current document. This should work only on that one particular document.

BR,

Matija