SmartFusion Modules > Tools > Audit Report

Recent Updates: 
6.215 
- Added audit triggers to BankReconciliation Table.
- Added audit triggers to ReconciledEpayments Table.
- Added audit triggers to CR129 (CheckReconciliation Table).
- Added audit triggers to CA149 (CashReceiptDetail Table).
- Added audit triggers to CA150 (CashReceiptMaster Table).

6.213 - Added audit trigger to CC124 (Receipt Type) table.
6.212 - Added audit trigger to ar002 (Transaction Code) table.
6.204 - Added audit trigger to pr158 (Employee Checks) table.
6.187 - Added audit triggers to csi21(Funds Table) and 'csi21' for the Fund table as options in "Select table".

Refer to bottom of page for changes prior to version 6.150

Introduction

This report shows any changes that have been made within a selected table.

Details

• Select report sequence - Date or Name
• Select table
• Select field
• Select change dates

Report Fields

• Type - Insert, Update, or Delete
• UserId
• ID
• Field or Category - Name (ConfigurationItem table)
• Original Value
• Changed Value
• Date

References - Internal Use Only - http://rand-wiki.harriscomputer.com/Page/5859/ScriptforcreatingtriggerInternaluseonly

Changes Prior to Version 6.150

6.146 - Added 'pr167'for Federal Tax Table, 'pr168' for State Tax Tables, 'LocalWithholdingCodes' for Local Tax Group and 'LocalTaxLimits' for Local Tax tables as options in "Select table"

6.144 - Added the Payroll Parameters as options in "Select table"; Modified the record sort to be by "Update Date/Time" instead of just "Update Date"    

6.141 - Added the ConfigurationItem table as an option in "Select table"  

6.88 - UBRateTable table has been added as an option for 'Select table'

6.63 
- AccountBudget table has been added as an option for 'Select table' with Approved, Recommended, Requested, and Forecast as potential field choices
- Only columns that have had changes made to them will show in 'Select field'