Database log setup for module's parameters and setup forms in "Microsoft Dynamics AX 2012".

Dynamics AX 2012 provide inclusive functionality to enable logs for database and we can track every change in any field of the table using this option. This database log is surely an interesting option of AX 2012 and provide the ability to audit trail activity of the database in detail. This logging is proposed to track single transactions but not recommended for tracking automated transactions running in batch jobs so simply it’s actually meant to track 3W’s (who, what, when). If this log will be enabled over all tables at every transactional level it won’t be an easy task in respective to maintain database and it also depends on our requirement that how long we wish to maintain these logs with our database to track previous transactions.

There are some other blogs previously available for the database log activation with Dynamics AX community, but no once mainly focus on form level, module’s parameters and setup forms particularly as fields on setup and parameters forms are very critical and needs regular reviews by the administrator because behavior of application somehow based on these configurations which needs periodically review to track any change and update which may impact over transactional activities.

Beside this one of the major problems with Database log setup is that the wizard shows only the tables with their labels, and we cannot easily identify this and some of the tables have the same label as others and some have no label at all.

In below illustration I have selected account payable module parameter form for database log activation so I can track change on my required fields of this form.

On account payable parameter form we can check the table with personalize option here and easily found that “vendParameters” table is being used for this form so we needs to further focus this table but the main problem is that how can we find this table in database log setup and under which configuration key.

After identification of table we needs to further classify the configuration key of this table and while access AOT we can easily check the configuration key of this table under properties tab of the table in AOT. The configuration key of the “Vendparameter” table is “LedgerBasic”.

Now the question is that can we find this configuration key at database log setup to find our required table for database logging but we would surprise that there is no such configuration key available in the database log setup with this name. So keep calm and let’s move on the next step at this step

At this step we again needs to access again AOT to check our required configuration keys “LedgerBasic” from following screen we can here find our required configuration key under configuration key -tree in AOT. The important point here is to tell you that we have to check the label of our configuration key which is “General Ledger” as the database log setup shows these labels.

Once we got these result we can simply set the database log on our required tables either it is pertain from setup or any module’s parameter form, now our core effort relates to find the table under configuration key is almost done and later all the step are the similar which most of you are already aware, however I am walling the screen for your ready references again.

Concluding my writing, I believe that this information will be sufficient and surely help you to configure database logging anywhere in Dynamics AX 2012 application according to the client requirement and needs.