cancel
Showing results for 
Search instead for 
Did you mean: 

Stored procedure notification

Former Member
0 Kudos
45

Hi

  I have 1 dropdown field in Sales Order . I want when user Updates or Add record it should not be left blank and message is given through Stored Procedure Notification . I cannot define  any value as default.

Thanks

View Entire Topic
KennedyT21
Active Contributor
0 Kudos

HI  Sunny Brar ...

Use this TN Sp for Invoice ... Change the U_Udf to your field

If @object_type='17' and @transaction_type in ('A','U')

BEGIN

If Exists (Select T0.DocNum from ordr T0

Where t0.u_udf is Null and

T0.DocEntry = @list_of_cols_val_tab_del)

BEGIN

Select @error = -1,

@error_message = 'Please fill up the UDF'

End

End

Hope helpful

Regards

Kennedy