Monthly Archives: July 2008

Code code to generate code in Dynamics AX

Posted on July 31, 2008 by gatesasbait

  Good morning,   The following job will create a new static method on the SalesLine table at runtime. Use it as a tutorial for TreeNodes’ AOTadd(), AOTsetSource(), AOTcompile() and AOTfindChild() methods.   Note that access to such code should … Continue reading →

Posted in Dynamics Ax 4.0x | Comments Off on Code code to generate code in Dynamics AX

Dynamics AX 2009 Report Deployment error

Posted on July 17, 2008 by gatesasbait

  Good morning   If you get either of the following two errors when deploying SQL Reports from Dynamics AX 2009 over to SQL Reporting services, you may have a bad <URLRoot> parameter in file <drive:>\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config. … Continue reading →

Posted in Dynamics AX 2009 | Comments Off on Dynamics AX 2009 Report Deployment error

Transferring users and security between environments (in AX4)

Posted on July 15, 2008 by gatesasbait

  Good morning,   To transfer security and users between AX4 environments, create a data import-export definition group (in Admin-> Periodic) containing the following tables: -SysUserInfo-SysRecordLevelSecurity-AccessRightsList-UserGroupList-UserGroupInfo-UserInfo -SysCompanyUserInfo -SysCompanyUserSiteAccess and export it from one environment into another.

Posted in Dynamics Ax 4.0x | Comments Off on Transferring users and security between environments (in AX4)

How to define a custom lookup form for an extended datatype

Posted on July 9, 2008 by gatesasbait

  Good morning, continuing on the topic of various custom lookup how-tos,   Normally, the relation specified on an extended datatype defines its lookup method, however, it is possible to override that with a custom lookup to use automatically everywhere that … Continue reading →

Posted in Dynamics Ax 4.0x | Comments Off on How to define a custom lookup form for an extended datatype

Custom label on SysTableLookup column

Posted on July 9, 2008 by gatesasbait

  Good evening,   This shows how to put a custom label on a SysTableLookup:   public static void lookupSalesId(FormStringControl _ctrl){    SysTableLookup sysTableLookup =         SysTableLookup::newParameters(tablenum(SalesTable), _ctrl);    Query query = new Query();    ;       query.addDataSource(tablenum(SalesTable));       //’true’ is used … Continue reading →

Posted in Dynamics Ax 4.0x | Comments Off on Custom label on SysTableLookup column

Installing Reporting Services, Analysis Services and Enterprise Portal for AX 2009

Posted on July 2, 2008 by gatesasbait

  Good afternoon,   I’ve just written up a quick guide on installing Reporting services for AX 2009 for a development box. Here is the gist of the text:   Before installing AX 2009   Setup a Windows Server 2003 … Continue reading →

Posted in Dynamics AX 2009 | Comments Off on Installing Reporting Services, Analysis Services and Enterprise Portal for AX 2009

On Dynamics AX 2009 Perspectives, OLAP Cubes and Analysis Server

Posted on July 2, 2008 by gatesasbait

  Good morning,   I’ve been working with Cubes in Dynamics AX 2009 to modify some out-of-the-box Enterprise Portal reports. I had to add a measure to an existing cube, and that measure was the sum of a new column … Continue reading →

Posted in Dynamics AX 2009 | Comments Off on On Dynamics AX 2009 Perspectives, OLAP Cubes and Analysis Server