Skip to Content
0
Jun 05, 2018 at 07:48 AM

TN for Paymentterms OCTG

54 Views Last edit Jun 05, 2018 at 07:49 AM 2 rev

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