web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Record history - Datab...
Microsoft Dynamics AX (Archived)

Record history - Database Log (AX 2009)

(0) ShareShare
ReportReport
Posted on by Abdallah Zein Al Abdin 1,385

Is there any way I can trace changes on table records in AX?  I want to trace all record updates (value changes) I tried using Administration > Setup > Database log BUT the problem is it only records last update.  I want to trace all updates.

*This post is locked for comments

I have the same question (0)
  • Ragin Patel Profile Picture
    Ragin Patel 990 on at
    Re: Record history - Database Log (AX 2009)

    Hi Abdallah,

    Did you try to look in Administration > Inquiries -> Database Log -> History?

    -Ragin

  • Abdallah Zein Al Abdin Profile Picture
    Abdallah Zein Al Abdin 1,385 on at
    Re: Re: Record history - Database Log (AX 2009)

    Yes I did, this interface is not user friendly.  I think we need to create our customized form to trace record logs in a friendly way. 

    Thanks Ragin :)

  • diana g Profile Picture
    diana g 689 on at
    Re: Re: Re: Record history - Database Log (AX 2009)

    Database log does track all changes along with the old and new values. If you go to a record in a table where database logging is enabled, right click and go to record info, then you can click on the database log and see a full history of changes.

  • Abdallah Zein Al Abdin Profile Picture
    Abdallah Zein Al Abdin 1,385 on at
    Re: Re: Re: Re: Record history - Database Log (AX 2009)

    Thanks Diana for the reply I am using RecID to pull all history changes for any record, this solved my problem

  • Annadevara Venkatesh Profile Picture
    Annadevara Venkatesh 20 on at
    Re: Re: Re: Re: Re: Record history - Database Log (AX 2009)

    HI i am looking to have databaselog report for a vendor and want to have update insert,delete,remamekey log types but i don't wnat recid, recversionid and created date and the other fields i want only Accoun num, name and group on the report. but when i select the base table its giving me all the changes for that table for all the data types. have customised if so please help

     

    thanks in adavance

  • Community Member Profile Picture
    Community Member on at
    Re: Record history - Database Log (AX 2009)

    [quote user="Annadevara Venkatesh"]

    HI i am looking to have databaselog report for a vendor and want to have update insert,delete,remamekey log types but i don't wnat recid, recversionid and created date and the other fields i want only Accoun num, name and group on the report. but when i select the base table its giving me all the changes for that table for all the data types. have customised if so please help

     

    thanks in adavance

    [/quote] 

     

    Hi, You can log specific records in any table you want, Click Show All Tables then choose the Table you need, for your Example: Vendors, expand your selection and choose the records you need to Log.

    Hope this helps you.

  • Hashmath Profile Picture
    Hashmath 148 on at
    Re: Re: Record history - Database Log (AX 2009)

    hi

    set up 9 tables (insert , update, delete)  for database log  but when i setup 10th table everything goes perfect when the wizard closed i dont see the table entry in Database log setup

    i try this multiple no. of times but no use

    i check the license code i see Database log  *********** OK

    any help

    Thanks in advance

    hashmath

     

  • Bruce Sawicki Profile Picture
    Bruce Sawicki 20 on at
    Re: Re: Record history - Database Log (AX 2009)

    How can I find the Unit Conversion table in the wizard? I can't find it under Inventory Mgmt > Items.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: Re: Record history - Database Log (AX 2009)

    Bruce,

    You find where certain tables are in the wizard by looking at the properties of the table.  Specifically the label of the table and the security key.

    In this case, table UnitConvert has a label of Unit Conversion with a security key of BasicTables

    So in the wizard it is listed under Basic > Unit Conversion.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans