Transaction Notification blocks addon actions

[former_member542085]

Hello experts,

I'm using SAP 9.3 PL 10.

I have a transaction notification for payments, which should just be done only using an addon, so I use the following

IF @object_type= '24' AND @transaction_type IN ('A', 'U', 'D', 'C', 'L') --Every transaction should be managed by the addon
BEGIN
SET @DocNum = (SELECT DocNum FROM ORCT WHERE DocEntry = @list_of_cols_val_tab_del)

SET @Payments = (SELECT COUNT(DocNum) from RCT2 WHERE DocNum = @DocNum AND DocEntry IN (SELECT DISTINCT(U_DocEntry) FROM [@TBL_Invoices]))

IF(@Payments > 0)
BEGIN
select @error =-200,
@error_message = 'You have selected one of more invoices that should be paid using the addon interface'
END

On the payments interface, the transaction notification works correctly, however, when I try doing the payment with the addon, I get the same message.

I there a way for doing this validation and allow my addon to create payments?

[former_member264639]

Hi Luis,

Instead of selecting the invoices from the [@TBL_Invoices], use the table RCT2, Count the InvoiceId, if it is the greater then your fixed value throw the err msg.

Thanks

Karthik Kannan S