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

By John Gentile | November 2, 2021

change log activated

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

Recommended Reading:

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article

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