on 2018 Aug 28 6:47 AM
Hi Experts
I Need SP for
With Out Inventory Request I should not raise inventory Transfer
Hi Jennifier ,
Could you check this query ? You should change table name.
IF @object_type = '15'
BEGIN
IF EXISTS (SELECT T0.ItemCode FROM [dbo].[DLN1] T0 INNER JOIN [dbo].[ODLN] T1 ON T1.DocEntry = T0.DocEntry WHERE T0.BaseType = -1 AND T0.DocEntry = @list_of_cols_val_tab_del )
BEGIN
SELECT @Error = 1, @error_message =ERROR MESSAGE !'
END
END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
106 | |
8 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.