Anyone else run across this (Sage 100 2014 Premium, recently upgraded from 3.71 with a stop at 4.5 for credit card migration purposes):
Admin role, created manually just after install, has access to everything. CSR role was created manually. Found that is was missing permissions to memo maintenance. Added them, but the memo button in Customer maintenance still doesn't show up. Created role CSR2 by copying CSR and then checking everything. From the role maintenance UI, CSR2 & admin both appear to have all privileges. However, user assigned CSR2 doesn't see the memo button. Created role CSR3 by copying the admin role. User assigned to CSR3 sees the memo button.
From SQL:
SELECT csr3.* ,csr2.*
FROM
(SELECT * FROM SY_RoleSecurity WHERE rolekey = '0000000018') AS csr2 -- has full perms but cannot see cust memo (copied from csr);
FULL OUTER JOIN
(SELECT * FROM SY_RoleSecurity WHERE rolekey = '0000000017') AS csr3 -- csr3, works as expected (copied from admin);
ON
csr3.TaskKey = csr2.TaskKey
AND csr3.ModuleCode = csr2.ModuleCode
ORDER BY csr2.modulecode, csr2.taskkey, csr3.modulecode, csr3.taskkey
record counts:
csr3 has 726 records
csr2 has 701 records
when joined, csr3 has everything that csr2 has, plus 25 more records
AR_Customer is customized, but only for all users all companies.