Skip to Content
0
J S
Sep 10, 2020 at 07:12 AM

Stored Procedure Notification

40 Views Last edit Sep 10, 2020 at 09:42 AM 2 rev

Hi

I want Notification if Production Order has not been issued user should not be able to receipt it.

I am trying below code but it is not working

IF @transaction_type = 'A' AND @Object_type = '59'
BEGIN
IF EXISTS (SELECT T0.DOCENTRY FROM dbo.IGN1 T0 WHERE T0.DOCENTRY = @list_of_cols_val_tab_del)
BEGIN
DECLARE @entry INT
SELECT @entry = T0.BASEENTRY FROM dbo.IGN1 T0 WHERE T0.DOCENTRY = @list_of_cols_val_tab_del
IF EXISTS (SELECT T1.ITEMCODE, T1.PLANNEDQTY, T2.QUANTITY, T2.BASEENTRY AS ISSUED QTY FROM dbo.OWOR T0 INNER JOIN dbo.WOR1 T1
ON T0.DOCENTRY = T1.DOCENTRY LEFT OUTER JOIN dbo.IGE1 T2 ON T2.BASEENTRY = T0.DOCENTRY AND T1.ITEMCODE = T2.ITEMCODE 
WHERE T1.PLANNEDQTY > ISNULL(T2.QUANTITY, 0) AND T0.DOCENTRY = @entry)
SELECT @Error = 1, @error_message = 'Components NOT ISSUED'
END
ELSE
SELECT @Error = 1, @error_message = 'Components NOT ISSUED'
END



The multipart could not be bound.

Thanks