Thursday, 16 November 2017

Setup database Log in D365 / AX7

Setup and use of Database Log in AX7/D365 works pretty much in the same way as in AX2012.

Database Log setup

The setup is done under System administration > Setup > Database log setup.

Press +New to create a new Database log.




This opens a Wizard that will guide you through the setup process.





Find the table and field you want to setup data. In this document I want to setup the database log for the search name (Item) field on the Product Master.



The relevant field is found under Trade > Products > Search Name
Select the field Search Name and press Next in the bottom right corner of the page.



Since you only select one field on the customer record, you can only select "Update".



Press Next to continue and Finish to complete the setup.
The Database Log setup for the Search Name field on the Products is now added to the setup database logs.



That is how we can setup database log. For testing change search name on a product master
Go to Product information management > Products > Product masters.

Select the product master where the search name value must be updated and press Edit.

Change the value to "TEST" and press Save to save the change than access to the Database log from the record through action pane on the customer record or list page select Option > Record info.

Action pane with Record information opens in the right side of the page. Select the menu item "Database log". This gives you direct access to the database log for the specific record. 

Select Action pane "History". You can see that User "Admin" has change the search name. As same in AX2012 we have access to the same information from System administration > Inquiries > Database log.

4 comments:

  1. Hello dear.
    Thanks for share this post.
    honestly I am a dummies about Dynamics, I want and I need learn more about this.
    I have some weeks trying to configure Visual Studio with Dynamics 365 and X++, can you please share some guide how configure Visual Studio from zero with D365 and X++ please?

    ReplyDelete
  2. Hi Eric,
    Thanks for your appreciation. I couldn't understand your question. Do you want to know how to setup D365 Environment?

    Thanks.

    ReplyDelete
  3. Hi Tabsheer,
    I really appreciate your post and I'm hoping you can help me.

    My client would like to enable to database logging for changes in the sales price. Ideally, this would apply to trade agreement journals and price changes directly within Released products. So far I have setup logs on the following tables without success:

    Price > InventItemPrice > Trade (InventItemPrice (Table))
    Price > Active prices > Trade (InventItemPriceActive (View))
    Price > Price > Trade (InventItemPriceId (View))
    Price > Item prices > Trade (InventItemPrices (View))
    Amount > Price agreements > Trade agreements (PriceDiscTable) (Table))

    Any suggestion?

    ReplyDelete
  4. Hi Gary,

    Probably database logging can easily be configure, I think you could miss some step. Will you please let me know the exact problem so that I can help you with.

    Thanks.

    ReplyDelete

How to Get Customer Free Text Invoice "Totals" form field value with X++ in D365FO

Customer free text invoices are an essential aspect of financial management in D365FO. In this blog, I have compiled all the code needed to ...