How to set up Microsoft Dynamics AX to log record information to a record in a table

Article ID: 928101 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

INTRODUCTION

This article describes how to set up Microsoft Dynamics AX to log record information to a record in a table. You can log the record information to a record in a table for the following fields:
  • Created Date
  • Created Time
  • Created By
  • Created ID
  • Modified Date
  • Modified Time
  • Modified By
  • Modified ID

More information

Log the record information

You must use the Application Object Tree (AOT) to set up the form so that you can log the information. Therefore, you must have a developer verify that the changes that are made are correct. The developer must also compile the table.

To log the record information and to compile the table, follow these steps:
  1. On the toolbar, click AOT. Or, press CTRL+D.
  2. Expand Data Dictionary, expand Tables, right-click the table that you want to use, and then click Properties.
  3. On the Properties tab, click Yes for each field that you want to log.
  4. Click Compile.
The new fields that are added to the table may appear in the SQL Server Browser service or in the Microsoft Dynamics AX table browser.

View the logged information

To view the logged information for a record, follow these steps:
  1. Click the form.
  2. Right-click the record, and then click Record Info.
  3. Click Show all fields. The fields in the system group are displayed.
In addition to logging the information in the database, Microsoft Dynamics AX can also log information that has been created and information that has been modified.

Note Microsoft Dynamics AX logs only information for records and for rows in the database. Microsoft Dynamics AX does not log information for individual fields.

References

For more information about database logging, follow these steps:
  1. On the Help menu, click Help.
  2. Click the Search tab, type database log in the Type in the word(s) to search for box, and then click List Topics.

Properties

Article ID: 928101 - Last Review: January 16, 2015 - Revision: 3.0
Applies to
  • Microsoft Dynamics AX 4.0
  • Microsoft Dynamics AX 3.0
Keywords: 
kbnosurvey kbarchive kbmbsmigrate kbhowto KB928101

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com