Không cho phép hủy ...
 
Notifications
Clear all

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

1 Posts
1 Users
0 Reactions
309 Views
admin
Posts: 366
Admin
Topic starter
(@admin)
Noble Member
Joined: 3 years ago

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

Reply
Share:
x  Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security