Company Tools

Important! Company Tools generate reports designed to help expert users, such as Customer Support personnel and business partners, identify changes that third-party applications have made to your company data or to the database schema.

You can generate one of the following reports at a time:

  • Display all data modifications made by programs other than Sage 100 Contractor. This tool queries all audit (or history) tables and reports on changes made by any third-party applications.

    Note: The data contained in the report is time-sensitive, and depends on the history retention policy specified for your company in Advanced Company Settings. (The default period is 90 days.)

  • Display all database schema alterations made by programs other than Sage 100 Contractor. This tool reports all changes to the schema made by third-party applications. The database schema functions as the blueprint for your database, and determines the type and format of information you can enter into it. Unauthorized schema changes can cause unpredictable behavior, and problems during updates or upgrades.

The report contents are presented in a grid in a separate window. Although you cannot edit the data in the grid, you can use the column headings to sort the items that appear in it, and (in the data modifications report) you can also use filters to restrict the selection of data modifications.

Data modifications

The data modifications tool provides three filters (located at the top of the results window) that you can use to restrict the results that appear in the grid. You can filter records by:

  • Tables. You can select All Tables or a particular table from the list.
  • Users. You can select All Users or a particular user.
  • Applications. You can select All Applications or a particular application.

The resulting report provides information about these types of data changes for the selected company:

  • Insertions
  • Deletions
  • Modifications

Drilling down to view details about a change

To view details about a specific change, you click the Row# cell, or select the row, and then press [Enter].

The details window displays all the fields for the selected record, and shows the value of each field before and after the change.

Schema changes

The schema should not be modified, except by Sage.

If certain types of problems arising during a software update or an upgrade, or if you are suddenly unable to save records, Customer Support may ask you to run this tool to rule out possible schema changes or to identify the third party responsible for the changes.

Fixing file paths to attachments after moving data

If you move your data to a new server, the UNC paths to attachment files located outside of the company file structure will be incorrect. The Toolbox provides a utility to fix the paths to attachments after you move data to a new server.

When you select the Assign new server name in file paths for linked file attachments option, two boxes become available:

  • Old server name, from which you select the name of the old server.
  • New server name, in which you type the name of the new server.

After you enter the old and new server names, click [Update File Paths]