Skip to Content
0
Former Member
Apr 19, 2010 at 01:15 AM

Making UDF Mandatory

24 Views

Hello Experts,

I want to make this UDF mandatory in my item master data. I was referring to: making-udf's-mandatory .. I tried the code given there and it works!

However, I also want to make another UDF mandatory in the Business Partner Master Data. I used the same code but it didn't work:

IF @transaction_type = 'A' AND @object_type = '4'

BEGIN

If exists (SELECT T0.CardCode FROM OCRD T0 where T0.U_Telno is null and T0.CardCode=@list_of_cols_val_tab_del)

begin

SET @error = 10

SET @error_message = N'Please Fill In Telephone Number'

end

END

Where did I go wrong? Thanks in advance!