Không cho phép hủy chứng từ AR Invoice

Yêu cầu: dùng Transaction Notification để chặn hủy AR Invoice nếu không phải 

• User
• Customer Group

Giải pháp:

Transaction Notification:

IF @object_type = '13' and (@transaction_type IN ('A'))
BEGIN
IF EXISTS (SELECT T0.UserSign FROM OINV T0
INNER JOIN OCRD T4 ON T4.CardCode=T0.CardCode
WHERE T0.Canceled='C' and T4.GroupCode in (101,102)
and T0.UserSign NOT IN (4) and T0.DocEntry = @list_of_cols_val_tab_del)
BEGIN
SELECT @error = -100,
@error_message = 'U cannot cancel.'
END
END

 Nguồn: Notification not working | SAP Community