on 06-02-2015 5:45 AM
I want to restrict user to enter Item Code less than or equal to 13 characters in Item Master Data.
How to do that without SDK ?
Is it possible. ? Plz reply.
Regards
Hi Amit,
Your requirement can be easily done using SP_TransactionNotification.
Try this as follows:
Declare @ItemCode nvarchar(30)
if @object_type = '4' And (@transaction_type ='A' Or @transaction_type = 'U')
Begin
Select @ItemCode = ItemCode from OITM Where ItemCode = @list_of_cols_val_tab_del
if LEN(@ItemCode ) <> 13
Begin
Set @error = 4
Set @error_message = 'Item Code should be equal to 13 characters.'
End
End
Hope it helps.
Thanks & Regards
Ankit Chauhan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
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.