Skip to Content
0

Make "level of interest" a mandatory field - Opportunity window

Jan 10, 2017 at 05:54 PM

75

avatar image

Hi, hope you´re having a great day! In the Opportunities window there´s the field, Level of interest. When you create an opportunity you can select a level of interest or leave it on blank. The thing is that my boss doesn´t want that field empty when people creates opportunities.

I tried making a stored procedure on the [dbo].[SBO_SP_TransactionNotification], this is my querie

if  @object_type = '97' and @transaction_type in ('A','U')
BEGIN
IF ( select top 1 t0.IntRate from oopr t0 where docentry = @list_of_cols_val_tab_del ) is null
BEGIN
SET @ERROR = 1
SET @ERROR_MESSAGE = 'No se definio el nivel de interes... ' 
END
END

anyway it doesn´t work, I tried using the statements not null, null, !=, =, not in, in and a lot of different structures. Someone could help me by giving me a tip or telling me how my querie should be, I would appreciate the help a lot!

Regards.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers