Hello,
i have created a TN, that it should not possible to add or update a paymentterm in OCTG with Listnum = 1
DECLARE @Listnum AS INT
IF @object_type = '40' AND @transaction_type IN ('A','U')
BEGIN
SELECT @Listnum = ISNULL(T0.ListNum, '')
FROM OCTG T0
WHERE T0.ListNum = @list_of_cols_val_tab_del
IF @Listnum = '1'
BEGIN
SET @error = 1
SET @error_message = '!! select P2 pricelist !!'
END
END
Can you help me with that, I can't find my error... it doesn't block adding/update after using Listnum = 1
Maybe the Objecttype is wrong ?
Thanks to all
Markus