If (@transaction_type = 'A' AND @Object_type in ('24', '46')) begin if exists (SELECT T0.DocEntry FROM OVPM T0 WHERE len(T0.JrnlMemo) > 45 and T0.DOCENTRY = @list_of_cols_val_tab_del) select @Error = 1, @error_message = 'Characters of Journal Remarks exceed the allowed Limit' end
I have written a transaction notification to limit the characters in the Journal Remark field of Outgoing Payment. It was working fine till yesterday. But now it gives an error even if the no. of characters are less than the allowed limit. It is considering the transactions which are already posted and having length of Journal Remarks greater than 45.
Kindly advise on how to rectify this issue