Beating the Business Central Change Log and Solving the Mysteries of Who Dunnit.
As a Business Central user, you may have discovered the Change Log functionality. If you haven’t checked it out yet, let me catch you up. The Business Central Change Log is a tool that will track changes on specific data. It will tell you who made the change, when they did it, and what the values were before the change. If a user changed a customer address, you could search the change log to find out who did it and when and contact that user to find out why. While this seems helpful, there are a number of limitations to Change Log that we’ll cover below. We’ll also go over newer applications like Change Tracking, an app that helps you figure out “who dunnit” without slowing you down.
Use and Limitations of Change Log
To use Change Log, you must activate it first. After activation, you’ll see a warning that reads Change Log might slow things down – especially if you want to monitor things that actually change. Then, you must select which tables and fields you want to monitor. Unless you have a PhD in all things Business Central, it’s unlikely you’ll have any idea where to begin. In this situation, there’s a good chance you won’t know you want to monitor something until it’s too late. Oh, and let’s not forget how long it takes to search the Change Log for something (assuming you were actually monitoring the right thing!). Eventually, most frustrated users turn to the system administrator to find something in the Business Central Change Log.
Finding a Better Way
We always thought there must be a better way to track changes in Business Central and put change log information at users’ fingertips. A user should be able to easily see the history of edits on a customer, vendor, item, order, bill of materials – anything. This is what motivated us to write Silverware Change Tracking.
With the Change Tracking app, you will have a Changes menu option on any table you select. The app comes with some suggested default tables to make it easy, but you can always add others. When you click the Changes button, you’ll see a row for each change done to the record. In the screenshot below, you’ll see that on February 11 at 2:23 pm, user ADMIN changed the address and credit limit for this customer.
Now, let’s talk about changes to a sales order. Maybe a customer calls to change the quantity or ship to address for an order. Once that order posts, you can see these changes on the posted sales invoice and posted sales shipment. Having access to the log provides users with a complete history of changes.
If you are a Business Central user that is interested in Silverware’s Change Tracking app, it is available on AppSource here and comes in two versions – Basic and Advanced. With Basic, you can track changes on 20 different tables. With Advanced, you can track changes on an unlimited number of tables. Regardless of the version, our setup wizard will help you set up the most popular tables so you can be up and running in minutes.
Download a free trial of Change Tracking today and find out “who dunnit!”
See the Change Tracking datasheet here.