SP for Block Close of Production Order

[former_member252592]

Hi Experts I have SAP Business one 9.2 Hana

I write the following SP to block Production order to close if Issue for production and Receipt from Production is not done.

IF ( :transaction_type = 'U') AND (:object_type= '202') THEN /*Block Prod O if Receipt and Issue not Done Error = 3006*/ SELECT count(*) INTO cnt FROM OWOR T0 Inner Join WOR1 T1 on T1."DocEntry" = T0."DocEntry" Inner Join IGN1 T2 on T0."DocNum" = T2."BaseRef" Inner Join OIGN T3 on T2."DocEntry" = T3."DocEntry" Inner Join IGE1 T4 on T4."BaseRef" = T0."DocNum" WHERE T0."DocEntry" = :list_of_cols_val_tab_del AND T4."Quantity" = 0 AND T2."Quantity" = 0 and T0."Status" = 'L'; IF :cnt>0 THEN error := 3006; error_message := 'Cannot Close Untill Issue and Receipt Not Done'; END IF; END IF;

but its not working kindly guide me where am i missing in this SP

Regards

[kothandaraman_nagarajan]

Hi,

Use below logic to block closing production order in HANA,

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 can not be Closed,until issue and receipt done'

End

END