SAP B1 Production validation

[Former Member]

Following are the issues, I need the improved stored procedure to curect this.

• After relase of work roder user change the base qty and planned qty. due to this inventory consumpation errors are there.
• I have blocked the column using the form setting. If we duplicate old workorder access will be opened modifiy the qty.
• How to avoid the close and duplicaton of production order for specified user.
• How to ristrict the production order hedder ware house change.

Currently useing following stored procedure

/*----- Validation to restrict Production order row delete 13MAR14 -------- */

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 T0.[Type] <> 'P' 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

[former_member196081]

Hi

you can not stop document duplication through transaction notification. SDK can help in the same.