Transaction Notification Considering Old transaction as well

[Former Member]

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

[former_member204969 · Accepted solution]

You should try without object type 24. That is for incoming payments.

[Former Member]

Issue Resolved. Just refreshed the transaction notification and it is working fine now. Thank you all for your prompt response.

Regards,

Jimit Chhapia

[Former Member]

Hi!

If (@transaction_type in ('A','U')  AND @Object_type in ('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

[Former Member]

Hi Jimit,

Why did you write this? @Object_type in ('24', '46')

24 is object type for incoming payment (ORCT), not outgoing payment (OVPM). You only need to write @Object_type in ('46') to create notification for outgoing.

Best Regards,

Hendry Wijaya