Skip to Content

Validations on Production Order(No Receipt of Final Product without Issuing the Component Items)

To block this thing,we need to create the code in the Transaction notification procedure.

 

Write the below code i.e Block receipt of material without issuing component items.

 

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

 

Hope this will help to block transaction. 

 

Thanks,
Neetu Dhami 
 
Be the first to leave a comment
You must be Logged on to comment or reply to a post.