24 Aug’17

D365 Business CentralProcedure to create custom logs in Dynamics NAV

Introduction:

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.

Pre-Requisite:

Microsoft Dynamics NAV 2017

Procedure:

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.

Conclusion:

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

CloudFronts

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

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more