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