How to Run System Audit Reports in Sage 100 – Part 1

By | February 19, 2015

Have you ever noticed a change to a customer address or vendor record and wondered who made the change and when?  Have you often wished there was a way to get a report of various happenings in Sage 100?  Here are some special tips just for you.

New Stuff: How to setup the format of posting comments in Sage 100

The first report that we will look at is the Activity Log.  This report can be found under Library Master, Reports,and Activity Log.

Activity log

Unlike other reports you will see, there is no option to track this information but it happens automatically. It records information such as when modules are activated, data converted, period end process, system utilities, and system errors encountered.  It also tracks all Visual Integrator information but for a very large number of imports, this report could be extremely large and take a lengthy amount of time to run. This way we can track the activities taking place in Sage 100.

In a number of individual modules, you can find out what changes were made to a master file and who made them.  First, you need to make sure that you select the option to track changes.

For example in GL, General Ledger, Setup, and General Ledger Options, we need to set the options as mentioned in the screenshot below.LedgerLedgerNow we can see different type of reports by navigation to the GL, Reports, Account Audit Report, make your selection criteria and print or preview.ReportReportWe will continue the blog with the setting that we make in the Account Receivable and Account Payable. Stay tuned!

Greytrix – a globally recognized and one of the oldest Sage Development Partners 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.