Skip to Content

set tin number mandatory on business partner

IF (@object_type = '2' AND @transaction_type= 'U') BEGIN IF EXISTS (SELECT T1.CARDCODE FROM CRD7 T1 INNER JOIN OCRD T0 ON T0.CARDCODE = T1.CARDCODE WHERE ((t1.TaxID11 IS NULL OR t1.TaxID11 = '') AND T1.CARDCODE = @list_of_cols_val_tab_del)) BEGIN SELECT @error =123, @error_message = 'TIN UPDATE' END END

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers