While working on an assignment where I among other things had to prepare a new query for use with document services and the Excel add-in. The query consisted of three nested data sources, where two was standard tables and the third was a new table which I had added to the system. First version worked just fine. I exposed the query through document services and I could get data in Excel. The for some reason I decided to change the relations on the table I had added, for reasons that I forget. However suddenly my query was not showing up in the pick list, when I using the "Dynamics AX" / Add Data button i Excel. The reason ? I had messed up the relation from my new table to the standard table, making the relation empty. The Excel add-in reacts by simply not showing the now invalid query in the list, but it does not warn you that something is wrong. I got a clue to this, by trying to use "Add table" instead going directly for my new table. Then Excel add...
My thoughts on Dynamics AX application development. I have been working as a consultant with Microsoft ERP-technology since 1994. Currently I work at Optimate A/S. My main focus is customization and application development. This blog is merely my place to put stuff that I want to remember. If anybody can benefit from reading this, that's great :0). Feel free to use any code snippets posted - but accept that you do this at your own risk!!!