Skip to Content
0

set tin number mandatory on business partner

Feb 23, 2017 at 08:33 AM

26

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers