on 04-14-2013 11:26 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunny,
You can define default value for UDF.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunny Brar,
Try this :
IF
(@Object_Type='17') AND (@transaction_type in (N'A', N'U'))
BEGIN
IF
Exists (SELECT T0.[U_rgJobno]
FROM
ORDR T0
WHERE
T0.DocEntry = @list_of_cols_val_tab_del)
Begin
SET
@error = 10
SET
@error_message = N'Please enter UDF'
End
END
Note: Add your UDF field above in select statement
Hope helpful.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.