Skip to Content
0
Former Member
Nov 09, 2011 at 10:01 AM

Transaction Notification Considering Old transaction as well

23 Views

Dear Experts,

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

Regards,

Jimit