Skip to Content
0
Dec 04, 2020 at 09:18 AM

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

50 Views Last edit Dec 07, 2020 at 08:12 AM 7 rev

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