cancel
Showing results for 
Search instead for 
Did you mean: 

To make field mandatory in BP master

Former Member
0 Kudos

Hi All,

I have written the below query in Sp_SBO_SP_TransactionNotification to make one of the tax information field mandatory

IF @transaction_type IN (N'A', N'U') AND (@Object_type = N'2')

BEGIN

declare @n varchar

SELECT @n = T1.TaxId0 FROM ocrd T0 inner join crd7 T1 on

T1.cardcode=T0.cardcode where

T0.cardcode = @list_of_cols_val_tab_del AND

((T1.TaxId0 is not null))

IF (ISNULL(@n, 0) = 0)

BEGIN

SET @error = 10

SET @error_message = N'PlsNo'

end

END

Please help where am i going wrong.

Thanks In Advance

Regards,

Kanishka

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Anjan,

Can you let me know what tool your using for mandatory

fields. It sounds like it would be useful.

thanks Carney

Former Member
0 Kudos

Hi Experts

We have built a tool for mandatory field, there is no SDK used for this.

We are maintaining one table, where the user has to fillup some values to make fields mandatory, like Table Name, Field Name etc..

Then we are passing those as a variables into SBO_SP...

So, there is not need to write each piece of code for each field.

Thanks

Anjan Bhowmick

Former Member
0 Kudos

Hi Anjan,

Can you please explain about the tool.

Thanks in Advance

Regards,

Kanishka

Former Member
0 Kudos

use this code


IF @transaction_type = 'A' AND @object_type = '2' 
BEGIN
If exists (SELECT T0.cardcode  FROM ocrd T0,crd7 t1 where T1.taxid0  is null and T0.cardcode=T1.cardcode and T0.cardcode=@list_of_cols_val_tab_del)
	begin
		SET @error = 10
		SET @error_message = N'Please Enter Tax Id'
	end
END

Former Member
0 Kudos

Thanks a lott!!