Change Log - Setup and Best Practices in Sparkrock 2016

Modified on Sat, 20 Jul at 10:19 AM

Information

  • Products: Sparkrock 2016
  • Summary: Change Log Setup with Best Practices

Details

Change Log helps in providing valuable information on changes/modifications done on a specific field, along with who made it and when. This is helpful to track critical changes on a setup or transaction that affects the business. While Change Log can be setup on any table level, it is important that we activate this only on certain required areas, as activating on all tables and all fields would impose a huge impact on database size and system performance.

Resolution

Activating the Change Log:

Navigate to "Change Log Setup" from the search bar, and check off the flag at "Change Log Activated". This is the main switch to activate/deactivate the logging of changes:

Change Log Setup (Table):

After the above step, you are looking to specify what tables need to be change-logged with details on whether all fields/some fields are required to track. To do this, click "Tables" under the ACTIONS tab. This will open a list of all tables with columns to track what kind of changes - Insertion, Modification and Deletion. Each of the column has a drop-down to pick whether to track 'All Fields' or 'Some Fields':

If you pick 'Some Fields' (which is highly recommended) on any table, for example, Vendor Bank Account (Table ID 288), then you are required to click the Assist Edit button (three-dots button) and check off those specific fields. This will let logging the changes only done to those fields. Otherwise, the 'All Fields' option will do the same on all the fields (but please note that all the fields might not be important for you to track).

View the Change Log Entries after Setup:

After the Change Log is activated and setup for one or more tables, you can view the changes logged under the "Change Log Entries" page. This page has a log for all the tables you have activated. In order to look for the specific table, make use of the filters, especially Advanced Filter for multiple filters. Usually, we search by the Table ID and the Date and Time columns:

Impact / Risks

Summary of Best Practices:

1. Activate Change Log only for Setup Tables like Vendors, Customers, General Ledger Setup, etc. and only on specific fields that you think need to be tracked.

2. Do not activate for any transaction tables like Purchase Header, Purchase Lines, and Ledger table like General Ledger Entries, etc. as this will have enormous entries.

Workaround

Not Applicable

Related Information

KA-03544  · Change log - Setup and Best practices in Sparkrock 365

 

Update History

The following are the dates and actions pertinent to the history of this issue.

Date

Details

Link

12/30/2019

The first version of this Knowledge Base article was created.

 

05/24/2023

Added link to SR365 version of this KBA

Change log - Setup and Best practices in SR365

 

Keywords/tags

Change log, audit

Attachment

Not Applicable

Recommended articles

There are no recommended articles.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article