on 04-23-2015 10:08 AM
Dear All Experts,
I want to create a Transaction Notification for Sales Opportunity that if a Sales Opportunity is clicked lost in summary Tab then user should enter the reason for that. (OPR5.ReasondID should not be left empty).
Plz help me to do that.
Regards
Hi,
Try this:
IF (@transaction_type = 'A' or @transaction_type = 'U') AND @object_type = '97'
Begin
IF exists(SELECT T0.[OpprId] FROM OOPR T0 left join OPR5 T1 on
T0.[OpprId] = T1.[OpportId] WHERE T1.[ReasondId] is null and t0.OpprId = @list_of_cols_val_tab_del )
BEGIN
SET @error = 1
SET @error_message = N'Not allowed to choose lost without adding reason'
END
END
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kuldeep,
Please try below query.
IF @transaction_type in ('U','A') AND @object_type = '97'
Begin
IF exists(SELECT T0.[OpprId]
FROM OOPR T0
left join OPR5 T1 on T0.[OpprId] = T1.[OpportId]
WHERE T1.[ReasondId] is null and
T0.[Status] = 'L' and
t0.OpprId = @list_of_cols_val_tab_del)
BEGIN
SET @error = 1
SET @error_message = N'Please add reason for current Opportunity Status.'
END
END
Thanks & Regards,
Alvin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Anyone please help me. Its urgent.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Plz help me.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.