Skip to main content

Posts

Showing posts from 2012

Image resources and icons

Just wanted to point out this form here that can be used to view all the image resources that we can use as icons for example on list pages. The form can be found in the AOT under Forms\SysImageResources And here is how you can add custom icons/images as resources to Ax 2012, http://msdn.microsoft.com/en-us/library/cc621437.aspx

Using the Dynamics Ax Office Add-in

Hi everyone, I have been playing around with some Ax 2012 stuff and I was testing the Office Add-in and I think it is preatty cool. In order to use the Office Add-in it has to be installed with the Ax client and some settings needs to be made in the system as well. Lets dive into how it can be done, this is how I tested this function and it can most certainly be done in different ways. First I created a small query called MyCustTableQuery Next step is to provide information about the query and expose it so we can use the query in our office application, my application of choice was Excel. In Dynamics Ax 2012 go to Organization Administration> Setup> Document Management > Document datasources Here it is possible to select a query or service, in my example I used the query. So here i added a new record of data source type Query and then I selected my newly created MyCustTableQuery . Now the query is ready to use in what ever office application we ha...

Upgrading to Dynamics Ax 2012

I have been laying low the past weeks due to some healt problems that have hindered me from working and writing some blogs. Now I am slowly getting back after an operation on the 31st of August. Before I went on a sick leave in mid July I was working on an upgrade project from Dynamics Ax 4.0 to Dynamics Ax 2012. In this first post after the operation I just wanted to point out the importance of the data upgrade process and how important it is for all parties to work to gather to get it done. To success in the process the developer, consultant and the end customer must work as one. As a single unit the developer for example only has few pieces of the puzzle. He or she knows or at least should know how to write data upgrade scripts. But in order to succeed with that the developer needs to know how to transform the data and it is there where the consultant with the end customer come in to the picture. So togather the consultant and end customer decide how and what data needs to b...

2012 Enterprise Portal Development Cookbook

Yes it is here, the most interesting book of the year " Microsoft Dynamics AX 2012 Enterprise Portal Development Cookbook " Check it out my friends http://blogs.msdn.com/b/solutions/archive/2012/07/12/microsoft-dynamics-ax-2012-enterprise-portal-development-cookbook.aspx

Plug-able Authentication in Microsoft Dynamics AX 2012

I have worked in many projects involving the Enterprise Portal for Ax ranging from version 2.5. One of the biggest issue for the end customer/user has been the ability to have a plug-able authentication for EP. This has been an issue for example for customers that have other portals based on Share Point as well as custom build ASP.NET web sites. All these portals are able to share the authentication with Single Sign On, SSO. But until now with version 2012 of Ax this has not been possible since earlier versions of Ax have only supported Windows Authentication. So in scenarios where you implement an EP site for a customer that has other portals and uses for example forms authentication, if you are not running Ax 2012 you have to have a special/dedicated log-on to EP. One of the biggest advantages is the fact that now external users do not have to be in Active Directory mixed up with all the internal users or located in an extra AD repository with all the administrative IT work l...

Dynamics Ax 4.0 to Dynamics Ax 2012 upgrade – Part 2, Security Upgrade Advisor Tool

In  part 1  I talked about few general issues regarding the upgrade process to Dynamics Ax 2012 from earlier versions. In this part I will talk little bit about the Security Upgrade Advisor Tool from Microsoft to map/transfer security information from a legacy (Ax 4.0) system over to the Dynamics Ax 2012 target system.  On  Dynamics Ax Information Source  there is available video where the SUA tool is demonstrated, but the the first step in the process is not shown in the video. This is how to export the legacy security information as an XML file. Here is how to do that: After you have downloaded the  SecurityUpgradeAdvisorTool.msi from  Dynamics Ax Information Source (you need to have access as partner or customer) and extracted the msi file you need to run the X++ job  ExportSecuritySettingsBuild in the legacy system. This generates the XML file that is used in the 2012 system to import the legac...

Dynamics Ax 4.0 to Dynamics Ax 2012 upgrade – Part 1

Few weeks ago I took over an upgrade project from Dynamics Ax 4.0 to Dynamics Ax 2012. In the beginning my biggest task was to get an oversight over the project and to figure out the overall status. The code upgrade was somewhat done but only a small portion of the code was lifted to the 2012 version. To complicate the project even more I had to upgrade and install horizontal modules from Axdata, my employer. In this first post I would like to mention few things to have in mind before you begin the upgrade process. Read these documents ·         AX 2012 Upgrade Guide.pdf ·         AX2012SystemRequirements.pdf ·         Code Upgrade Overview AX2012.pdf ·         How to Write Data Upgrade Scripts for Microsoft Dynamics AX 2012.pdf ·         Microsoft Dynamics AX 2012 Data ...

