Skip to Content
0
Former Member
Mar 12, 2014 at 04:15 AM

Production order avoid row delete is working, Special work order not able to create

125 Views

Team

I used following program based on team input, This working fine to avoid the production order row line delete.

For special order this is referring for BOM. Can we make this program ingrowing during special production work order.

IF @transaction_type IN ('A', 'U')AND @object_type in ('202')

BEGIN

If exists (SELECT T0.DocEntry FROM owor T0

inner join itt1 t2 on t2.father = T0.Itemcode

where t0.DocEntry =@list_of_cols_val_tab_del AND t2.code not in (SELECT T1.itemcode FROM wor1 t1 where t0.docentry = t1.docentry))

Begin

SET @error = '202'

SET @error_message = N'order can not be added if not match with BOM.'

End

END

Thanks

Anantha Desai