Setting up fields to be mandatory

[former_member327292]

I need to set the Reference field in the Incoming Payment be mandatory. could someone help me do it in the SBO_SP_TransactionNotification.

[former_member205766]

Hi

Try this

IF  @transaction_type in (N'A',N'U') AND @Object_type = N'24'

BEGIN

If Exists (SELECT T0.DocNum FROM ORCT T0 WHERE Isnull(T0.CounterRef,'')='')

and T0.DocNum = @list_of_cols_val_tab_del

Begin

     Select @Error = 2, @Error_Message = 'Reference Can't be Null '

End

End

Regards

Balaji

[former_member327292]

Hi Balaji

Many Thanks. It works already