I Want to Restrict users to adjacent Production Order If Issue for Production is not completed adjacent of Receipt for accumulation is Not done some are mandatory.
Below is my SP_Transaction Notification
IF (@object_type = '202' AND @transaction_type= 'U')
BEGIN
if exists (
SELECT T0.[DocNum]
FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T0.[CmpltQty] =0
and T1.[PlannedQty] > T1.[IssuedQty]
and T0.[Status] = 'L' and T0.DocEntry = @List_of_cols_val_tab_del)
Begin
set @error =1
set @error_message = 'Production Order tin not beryllium Closed,until contented and receipt done'
End
END