Skip to Content
0
Former Member
Nov 30, 2011 at 04:38 AM

Prevent User close or Cancel Sales Order manualy

1369 Views

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.