Skip to main content

Notifications

Microsoft Dynamics AX forum
Suggested answer

Bank Account Default dimesion Data base logsetup in AX 2012 R3

Posted on by
Hi Team,
 
How can we set up a database log to monitor changes to default bank account dimensions in AX 2012 R3? I've implemented it, but instead of seeing the actual dimensions, I'm only seeing the Record ID.
 
 
Thanks and Regards
Prudhvi M
 
  • vinay prudvi Profile Picture
    vinay prudvi 159 on at
    Bank Account Default dimesion Data base logsetup in AX 2012 R3
    Thank you very much for your reply Martin Dráb.
     
    Regards
    Prudhvi M
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 223,394 Super User on at
    Bank Account Default dimesion Data base logsetup in AX 2012 R3
    The result is correct - the bank account table doesn't store dimensions values; it only stores RecId of a record representing a combination of dimensions. You can take RecId from logs and use it to find details such as dimension values. It's RecId of DimensionAttributeValueSet table, other relared tables are DimensionAttributeValueSetItem or DimensionAttributeValue.
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Bank Account Default dimesion Data base logsetup in AX 2012 R3
    Hi,
    You can set up database logs according to the steps in this blog, and check if any steps missing:
    dynamics-tips.com
    Best Regards,
    Hana
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Bank Account Default dimesion Data base logsetup in AX 2012 R3
    Hi,
    Did you refer to this official document: Configure database logging - Finance & Operations | Dynamics 365 | Microsoft LearnChanges that can be tracked include insert, update, delete, and rename key operations. When you configure logging for a table or field, a record of every change to that table or field is stored in the database log table, sysdatabaselog, in the environment database. Can you share a screenshot of the error or any more information?
    Best regards,
    Kevin

Helpful resources

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,394 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans