How to Set Up Change Log in D365 Business Central and Dynamics NAV

By John Gentile | November 2, 2021

The Power of Change and Change Logs

Change Log is a useful tool for tracking data changes in your Dynamics NAV or Dynamics 365 Business Central database. Use this feature to record when data is inserted, modified, or deleted on specific tables. Continue reading to learn change log setup and best practices, including recommended setups and setups to avoid.

Overview of Change Logs in D365 Business Central or NAV

Tracking is at the field level and can be recorded for insertion, modify, or delete. Each change type creates an entry in the “Change Log Entries” table with the following information:

  • Date and Time the change happened
  • The User who made the change
  • The Table that was changed
  • The change type (insert/modify/delete)
  • Before and after values of field that was changed

Change log entries table

Best Practices for Change Logs

Setup Tables – Yes… Recommended

If you are using Change Log, then turn it on for your relevant setup tables, as these tables / fields rarely change. Track “All Fields” for Insert, Modify, and Delete.

Change log setup (table) list

Master Records – Sure… if you want to

In some situations, you will want to track changes made to GL Account / Items / Customers / Vendors / Fixed Assets. Track “Some Fields” for Insert, Modify, and Delete.

Transactional Records – NO… Strongly discouraged

Occasionally, a company wants to track changes to Sales / Purchase / Production / Transfer Orders. Be careful here as these records change behind the scenes and can generate LOTS of changes, which add up to a very large “Change Log Entries” table. Only turn this on if you are accepting of terrible SQL performance.
If you’re going to track Transactional data, then only do so if you delete them regularly. Set up the scheduler to run “Delete Change Log Entries” periodically, otherwise your database will continue to grow which leads to increased costs and performance issues.

Posted Records – Never

If we see this is setup, we turn it off. This is the equivalent to drilling holes into a sinking boat.

Change Log Setup

Set up is through the client interface. Search “Change Log” and select “Change Log Setup”.

Search "change log" to "change log setup"

Check / uncheck the box next to “Change Log Activated” to turn on/off change log.

Check change log activated, then select tables

Click on “Tables” in the ribbon of Change Log Setup to configure which Tables / Fields you would like to track changes on. The “Change Log Setup (Tables) List” Page opens and displays a list of every table in your database. You can track when records are:

  • Inserted
  • Modified
  • Deleted

And you can track

  • No fields (aka Blank)
  • Some fields
  • All fields

Fields settings are found in the log insertion dropdown

If you leave your Log tracking type as either “Blank” or “All Fields”, then there is no further setup for that table.
If you chose “Some Fields”, then you will select the “…” on the right edge of the drop down and a list of all the fields available on the selected table are available for tracking. Since you are purposefully choosing to select some fields, take care to only track fields that are meaningful to your business process.

Select ". . ." to choose fields to track

When setup correctly and utilized well, change log is a useful tool for tracking changes made in your database. To learn more about tools found in Dynamics NAV or Dynamics 365 Business Central, contact the Stoneridge team.

Related Posts

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X