Hello, forum newbie here. My role is expanding to encompass governance for Dynamics AX 2012 R3. As we begin to bring our companies online to the system, I feel that having solid documentation of the main accounts, as well as the departments, FOC custom dimensions, advanced rules, etc is going to be critical to managing future financial dimension change management. Canned reporting/output to Excel in AX appears to be limited to the Main Accounts. What I'd like to get is relational reporting/modeling of our accounts and related dimensions and rules. This could either be flattened files or, I suppose, bringing table data into MS Access, but Excel is likely the route we'd go.
I've seen some blogging that discussed SQL scripts to get such data out of the tables. Is that going to be the most (only) viable method to get a complete Financial dimension picture of our environment? I asked the external developers who have worked on our implementation and they seemed to acknowledge the lack of such reporting without a workaround.
Thanks for any insights/recommendations/bad news!
Derek
*This post is locked for comments
I have the same question (0)
