Implementing Microsoft Dynamics 365 for Finance and Operations

Database logging

The database log is a feature that helps in auditing. It keeps track of the changes made by users. You can enable track on specific actions, such as insert, delete, and update. For updates, you can turn on the tracking for specific fields. It keeps track of who created or modified the record and when. In the case of updates, you can see the previous value and the new value.

This is typically used in areas where audit tracking is required, such as credit limit updates. Standard reports are available for reviewing any changes made. 

If changes are made directly in SQL through updates, these will not be visible to AOS and will not be available in the database log. It is one of the many reasons why the ERP data should not be ...