on 06-17-2021 2:11 PM
Dear Experts
I had created a SPT to block Production order on certain Condition
and its working fine in Production order Window, but at the same time when am trying to generate any Issue for Production and Receipt From Production, the Same SPT is blocking
Pls help me to Fix this issue ,
If (@object_type='202' and @transaction_type in ('U'))
BEGIN
if exists(
select T0.DocEntry,T1.ITEMCODE,T1.PlannedQty,T3.OnHand
FROM OWOR T0 INNER JOIN WOR1 T1
ON T0.DOCENTRY = T1.DOCENTRY AND T0.DocEntry=@list_of_cols_val_tab_del INNER JOIN OITM T2 ON T2.itemcode =
T1.itemcode INNER JOIN OITW T3 on T1.ITEMCODE = T3.ItemCode
AND T1.wareHouse=T3.WhsCode
where (T1.ItemCode like '2%' or T1.ItemCode like 'PM%' OR T1.ItemCode like '1%' or T1.ItemCode like 'RM%') and T1.PlannedQty>T3.OnHand
AND T0.[Status]='R'
)
BEGIN
SET @error=1
SET @error_message='Production order cannot be released as there is no sufficient stock of components'
END
END
Regards
VINOD
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.