Dynamics NAVProcedure 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:

Procedure:

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.