Add fields for table/field mapping during an upgrade

In my recent upgrade project that I took over in the middle of the upgrade process I had to use a small trick to fix many table and field mappings errors in the Data upgrade checklist static void addFields(Args _args) {     TreeNode                            treeNode;     AOTTableFieldList                   fieldList;     #AOT         ReleaseUpdateBulkCopyField          fields;     ReleaseUpdateBulkCopyTable          tables;     DEL_SqlDictionary                   del_sql;     SqlDictionary                       sql;       str                           ...

Data Upgrade from Dynamics Ax 4.0/2009 -> Dynamics Ax 2012

One thing I came across in my current Dynamics Ax 2012 upgrade project is that the database collation needs to be the same for both the databases, that is the source (4.0/2009) and the target database (2012). This might be obvious, but there is no information about this in the Dynamics AX 2012 Upgrade Guide so it took me some time to figure out why the “ Connect to source database ” in the “ Data upgrade checklist ” was giving me an error when I tried to connect to the source database. When I tried to connect to the source database I got an error shortly afterwards saying that the locale ‘1033’ is not the same as the target locale ‘1030’. After some investigation and thinking I started to look at the two databases and found out that they had a different collation. So my first task was to create a copy of the source database with the correct collation. Error message " The locale id '1033' of the source column 'NAME' and the locale id '1030' of ...

SQL Server versions and numbers

Often we have a need to figure out what all those versions and numbers stand for in the SQL server jungle Here is a nice overview from Wikipedia Version Year Release Name Codename 1.0 ( OS/2 ) 1989 SQL Server 1.0 (16bit) - 1.1 ( OS/2 ) 1991 SQL Server 1.1 (16bit) - 4.21 ( WinNT ) 1993 SQL Server 4.21 SQLNT 6.0 1995 SQL Server 6.0 SQL95 6.5 1996 SQL Server 6.5 Hydra 7.0 1998 SQL Server 7.0 Sphinx - 1999 SQL Server 7.0 OLAP  Tools Palato mania 8.0 2000 SQL Server 2000 Shiloh 8.0 2003 SQL Server 2000 64-bit Edition Liberty 9.0 2005 SQL Server 2005 Yukon 10.0 2008 SQL Server 2008 Katmai 10.25 2010 SQL Azure DB CloudDB 10.5 2010 SQL Server 2008 R2 Kilimanjaro (aka...

SysOperationFramework

I have tried out the new SysOperationFramework of Dynamics Ax 2012 that is going to replace the old RunBase framework. The SysOperationFramework is service based batch framework and it is my feeling at the moment that it will provide us with more possibilities for creating and setting up batch jobs in the real world. There is no need for me to create a full blog about the SysOperationFramework since I am not the first one to try this out. So i will simply refer to another blog post about the SysOperationFramework  http://www.artofcreation.be/2011/08/21/ax2012-sysoperation-introduction/ Thanks to Art Of Creation – Dynamics AX Blog for an outstanding good blog post on the matter Happy batch programming my friends

Dynamics Ax 2012 events and managed C# code

I have been playing around with the eventing model of Dynamics Ax 2012 and I was playing with the possibility to have the event handler in managed C# code. I used this MSDN example http://msdn.microsoft.com/en-us/library/gg889181.aspx The only thing that i had to do not mentioned in the article was to restart the Ax client after I had deployed the Visual Studio project to the Dynamics Ax AOT. After that the post event was fired with out any problems. I guess this has somehting more to do with the environment that i am using rather then some general issue with Dynamics Ax 2012 and manged code. I have developed quite a few examples with X++ and manged code with out any problems on the same virtual machine. I am using the Dynamics Ax 2012 VPC from Microsoft.

A demo of the AxHierarchicalGridView

First of all i would like to give thanks to Anees Ansari and Mey Meenakshisundaram at Microsoft for their input. I have been playing around with EP 2012 for one year now and few weeks ago I decided   I wanted to try out the new AxHierarchicalGridView . I opened my Ax 2012 VPC started Visual Studio and created a new Ax web user control to hold my AxHierarchicalGridView control.   At first I wondered if the grid would support display of sales table information with the sales table as header and the lines as sub rows in the grid. This was not working so I started to wonder how the data model behind the grid should be. If few trials which all failed I contacted Mey Meenakshisundaram at Microsoft to get some information on how to use this control. He forwarded the request to Anees Ansari Product Manager at Microsoft - Web Platform and Standards Team .    Anees contacted me and we setup a live meeting where he would demonstrate the use of the control and how the data...