Rahul Sharma

Solutions Architect - Microsoft Dynamics AX | Azure

Blog
This is a technology blog covering Microsoft Dynamics AX, Microsoft Dynamics CRM, Microsoft Azure, IoT, .Net, SharePoint, SQL Server, SSRS, SSAS, SSIS, Apache Cassandra, MongoDB, and related technologies. Join this blog on facebook {Rahul Sharma}, to start a discussion !!! NOTE: My employer is not responsible for the content published here.

Index | MS Dynamics AX | MS Dynamics CRM
View blog as >> Magazine | Sidebar | Flipcard | Mosaic | Snapshot | Timeslide

Dynamics AX Build Numbers

List of Dynamics Ax version and kernel/application builds.

These numbers are changed when you install new service pack / hotfix / roll-up. So, check above link to know which version of Ax SP / hotfix /roll-up you are on.

Other than checking your Ax kernel / application version from the Ax > Help > About Microsoft Dynamics Ax, you can try following as well.

MS SharePoint 2010 with Dynamics AX 2009 SP1 Enterprise Portal

Many people wonder if Microsoft SharePoint 2010 is compatible with Dynamics AX 2009 EP or not. So the good news is, yes these products are fully compatible with each other and you can deploy EP on SharePoint 2010. This can be more interesting when you would like to install Dynamics AX 2009 and Dynamics AX 2012 on a single machine, as Dynamics AX 2012 EP only works with SharePoint 2010.

You would like to upgrade your current SharePoint (MOSS / WSS) to SharePoint 2010, and both In-Place upgrade and Database attach upgrade methods are supported.

Reference:
Microsoft SharePoint 2010 with Dynamics AX 2009 Service Pack 1

MS Dynamics Ax 2009 EP Development - Part 2

I was planning to write the next part for Enterprise Portal development but then I found this well defined document which specifies steps and things need to be taken care while doing EP development.

Download full MS Dynamics Ax 2009 Enterprise portal development reference from



Please join this blog if you liked this post.
Also feel free to post your comment / feedback / queries.

References:
MS Dynamics Ax 2009 EP Development - Part 1

Consuming ASMX WebService or WCF Service in Dynamics Ax

This post is a quick reference on consuming asmx / svc services in Dynamics Ax. We will also see how to pass .Net types to / from X++ code.

There are two methods available in .Net to create web services, one is old ASMX style and another is WCF service.
(How to create web service? Do google / bing.)

I have created a ASMX web service and deployed it on my local Windows 7 64-bit IIS 7 laptop, http://rahul:200/TestWebService/HelloWorldWS.asmx. This web service contains two web methods. First method takes an integer argument and returns a string value. Second method takes an array as input and returns an array.

Office Open XML and Dynamics Ax

Ever wondered what's special about new Microsoft Office file formats, why there is X in all office 2007 or later version file extensions, like docX, xlsX, pptX etc.?

Yes, this is a file format specification from Microsoft and this Office Open XML File Format specification is an open, international, ECMA-376, Second Edition and ISO/IEC 29500 standard. That means, now office document formats are not something that is hidden from the developers or proprietary to Microsoft, its open for all now. If you understand this, then it means you can read, write or modify existing office documents without even installing MS Office on your computer.

The purpose of the Open XML standard is to de-couple documents created by Microsoft Office applications so that they can be manipulated by other applications independent of proprietary formats and without the loss of data.

How it works?

Dynamics Ax Workflow (IIS 7 64 bit - Http error 405 - Http error 404.17)

This is the error you receive while trying to access ASMX web service from Windows 7 64-Bit / Windows 2008 Server 64-Bit and IIS 7.

If you try to validate Dynamics Ax 2009 workflow web service from Ax, you receive below error.


The request failed with HTTP status 405: Method Not Allowed.

When you validate workflow from Dynamics Ax, it actually tries to invoke ping method on AxWorkflowInstance.asmx web service. If successful, returns true else false.

And if you try to browse this ASMX web service directly, most probably you will hit the error mentioned below...

HTTP Error 404.17 - Not Found
The requested content appears to be script and will not be served by the static file handler.

Dynamics Ax Virtual Company & Table Collections

This article describes how Dynamics Ax Virtual Company and Table Collection work. We will also discuss how to move data from normal company to virtual company when you introduce virtual company in existing Ax implementation.

Virtual Company:
Dynamics Ax stores data as per company in tables. But there might be occasions when you want to share data across companies, like country, state, zip codes data. This sharing of data is achieved by creating a virtual company and storing data in this virtual company. Normal companies are then configured to read/write data from this virtual company. The only purpose of virtual company is to share data across companies, you cannot log into this virtual company.

Dynamics Ax Global Address Book

In this article we will discuss a very important and useful Dynamics Ax feature, Global Address Book. This article is good for both functional and technical consultants.

Note: This article is for advanced Dynamics Ax users. Good knowledge of Dynamics Ax and SQL server is required.

Global Address Book: It 's a mechanism to share organization details, mainly communication and address, between different business entities in the company. For example, you may have a customer which is also a vendor; in this case there would be data redundancy or unnecessary duplication of address data if you had to enter the same address on customer and vendor. Wouldn't it be good, if you can store data once in Address table and share this between different business identities of the company. Yeah, sounds good. Solution to this problem is global address book or sometimes you call it directory.

Dynamics Ax 'SqlStatementExecutePermission' failed

If you are running native SQL statements in Ax, you might see below error while executing code.

Request for the permission of type 'SqlStatementExecutePermission' failed.
(S)\Classes\SqlStatementExecutePermission\demand
(S)\Classes\Statement\executeQuery
(C)\Jobs\RahAddressImport - line 76

Dynamics Ax Query Extended Range Value Expression

In this article we will see how to define extended query ranges using expressions. These expressions can be used in any query where you need to express a range that is more complex than is possible with the usual range value notations.