real solutions for real problems
Welcome to MSDN Blogs Sign in | Join | Help

April 2009 - Posts

Watermarks on reports

Recently I was confronted with the requirement to place a watermark on a report. Finally I found 3 different ways to do this: use a SSRS (SQL Server Reporting Services) to make reports add background image over whole Report (X++ Report), mark all fields
Posted by EMEAAXTec | 1 Comments

Default Cube Advisor Tool for Microsoft Dynamics AX 2009 has been released

The Default Cube Advisor Tool for Microsoft Dynamics AX 2009 generates a list of Cube and Role Center elements that are not valid for the specific license and configuration keys you are using. This tool complements the whitepaper Microsoft Dynamics AX

The Dynamics AX DB Upgrade Preparation Tool (AxDbUpgrade.exe) crashes after launching

I was once launching the Dynamics AX DB Upgrade Preparation Tool (AxDbUpgrade.exe) on a Windows Server 2008. I was using the version distributed with the Dynamics AX 2009 DVD. The issue here was that the tool was crashing shortly after launching. In the

Running a Dynamics AX 4.0 AOS on a 64bit Windows Server 2008

Not too long ago I was installing a Dynamics AX 4.0 AOS on a 64bit Windows Server 2008. After the Dynamics AX Setup was finished I was however unable to start the Server Configuration Utility because of the following error: Activation context generation
Posted by EMEAAXTec | 1 Comments
Filed under: , , , ,

Known issue with datepicker in Grid

If you are using the SysDateLookup form on a table grid, we please be aware of the following issue. Unfortunately the selected date on the calendar is incorrect. Instead of showing the date value of the field, the calendar is showing the date value of
Posted by EMEAAXTec | 1 Comments
Filed under: , , ,

EXTERNAL as field name in SQL Server 2005

Maybe you already ran into the issue that you are using Dynamics AX 4.0 SP1 with SQL Server 2005. You are trying to create a new table in AOT with a column called "external". You recognize, that during the synchronization of the table with SQL Server
Posted by EMEAAXTec | 1 Comments

Questions to web-development

While planning to create a web page based on Dynamics AX data we came across the following questions: Is it possible to connect from php with use of business connector to Dynamics AX? If so how? Is there any example available? Is it possible to connect

Dynamics AX 2009 Enterprise Portal requires Analysis Management Objects (AMO) for SQL Server

I was recently installing a new Dynamics AX 2009 environment where I was having Enterprise Portal installed on a separate machine. When running the Dynamics AX Setup for the Enterprise Portal and Role Center role the installation completed with warnings.

Importing a Dynamics AX XPO file in Business Connector session is not possible

Recently I was asked the question how it is possible to import a Dynamics AX XPO file to Dynamics AX from X++ code. This is actually possible using the SysImportElements class. However this approach does not work if the XPO file should be imported in
Posted by EMEAAXTec | 3 Comments
Filed under: , , , , ,

The registration of a new Dynamics AX 4.0 Enterprise Portal site fails

I once had the problem that I was not able to create any new Dynamics AX 4.0 Enterprise Portal sites. The error ocurred during the registration phase after selecting a company account. The error message showing up in the browser was: The Web site http://server/site

Batch user has no permission to write a file

I have a Class wich writes a File to a Network share (I also tried it local it was no difference). If I start the Class in my normal Client session, it works. But if I start it in a batch, the debugger opens and I get an Stack Trace Error. The Infolog
Posted by EMEAAXTec | 1 Comments
Filed under: , , , , ,

Error passing Int64 parameter to the SSRS report

When you are designing new Microsoft SQL Server Reporting Services Reports with the Microsoft Dynamics AX 2009 Reporting Extension in Microsoft Visual Studio 2008, you sometimes face the following situation. The new report is based on a Microsoft Dynamics
Posted by EMEAAXTec | 1 Comments

AX2009 uses incorrect Firewall Rule on Win2008

Recently we figured out that when you are installing a Dynamics AX 2009 Application Object Server (AOS) on a Windows Server 2008, that has the Windows Firewall turned on and you are trying to connect with a Dynamics AX 2009 client to the new Dynamics
Posted by EMEAAXTec | 1 Comments

Importing of Excel templates with Timezone values sometimes fails

In Dynamics AX 2009 the Timezone support was introduced, so when you are now entering a time value you can also specify the Timezone that corresponds the entered value. In conjunction with the Excel Template Wizard you may however run into a small isssue,
Posted by EMEAAXTec | 1 Comments
Filed under: ,

How does the session validation work in Dynamics AX 4.0?

