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