Item Master Data Restrict

[Former Member]

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

[ANKIT_CHAUHAN · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

Thanks for the reply.

Regards