Solution:

This solution provides information on how to setup a change log for a database table.

To setup a change log for a table, use the steps below:

Record changes to any key files:

1. Open System Manager (SM).
2. Under the Maintain menu, point to Dictionary and click Tables.
3. Select a table from the Table ID picklist.
4. Click Edit.
5. Select the Log Changes option from the General tab.
6. Update from Data Dictionary for this table. In the System Manager documentation refer to “Using System Utilities” for more information on using this utility.
   Important The Log Changes option is only available to specific Sage Pro tables. There are Sage Pro tables that do not have the capability of tracking changes in a log. Please refer to the System Manager documentation under the Data Dictionary section to find which tables that cannot log changes. Only payroll files are automatically configured to track changes.

This will enable Sage Pro to record any changes made to key files.

Important Only payroll files are automatically configured to track key changes.

View the system log report:

1. Open System Manager.
2. Under the Print menu, point to System Logs and click Change Log.
3. Enter the appropriate parameters into the options grid and generate the report.

The Change Log report will display any changes made to key files.

Related Reading Please see “Tables” section of Data Dictionary documentation for more information on Change Log setup.

© Copyright Sage Software