Transaction Notification for 'issue for production' impacts 'Receipt from production' also

[DINESH_SELVAN_WORKGLOW]

Created Below Validation for Issue For Production But It Impacts Receipt From production also

------Issue From Prod-Kindly choose WIP Warehouse

IF (@transaction_type IN ('A','U') AND (@object_type = '60')
BEGIN IF EXISTS
(Select T1.DocEntry
from IGE1 T0
Inner Join OIGE T1 On T0.DocEntry=T1.DocEntry
Where T0.DocEntry=@list_of_cols_val_tab_del
AND T1.ObjType='60' AND T0.BaseType = '202'
AND T0.WhsCode<> 'U3WIP'
)
begin
set @error =1060
SET @error_message = 'Kindly choose WIP Warehouse'
END
END

[SonTran]

Hi,

I tested your SPTN >>> it works fine and just block Issue transaction only. You can check again if there is any SPTN related to receipt transaction.

Hope this helps,

Son Tran

[ANKIT_CHAUHAN]

Hi dinesh_s1,

Transaction Notification which is intended to trigger for Production Order only, gets triggered for Receipt from Production also.

This is the correct behaviour because when Receipt from Production is about to be added, the Production Order on which the Receipt from Production is based at, is updated as a part of general functionality. The Production Order is added to the list of objects to be updated and it is notified by transaction notification.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support