D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

D365FO - Database Logging on shared tables

  • 1.  D365FO - Database Logging on shared tables

    Posted Feb 08, 2019 12:08 PM
    Current version -D365FO (July 2017 PU23), planning upgrade to 8.1.x

    We would like to establish database logging on certain fields/tables, where these are shared setting/configurations that would affect all legal entities, once changed.  This includes:
    • Currency, esp exchange rates
    • General Ledger
    • Unit Conversion
    • Fiscal Calendar
    • Account Structures
    • Units table
    • Products

    We would like to understand whether this would have an impact on performance and how this can be done.

    Yeurupa Raghoo
    Group IT - Business Systems Manager
    Ansa McAl Limited
    Port of Spain

  • 2.  RE: D365FO - Database Logging on shared tables

    Posted Feb 11, 2019 08:25 AM

    So there are a couple things to note:

    1) The Database Log within AX/D365FO was not designed as an auditing tool, it was designed as a debugging tool. The reason this is important is that it is not designed to be turned on and left on for long periods of time, there is very limited reporting around the data that is tracked, and there is no data maintenance capabilities (archiving/purging of audited data).
    2) For any tracking you want to take a 'risked based approach' to what you are tracking. That means tracking only the highest risk table and field combinations that have an audit requirement, this will help limit the impact of performance issues and make reporting on the audited data easier.
    3) You want to be careful of turning the Database Log on any transaction table, tracking too many table/fields of this type this is a guaranteed way to have performance issues within AX/D365FO. Master data and parameter tables are much more lenient on what you are tracking as the number of changes going to those tables is smaller.

    If you have any questions about the above feel free to reach out.

    Alex Meyer
    Director of Dynamics AX/365 for Finance & Operations Development
    Des Moines, IA

If you've found this thread useful, dive deeper into User Group community content by role