Skip to Content
0

Obligatory field in Opportunities window

Jan 04, 2017 at 01:04 AM

58

avatar image

Hi everyone! In the opportunities window there´s a list field named "Level of interest". The thing is that no opportunity should be null or have the "no interest" level (in spanish would be "Sin Interes" as showed in the picture below").

So, I made this code on the SBO_SP_TransactionNotification and I want to know if something it´s wrong or someone knows the reason it's not working anymore:

--OPORTUNIDADES
declare @nivelint as nvarchar
IF (@object_type='97') AND (@transaction_type IN ('A','u'))
begin
set @nivelint= (select isnull(T0.intrate,0) from oopr T0 where T0.DocEntry = @list_of_cols_val_tab_del)
IF @nivelint!= 1 or @nivelint!=2 or @nivelint!=2 or @nivelint!=3 or @nivelint!=4 or @nivelint!=5
set @error=1
SET @error_message = 'No se definio el nivel de interes' 
end

Basically, if the code of the level it´s -1 (no interest) or 0 (null) the error will appear.

I know, the code is pretty unorganized and non-practical but I used to had a better one and yesterday, the code stopped working just like that. I dont know why and the code that I wrote above was working just 20 minutes ago and it doesn´t anymore. I attached my full SBO_SP_TransactionNotification querie in a TXT if someone wants to see it but I´m pretty sure that is not related to this error because the other restriction codes are working.

Regards!

Transaction querie link

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

0 Answers