Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Does anyone know where the "Acct Date" on the Master console is stored?

Posted By up4a over 8 years ago

What table? Ideally looking for date and time a user logged into a Module. Thanks for any help you can offer!

0 DGR over 8 years ago

Maybe SY_ModuleDate.M4T in \MAS90\MAS_SYSTEM which contains: Userkey, CompanyKey, ModuleCode, LastDate. Depending on the logtype settings, records can be written to SY_ActivityLog.M4T when users access Sage 100 modules.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 up4a over 8 years ago in reply to DGR

Thanks, we were hoping to use this in a Ksync event or a crystal report, how would I connect to these M4T type files via ODBC? Is this even possible?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 up4a over 8 years ago in reply to up4a

Never mind they are listed tables, I found them. Thanks again for the help.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Does anyone know where the "Acct Date" on the Master console is stored?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING