Skip to main content
Dynamics 365 Community / Forums / Microsoft Dynamics AX forum / Bank Account Default d...
Microsoft Dynamics AX forum
Suggested answer

Bank Account Default dimesion Data base logsetup in AX 2012 R3

editSubscribe (0) ShareShare
ReportReport
Posted on by Community member
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
 
Categories:
Other
Financial Management
Enterprise Portal
Attachments
  • 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,025 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 Learn. Changes 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

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Demystifying Copilot with Sundar Raghavan

Sundar explains how Copilot for Service is meant to function separately...

Business Process Guidance Badges and New…

The Microsoft Success by Design is the framework for implementing Dynamics 365…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 223,025 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans