24 Aug’17

Dynamics NAVProcedure to create custom logs in Dynamics NAV


To track changes that are made to records in a particular table and to store them sequentially in NAV, logs have to be created. Using logs we can record changes that are made to standard or custom fields in a table.

In this article, I will be demonstrating the steps required to setup logs in NAV.


Microsoft Dynamics NAV 2017


1. Navigate to ‘Change Log Setup’ Page using the NAV windows or web client.

2. In the actions tab, choose ‘Tables’ under Setup group to select the tables and the fields on which changes are required to be logged.

3. A list of all the standard and custom tables will be displayed.

Logs can be created on three events:

  • Initially when the record is created, log will be created with the initial value of the selected field to be logged.
  • When the record is modified, log will be created in the system with the old and new value of the selected field to be logged.
  • When the record in deleted, log will be created in the system.

4. You can either select some fields to be logged or select the All fields option.

If you select ‘some fields’, click on the ellipses (…) to select the fields on which log will be created. If ‘All fields’ has been selected, by default all the table fields changes will be logged.

5. I have created a log entry on ‘Item’ table on two fields ‘No.’ and ‘Car status’. Car status is a custom field with option datatype.

6. On clicking the ellipses (…) when ‘Some Fields’ is selected, the table field list will be displayed. Select the event when a log record has to be created i.e. Log Insertion, Log Modification or Log Deletion.

7. Now on the Change log setup page, select the ‘Change Log Activated’ checkbox.

8. After creating a record in ‘Item’ table and modifying the values of the ‘Car status’ field, the following logs are created in the system.

  • Date and Time when the log is created is stored which will be useful to get history of events performed in the system at any point.
  • The user ID who is creating and modifying records will be stored.
  • Table caption stores the table name which is selected.
  • Primary Key Field 1 Value stores the Item No. i.e. the unique field in the table.
  • Type of change will be stored i.e. Insertion, Modification or Deletion.
  • For option fields, the old value and new value is stored.


These are the steps required to create logs in NAV which will track changes made to the fields selected in the change log setup.

Written by

Team Member


Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more
  • Cause and Solution for Scribe MSMQ not receiving Message from AX

    10 March’ 2018

    Issue: Microsoft Message Queuing (MSMQ) service running on Server might be unable to receive messages. Therefore, messa...

    Read more
  • User Privileges on SharePoint – D365 Document Integration

    10 March’ 2018

    Overview: Often, we wonder what could be wrong where we see a generic error on Documents in Dynamics 365. Something lik...

    Read more