Hi all!
I am using SP Notification to prevent user close or cancel Sales Order manually from pop up Menu.
Here is my SP>
If @object_type = '17' and (@transaction_type ='U') BEGIN if exists (SELECT T0.[DocNum] FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[CANCELED] ='Y' or T0.[DocStatus] ='C' and T1.[TargetType] ='-1') begin set @error =100 set @error_message = N' Cannot Close directly !!! !' end End
.
But i not success because i think "U" and "A" event is not effect for this case.