Next we will go through and test what we have configured. Click the “Finish” button to finish the configuration. In the next form you will see a summary screen letting you know what all will be enabled for database logging. In this example I only want to track changes when someone updates a record so I will enable the “Update” flag and click “Next”. Now I can scroll down and find the table and field I want to track and define which actions should trigger the logging. Click the checkbox next to “AccountNum” and click “Next”. Under the “General ledger” tab we find the “VendBankAccount” table. Navigate to System administration > Setup > Database log > Database log setup.This is a real audit/security requirement I have had on a previous implementation.
#Ax database vendor transtype description full#
The scenarios is that the auditors require a full audit trail for any changes made to any vendor bank account information. You may find that you can get what you need simply by using the created by, created date time, and modified date time fields that are found on most major tables.įor this example, I am going to setup change tracking on the vendor bank account table on the account number field. When selecting tables to change track, think about the volume of database logs that may result from turning on database logging for a particular table. The first step is to define the tables and fields you want to track and to enable the database logging. It is important to setup a cleanup schedule to ensure the database log is cleaned on a periodic basis to mitigate the performance impact. Depending on how you set database tracking up and which tables or fields you are tracking, the database log may grow rapidly.
![ax database vendor transtype description ax database vendor transtype description](https://present5.com/presentation/6d6b6a9f0f02b26ce5dbf96a99c48af1/image-67.jpg)
We will also look at how you maintain this feature.
#Ax database vendor transtype description how to#
In this article I will show you how to set up database logging and then give you a click by click walkthrough and demonstrate the functionality. The database logging feature allows you to determine which table, and fields should be monitored and the events that should trigger the change tracking. Database logging, also known as change tracking, in Dynamics 365 Finance and Operations is a very powerful security and audit tool that is surprisingly easy to setup.