The Dynamics AX AOS is regularly validating Client sessions in order to free sessions from inactive Clients, e. g. if the Dynamics AX Client process (ax32.exe) was terminated in Task Manager rather than closing the Client gracefully. This Server side
Posted by EMEAAXTec | 4 Comments
Filed under: , , , ,

How to check if LabelId exist

You are having some X++ code in Dynamics AX 4.0 where the "exists" method of the Label class is called to check if certain Label IDs are present. But for each constant Label ID you pass to the method "Label::exits" the method is returning "false". This
Posted by EMEAAXTec | 1 Comments
Filed under: ,

Problems during importing a new license file into Dynamics AX 4.0

Recently we were confronted with the following situation during importing a new license file into Dynamics AX 4.0. During the import of the license file the Dynamics AX Client crashes. After a restart of the Dynamics AX Client no dialog can be opened.

Side by side installation of Dynamcis AX 4.0 Client and Dynamics AX 2009 Client

It is quite comon for a Dynamics AX developer to have multiple versions of Dynamics AX Clients installed on the same PC. However when you are having Dynamics AX 4.0 Client and Dynamics AX 2009 Client installed on the same machine you can run into issues,

The Manage Deployments Form does not show all existing IIS Virtual Servers

I was once in the situation that in the Dynamics AX Client the Manage Deployment Form (EPUpdate), found under "Administration | Setup | Internet | Enterprise Portal", did not list all Virtual Servers that were existing on IIS. In this particular scenario
Posted by EMEAAXTec | 1 Comments

Dynamics AX and Generic collections of .Net

I'm using Dynamics AX 2009 and want to instantiate the .NET class "System.Collections.Generic.List" in X++. Intellisense expands the class to "System.Collections.Generic.List`1" however the code cannot be compiled as the class as well as all other classes
Posted by EMEAAXTec | 2 Comments
Filed under: , ,

Connection to the AOS from a trusted domain is not possible

I was facing today the situation that a Dynamics AX Client in a trusted ActiveDirectory Domain was not able to connect to the Dynamics AX AOS in the other Domain. When launching the Dynamics AX Client, the following error message showed up: No Connection
Posted by EMEAAXTec | 1 Comments
Filed under: , , ,

Using Outlook signature when sending mails from Dynamics AX

You are using Dynamics AX 4.0 SP2 and Outlook 2003. Certain Reports (like Confirmations) your customer is sending out by E-Mail attached as PDF. In Outlook 2003 you have configured a Signature that is added automatically to each E-Mail. But in Outlook
Posted by EMEAAXTec | 1 Comments
Filed under: , , ,

RPC packet size limit causes trouble in the Dynamics AX Document Handling

The Document Management in Dynamics AX allows you to "attach" files to records of certain Dynamics AX tables. Those files are either placed on the File System (Hard Disk, Netwok Share) or stored within the Dynamics AX database in a BLOB field. For files
Posted by EMEAAXTec | 1 Comments

How to import CRM Leads

When you go to "CRM | Periodic | Import | Leads" you receive the following message in the InfoLog: "An administrator must first configure or define a format for the Lead import" This is because the CRM Import in Dynamics AX 2009 is based on XML files
Posted by EMEAAXTec | 3 Comments
Filed under: , ,

Attachment(s): CRMImports.zip

Importing a WebPart Page created with SharePoint Designer to the AOT fails

The Enterprise Portal in Dynamics AX 4.0 and Dynamics AX 2009 is based on Microsoft SharePoint Technologies. This is for sure nothing new for you. Because of this fact you can use a SharePoint compatible editor like Microsoft SharePoint Desinger to modify

Document Handling with protected Microsoft Office Word Template

Document handling in Dynamics AX is a very flexible way to create nice looking Microsoft Office Word documents where Bookmarks in Word are replaced with data from Dynamics AX. Microsoft Office Word on the other hand offers with Form Controls like DropDown
Posted by EMEAAXTec | 1 Comments
Filed under: , , ,

The grid filter is doing strange things when filtering for decimal numbers

Dynamics AX has a real nice powerful column / grid filter, and that for many versions. However when you try to filter a column having decimal values for a decimal number you might seeing strange things happen - when you are living in a country having
Posted by EMEAAXTec | 1 Comments

Unable to deploy ODC files to Enterprise Portal even after installing Hotfix KB960158

I was recently running into the situation that with Dynamics AX 2009 Service Pack 1 I was not possible to deply ODC files to Enterprise Portal when Microsoft SQL Server 2008 Analysis Services was used as backend database. The error message that showed
 
Page view tracker