Dynamics NAVAX

Original post: http://daxeamproduct.blogspot.com/2014/02/dynamics-ax-2012-and-esris-arcgis.html We have been busy recently, working on developing a GIS solution for Microsoft Dynamics AX 2012. Esri’s ArcGIS is a geographical information system (GIS) solution for working with maps and geographical information. It is used for creating custom maps for viewing, editing, querying. For example, your local town or city will have a GIS solution that shows your housing plan, where the gas pipes are, where you water mains are, the roads, the traffic lights etc. The list is endless. A mining company may have a GIS solution to show where their Assets are, drawings of the mine site, their plant etc. ArcGIS maps work as layers; you have your base layer which is a street map in my example below. Then you have feature layers, below I have an incidents feature layer showing where incidents have been reported, then a third feature layer plotting where the assets are. I am not going to give away too...

There isn’t a report that lists the users and their security roles. You can get this information fairly quickly through Excel add-in. 1. Go to the AOT and find the Query SysSecRolesForUser. 2. Duplicate it and remove the code (it has code in the init method to filter by current user). Then just go the organization > “Document data sources”. Select your query and activate it. 3. In Excel select the service, select the fields and run. You should see a nice list of user and their roles.

If you are upgrading to a later cumulative update and try to import a model you may get this error if you haven’t followed the steps. You have to run the powershell command before you start the imports. This updates the model store schema to accept new models. Initialize-AXModelStore I wanted to find out what was changed in SQL. So, I ran an SQL trace to see which table caused the problem. Then I found that the ModifiedBy and CreatedBy fields where extended from 5 characters to 8 characters. Before (CU6) After (CU7)

I don’t have a proper title for this blog post. But hopefully it helps someone when they google it. When you use TFS for your development you may get weird compile errors where c# code can not be referenced. Namespace error. Or visual studio projects won’t open because of XML namespace issue. below is the error you get if you are trying to Edit a visual studio analysis project from the AOT. The default XML namespace of the project must be the MSBuild XML namespace. If the project is authored in the MSBuild 2003 format, please add xmlns=" http://schemas.microsoft.com/developer/msbuild/2003" to the <Project> element. If the project has been authored in the old 1.0 or 1.2 format, please convert it to MSBuild 2003 format.  C:\Users\munib\Documents\TFSAXDaxeam\Andromeda\Trunk\AX\EAM\Visual Studio Projects\Analysis Services Projects\Daxeam\Daxeam.dwproj I did some digging around and found that the ProjectTypeGUID is blank. A GUID is not assigned to it. Each of th...

You will notice if you try to import sales lines using the DIEF you will notice that the inventory transactions are not created. With some minor configuration changes you can get it working. Go to the Target entities and click on the Mapping details. Then on the SalesQty fields change the sequence to 100. So, it is the last field updated and also tick the “Call modifiedField method” flag. See the the result. This is based on AX 2012 R2 CU6. I haven’t tested this with the latest.

I have posted previously on AX and Scrum this is just a continuation of my series. This post shall cover what a story is. A user story is a short description of what is needed. The main purpose of this is to be able to estimate the piece of work. Below is an actual story i have worked on. We could (should) have written this different. In scrum they teach you to write it in the perspective of the actor. For example: “As a work order user, I would like to create a work order and submit it to workflow. I would like to get alerts and notifications.” One thing we like to do in our team is set up Acceptance criteria's (those AC1 2 AC5 that you see in the screenshot). At the end of the day we use it to tell us a story is done. The next step for use once we have given it sized the story and accepted it into a sprint. We start putting some finer details. We break down the task. Our comment tasks that we use and to use to indicate a story is done are: Functional design – Doesn’t ha...

I have recently created my first Windows 8 App and I thought I would write about my experience. My first starting point is to download this Starter Kit. Dynamics AX 2012 Windows 8 App Developer Starter Kit http://startwindaxapp.codeplex.com/ Then before you do this I would suggested you have a look at Martin’s blog. He has made some fixes. http://dev.goshoom.net/en/2013/03/ax2012-win-8-starter-kit/ Create a custom web service First task was to create a web service. I didn’t want to use a Document service. So, I created a custom service. I wont go through the details of creating a contract or anything but I will show what the method I need is. Create a windows 8 app With visual studio 2012 (latest update 3 installed) I created a new project of type Windows Store. This Grid view will create 3 *.xmal pages. See the screenshot below there is a preview on the right hand side. It shows a Grid view, a Group view, and a Item detailed view. This is where we call the web service to...