Transaction notification for Tax code to allow only few document series in doc SAP B1

[nikunjmehta2290]

Hello all,

Please help me on that For few tax code when select into document then all type of document series not allowed to punch. Few document series only allow to make transaction.

Need to develop Transaction notification. Please help me on this. SBO HANA Version.

I have developed this transaction notification but it's not working.

IF :object_type = n'19' AND (:transaction_type = n'A' OR :transaction_type = n'U')

THEN

SELECT (SELECT T0."DocEntry" FROM ORPC T0 INNER JOIN RPC1 T1 ON T0."DocEntry" = T1."DocEntry" INNER JOIN RPC12 T2 T0."DocEntry" = T2."DocEntry"

Where T1."DocEntry" = T2."DocEntry"

And (T1."TaxCode",'IGST@5') = (T0."Series",'601')

AND T0."DocEntry" = @list_of_cols_val_tab_del)

INTO temp_var_0 FROM DUMMY; IF IFNULL(:temp_var_0,'') !=''

THEN

SELECT 2 INTO Error FROM DUMMY;

SELECT 'Please select tax code as !!! ' INTO error_message FROM DUMMY;

END IF;

END IF;

Regards,

Nikunj