Restrict to close Production Order If Issue & Receipt Not done both are mandatory. SAP B1 10.0

5 months ago 20

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

Read Entire Article