Skip to Content
0
Jan 20, 2023 at 12:04 PM

Transaction notification is not working SAP Business One

310 Views

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