Skip to Content
0
Feb 07, 2016 at 04:11 PM

Prevent to Added Document in Save as Draft

136 Views

Dear all,

I have a problem on stored procedure

this script is works for me to prevent added of SO.

How can make this work if i want to added S.O as Draft --- Please See Image Below for your reference

Thank you in Advance for your HELP..

Your Truly

Silent

IF @object_type = '17' AND @transaction_type IN ('A', 'U')

BEGIN

IF exists (Select U_CreditLimit_Exceed from [dbo].[ORDR] T0 where T0.U_CreditLimit_Exceed < 0

AND T0.U_triggered_code = true

AND T0.DocEntry=@list_of_cols_val_tab_del)

BEGIN

SELECT @error = -1,

@error_message = 'To Proceed Please Change U_triggered_code to blank'

END

END

Attachments

pastedImage_1.png (92.9 kB)