Dynamics AX 2012 SSRS reports patterns

Here are the design pattern/changes that we need to make sure for AX 2012 SSRS report development:

Functional Area	AX2009	AX2012
Input parameters (definition)	Report	Data contract (*)
Input parameters (validation)	Report	Data contract (*)
Input dialog (simple)	Report	Data contract (*)
Input dialog (complex)	Report	UI Builder (*)
Input parameters (modification)	Report	Controller (*)
Dynamic query	Report	Query
Report data	Report	Table (temp)
Business logic	Report	RDP
Report layout	Report	SSRS Report

Dynamics AX 2009 and Dynamics AX 2012 modules comparisons

Following are the enhancements made by Microsoft on Dynamics AX 2012:

For example, GL module in AX 2009 is now break into GL and Fixed assets in AX 2012.

AX 2009 Module	AX 2012 Module
General Ledger	General Ledger
	Fixed Assets (New)
Bank	Cash and bank management
Accounts Payable	Accounts Payable
	Procurement and sourcing (New)
Accounts Receivables	Accounts Receivables
	Sales and Marketing (New)
Inventory Management	Product information (New)
	Inventory  and warehouse management
Expense management	Travel and expense management
Production	Production control
Project	Project management and accounting
	Compliance and internal control (New)

Change company logo on EP home page

Here is the very useful link for displaying/changing the Dynamics AX 2009 EP home page.
Display Company Logo on Dynamics EP Site and Hide Page Title

alternatively/in dynamics ax 2012, you can change the logo from C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\ep\images\ location and change the name you your logo file to DynamicsLogo64x64.png 

Cannot connect to the Configuration database error – SharePoint 2010

Resolution steps:
1. If the WSS is in a server farm, use the “SharePoint Products and Technologies Configuration Wizard” to disconnect the server from the farm.
2. Navigate to Start >Program > Microsoft SQL Server 2005 > Configuration Tools >SQL Server Configuration Manager
3. Navigate to SQL Server 2005 Network Configuration > Protocol for MSSQLSERVER
4. Right click Named Pipes and select Enable (if not enabled)
5. Restart SQL Server
6. Join back the server to server farm using “SharePoint Products and Technologies Configuration Wizard” and follow the wizards
Note: If the installation is a stand-alone installation, then you don’t need to worry about steps 1 & 6

Show/Hide the dialog range field

To hide/show the query dialog field, you need to implement/override the showIndexFields() method of the dialog and return FALSE if you want to hide the field from the dialog query range.


here is an example:

public boolean showIndexFields(tableId _tableId)
{ 
boolean ret = true; 
  
switch (_tableId)
{ 
case tableNum(YourTable): 
ret = false; 
break; 
} 

return ret; 
}

Dynamics AX 2012 Price list

If you are interested in knowing the cost of a Dynamics AX 2012 license, Microsoft has provided a an Excel sheet that can help you estimate the cost of your implementation.


You can download the sheet from here

Drum Roll Please… Microsoft Dynamics AX 2012 is now on the market!

Dynamics AX 2012 is released on 25 countries, please see the details:
Dynamics AX 2012 released !!!!