Dear all,
Below Transaction notification is not working. There is not any error while execute it but the validation is not working.
if @object_type = '17' AND @transaction_type IN ('A','U')
begin
if (select ORDR.Comments from ORDR where ORDR.DocEntry=@list_of_cols_val_tab_del) IS NULL
Begin
set @error = -2
set @error_message = 'Fill the remark'
end
End
end
SAP Business One SQL server
Regards,
Nikunj