Notifications
Clear all
Feb 10, 2023 7:09 pm
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
