Transaction notification is not working SAP Business One

[nikunjmehta2290]

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

[ozer_aydin]

after if else set the error and error message.

check the tn is work.

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

set @error = 57
set @error_message = 'must error appear'

[nikunjmehta2290]

It's not working.