Skip to main content

Microsoft Dynamics Nav 2016 and the Change Log

Microsoft Dynamics NAV 2016 and the Change Log

As a Dynamics NAV user, you may need to identify who and when someone has modified a Field Value. For example, if you want to record all changes in the Allowed Posting Dates field within in the General Ledger Setup, using the Change Log is ideal. While you can use the Roles and Permissions tool, this only allows for controlling who can make the changes, it does not record which user changed it and when. With the Change Log, we can log the Insert Modify and Delete operation in the whole table or selected Fields to record any changes.

Activating the Change Log in Dynamics NAV

To activate the Change Log navigate to Departments/Administration/IT Administration/Tasks, under General select Change Log Setup. From there set Change Log Activated to TRUE.
Microsoft Dynamics NAV 2016 Change Log Setup
Figure 1 - Enable Change Log in Dynamics NAV 2016
Now from the Action Tab, select Tables. This will open the Change Log Setup (Table) List. Select the tables for which you want to activate the Change Log. And, select the appropriate fields. Please note that if you select All Fields, a log entry will be created whenever any data element in a table changes. If you select Some Fields, a log entry will be created whenever any data element in a selected Table field changes. Using Assist Edit you can select the fields that you want to use to Track Changes.
Microsoft Dynamics NAV 2016 Change Log Setup Table List
Figure 2 - Change Log Setup Table List with Change Log for All Fields
Microsoft Dynamics NAV 2016 Change Log Setup Table List with Change Log for Selected fields
Figure 3 - Change Log Setup Table List with Change Log for Selected Fields in Dynamics NAV 2016
Once you have setup all tables that you want to change the Log for, you then need to reopen the NAV Client to the Change Log to start recording changes.

View Change Log Entries

To view the Change Log entries, navigate to Departments/Administration/IT Administration/General/Change Log Entries. From here you can find log entries for the tables which you have configured in setup. Each entry will contain primary keys (only first 3 primary keys in a table), type of change, old value, and new value of a field, date, and time of log.

Best Practices for Change Log Setup

Some best practices for setting up and using the Change Log include:
  1. Don’t setup Change Log for all tables and all fields in table. While it is very easy to setup, it will have huge impact on database size as each event from each user will be logged.
  2. Try to keep Change Log on selected fields of setups that impact your business, again to help manage the size of the database.
  3. Don’t setup Change Log on transaction tables like Sales Header and Line, Item Journal Line, or on Ledger tables like Item Ledger Entries or General Ledger Entries.
  4. Setup Change Log for setup Tables, and if you want it on transaction tables, then activate the Change Log for selected fields only.
If you have any questions about this function or other Dynamics NAV questions for any version,contact Okello Dan.

Comments

Post a Comment

Popular posts from this blog

The Difference Between Microsoft Dynamics NAV and AX

The Difference Between Microsoft Dynamics NAV and AX Microsoft Dynamics offers a variety of ERP solutions. You might say there is a solution for every purpose and every industry. Two of the offerings,  Dynamics NAV  and  Dynamics AX (now part of  Dynamics 365 ) share some of the same features so you might wonder: ‘what are the differences and which is right for my organization?’ Both ERP solutions are highly customizable, available in and adaptable to many languages and currencies used around the world. The two solutions can also be employed in a central location or across diverse satellite locations and are designed to grow as a business grows. Their industry-specific functionality can assure compliance with local and regional requirements. In short, both solutions could rightly be described as comprehensive and well equipped to manage complex requirements of supply chain and inventory. So, what is the difference? Is one better than the other for your...
Post a Comment
Read more

Office 365 integration in a Dynamics NAV hosting environment

Office 365 integration in a Dynamics NAV hosting environment We from the Microsoft Dynamics NAV support team (Microsoft CSS) see an increasing number of support cases coming in related to Office 365 integration in a hosting environment. This range from the relatively new Edit in Excel feature or the relatively new Outlook Business Inbox to the more familiar Office 365 Single Sign On functionality. This blog post is intended to help you to first discuss the requirements with your customer, it may also help you to understand the difficulties. It should be relatively easy to implement these capabiltities, but since there are so many external components that require different configuration setup, we may end up in high labor intense support cases where we need to put all pieces together. This blog post will hopefully serve as a guide where we summarize all relevant documentation that is out there. Finally, we will showcase a typical environment with several Azure AD’s amo...
Post a Comment
Read more

Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV

Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV When working on new Dynamics NAV implementations (and for that matter, existing NAV solutions), we get a lot of questions about the Purchases and Direct Cost Applied Accounts—namely, what are they used for? We were trained in accounting that, when an inventory purchase receipt is invoiced (vouchered), we would debit the Inventory Account and credit the Accounts Payable Account and be done with it. Dynamics NAV doesn’t handle it that way. When we look at the General Posting Setup in Dynamics NAV 2013 (see below), we see that there is a column for the Purchases Account and the Direct Cost Applied Account. Figure 1 - General Posting Setup in Dynamics NAV 2013 When a purchase receipt is invoiced (vouchered) in NAV, we get the following General Ledger entries: Dr Purchases Account for the Actual Invoice Amount Cr Accounts Payable Account for the Actual Invoice Amount Dr Inventory Account for the Ac...
Post a Comment
Read more