Sage 100

The enhanced security tracking in Sage 100 2023 is pretty impressive.  I have been able to use it to help a couple of clients track down activity in the system.  It's a shame that they didn't have this feature in earlier versions.

Right now, i have a customer that is undergoing their annual audit (FY 2023) and the auditors are asking for evidence of users being added or deleted from the system.  The system was running Sage 100 2018 up until January 24, 2024 so the cool new features of Sage 100 2023 didn't kick in until after year end.  I still have the 2018 system complete with years of the Activity Log but apparently there is no report to show when a user was added or deleted in the old system.

Does anyone have any suggestions?

------------------------------
Chuck Peddy
Smartbridge Partners
------------------------------

I ran into nearly this exact request probably 20 years ago with a larger bank that used Sage for AP for one of it's small subsidiaries. At the time I installed DSD 

LM-1031 User Login Activity Log. I'm not sure but one of Alnoor's classes might have had a script that duplicated this as well.

My experience is also that these requests are usually "checklist items" and the auditors don't do much beyond checking a box that the functionality exists.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

in 2018 I do not believe the date the user was deleted was tracked.  However, the date users are added is saved in mas90\mas_system\sy_userhistory.  See the table below and attached to this post. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------