Clear activity log in Sage 100

By | March 28, 2014

In this blog, we are going to discuss how we can clear the existing Activity log in Sage 100. Before we get into the details, let’s first understand as why Sage 100 provides a feature such as an activity Log. 

“Use Activity Log to view a continuous record of significant operating events (for example, installing applications, or performing system startup, file maintenance, or period end processing). This log also lists any error conditions that have occurred.”

Above is the definition provided in Sage 100 ERP. These logs are very useful in reviewing the system issues and events. But these log tables gets filled very early and take a lot of space in the memory. There is no option in Sage 100 to clear all the logs in one go, but there is one alternative to this by which you can clear the log table. 

Below given steps should be performed by a Sage 100 Administrator –

  • Log-out all existing user and stop the Sage 100 server. 
  • Go to MAS_SYSTEM folder of the 100 system server. 
  • Rename the existing SY_ActivityLog.M4T table to SY_ActivityLog_2014_28_03.M4T
  • Now, start the server and log-in to Sage 100. The system will try to locate the SY_ActivityLog.M4T to write log. In case, if it is not found then it creates a new SY_ActivityLog.M4T table file and write the entry to it. 

This kind of log clearing is also very helpful. In case, you want to check some old logs, then just re-name the desired old log file and you will see those old logs in the Activity Log.
In this way one can easily clear the activity logs in Sage 100. <

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

The unique GUMU™ integration solutions provided by Greytrix for Sage 100 include Sage 100 integration with Sage CRM, and Salesforce.comDynamics 365 CRM, the migration solutions include Sage 100 Migration from Sage 50 USSage IntacctQuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide. Sage 100 product listings by Greytrix include Salesforce – Sage ERP integration available on Salesforce Appexchange, Dynamics 365 CRM – Sage ERP integration available on Microsoft Appsource (Free Trial).

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 100 Services, please contact us at We will like to hear from you.