DYNAMICS-AX-BLOGGER-BLOG

Best Practise Error: different origin value on a new object

2012-08-31T18:30:00.000+02:00

I just got thie Best Pracitse Error on a newly created table in Dynamics AX 2012:

The element has an origin value that is different from the origin value in a previous version of Microsoft Dynamics AX.

Checks that the element had the same origin value in earlier versions of Microsoft Dynamics AX. The origin value is the beginning value of the element. This check was added due to the changes regarding installation specific IDs.
BPErrorObjectOriginMismatch @SYS335100

I was confused about this message, cause it doesn't make any sence for new objects. After a restart of the AOS the error is gone.

Set up AX 2012 to support workflows

2012-08-30T17:30:00.000+02:00

Set up workflows in Dynamics AX 2012

Important steps to check:

System Administration

Setup

System

Server configuration:
check that there is only the AOS instance that is required
acitvate the "is batch server" flag
System Service Accounts
check the Workflow execution account

Workflow

Workflow infrastructure configuration
Click through the wizard to set up the requiered batch jobs

Also don't forget that workflows require CIL. So full CIL generation should be done.

Book: Inside Microsoft Dynamics AX 2012

2012-08-30T11:26:00.001+02:00

The Book "Inside Microsoft Dynamics AX 2012" is ready for pre order at amazon.

CIL Generation problems

2012-08-29T15:25:00.000+02:00

Lately i had some trouble generating CIL. I got some Errors in standard Classes like Retail and SysQuery.

CIL-Generierung: Error 1. Class: SysQuery, Method: queryAddStaticCursorAsRangeAndValue, Exception: System.ArgumentException: Type QueryBuildStaticlink was not found in the CIL that was generated from X++.
\Classes\SysQuery\queryAddStaticCursorAsRangeAndValue
\Classes\RetailStatementPostSalesOrders\createAggregatedSaleLines Err: 351 \Classes\RetailStatementPostSalesOrders\createSalesOrders Err: 351

To get rid of the sysQuery error the following steps did the trick:

Compile SysQuery Class
Start Full CIL Generation

When these steps doesn't solve the problem another option is to deleter CIL Files and restart Full CiL:

Stop the AOS
Delete files in this folder C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL\source
Start the AOS again
Start full CIL generation

Difference between two dates in days

2012-08-21T18:57:00.000+02:00

To get the difference between two dates in dynamics ax just convert the dates into numbers and subtract one from the other. The result would be the amount of days between these dates.

days = date2num(Date123) - date2num(Date234);

To get the difference between two DateTime Values just use the DateTimeUtil Class. The result is the difference in seconds. So just divide these through #secondsPerDay and you'll get the days

#timeConstants

days = DateTimeutil::getDifference(DateTime123, DateTime234) / #secondsPerDay;

AX 2012 view and edit mode

2012-07-26T21:30:00.000+02:00

To find out if a AX 2012 form is in view or edit mode just call:

element.inViewMode();

To catch override the task() method of the form and check if _taskId == #taskEditRecord.

public int task(int _taskId)
{
#task
int ret;
ret = super(_taskId);
if (_taskId == #taskEditRecord)
{
info("edit or view mode?");
}
return ret;
}

Calling a MenuItem

2012-07-25T09:50:00.000+02:00

This post is just for me to remeber these lines of code ;)

MenuFunction menuFunction = new MenuFunction(menuitemdisplaystr(MENUITEM), MenuItemType::Display);
Args args = new Args();

args.caller(element);
args.record(DS);
menuFunction.run(args);

Dynamics AX BaseEnums in SSRS Reports

2012-07-24T11:47:00.003+02:00

In SSRS AX BaseEnums are represented by two fields in the DataSet

Normally there is one with the "name" of the BaseEnum that represents the name of the element and another one called "name1" that contains the label of the element. In some cases this is switched around. So that "name" contains the label and "name1" contains the name of the element.

The only way to notice that is to have a look at the Alias. There you can see LABEL or NAME.

How to sign a Dynamics AX model file

2012-07-23T17:03:00.002+02:00

To sign a model file you need an SNK file. If you don't have one just generate a key pair with the following command:

C:\Program Files\Microsoft SDKs\Windows\v7.0A\Bin\sn.exe -k YOURKEYFILE.snk
/(in older Versions it also could be in v6.0A)

After that the snk file can be used to sign the model that is exported from an AOS. Make sure to set the client config to the right AOS and than just use the following command:

AxUtil export /model:NAMEOFTHEMODEL /file:MODEL.axmodel /key: YOURKEYFILE.snk

VisualStudio Message - .NetFramework.Version=v4.0 Profile Full

2012-06-19T15:30:00.000+02:00

When this message apperas during upgrade of a VisualStudio 2008 project to VisualStudio 2010. Just open the .csproj file in an editor and remove the line:

AXUtil and Powershell

2012-06-11T17:00:00.000+02:00

just to remeber the right syntax:

Import Model:
axutil import /file:abc.axmodel /conflict:push /config:AOSname

Delete Layer:
axutil delete /layer:usr /config:AOSname
instead of /config: it is possible to use the dbName /db:DBname

PowerShell
Uninstall-AXModel -Database "NameOfDB" -Model "NameOfModel"

SSRS Report: Display Image from Database

2012-06-05T10:02:00.000+02:00

To display an image from DynamicsAX in an SSRS report the easiest way is to add an EDT that Extends the Bitmap EDT to the tmp table for the report. In the Dataprovider just add the image to the tmp table (for further information about image handling in ax check the image class).

Than add an image object onto the report design and set the properties. Select the right MIME-Type and try it!

WTF

2012-05-21T16:17:00.000+02:00

Add a single postal location to an ax 2012 form

2012-04-19T17:30:00.000+02:00

To add a single postal address to a form with the new ActionPane there are several steps to do:

Add the EDT LogisticsLocationRecId to the table where the new postalAddress should be added
Add this table to the LogisticsLocationMap and create a Mapping: LogisticsLocationMap.Location == theNewTable.LogsticsLocationRecId
Add the LogisticsPostalAddress Table to the Form
Paste the following code to the form:

public class FormRun extends ObjectRun
{
LogisticsPostalAddressFormHandler addressController;
}

public void init()
{
super();
addressController =
LogisticsPostalAddressFormHandler::newParameters(newTable_ds, logisticsPostalAddress_ds);
addressController.callerUpdateQuery(fieldNum(newTable, LogisticsLocationRecId));

}

public LogisticsPostalAddressFormHandler getAddressController()

{
return addressController;

}
Place an ActionPane to your form with the MenuItemButtons New/Edit/Clear/Map.
The easiest way to do this is to copy and paste it from the BankAccountTable form.
Add this Code to the active method of the main DS:

public int active()
{
int ret;

ret = super();

if (ret)
{
addressController.callerActive();
addressController.callerUpdateButtons(newAddress, editAddress, clearAddress, mapButton);
}
return ret;
}
after that synchronize table and map and than try to open the form ;)

Problems with ordering grid columns

2012-04-11T15:36:00.001+02:00

If there are problems with the ordering of grid columns of a grid inside a tab although the AllowUserSetup of the form is set to Yes. Check if the method tabChanged of the tab control is overwritten. Overwriting this method can cause problems with the re-ordering.
Instead of using the TabChanged on the tab control move the code to the pageActivated method of the TabPage.

Grouping data in SSRS

2012-03-23T10:01:00.000+01:00

To group data on a report you need the grouping pane. If it is not visible click grouping on the view tab.
In the grouping pane right click a group an select add before or after to specify where to add the group. This group dialog opens:

Set the name of the group in this dialog. After that the group expression can be specified. Just add grouping criterias. It is possible to group by data fields or by expressions.

When closing the dialog a new grouping pane is added to the tablix data region. it contains a row or column where group values can be displayed.

Fast way to refresh args caller datasource

2012-03-22T14:26:00.000+01:00

Cause I always forget these two lines of code to research the datasource of the calling args record in Dynamics AX. I will post it here so that I can google it every time I need it ;)

FormDataSource callerDataSource;
;

if (_args != null
&& _args.record() != null)
{
callerDataSource = _args.record().dataSource();
callerDataSource.research(true);
}

Adding an AX table as Dataset to an SSRS Report

2012-03-21T08:57:00.001+01:00

It is important to add the following code in the processReport Method of the DataProvider class in Dynamics AX to use a Table as a new Dataset in an SSRS Report:

newTableNameTmp.setConnection(this.parmUserConnection());

HTML Tags that can be used in SSRS

2012-03-12T13:46:00.000+01:00

To use HTML to format text in SSRS it is important to change the placeholder properties (right click on to the placeholder). In the placeholder properties change the markup type to HTML.

After that it is possible to format text with HTML Tags. The following list of HTML Tags shows possible Tags that can be used in an SSRS control:

Hyperlinks: <A href>
Fonts: <FONT>
Header, style and block elements: <H{n}>, <DIV>, <SPAN>,<P>, <DIV>, <LI>, <HN>
Text format: <B>, <I>, <U>, <S>
List handling: <OL>, <UL>, <LI>

For further information check out the following MSDN Page about Formatting Text and importing HTML.

Empty AX 2012 Project with all main nodes

2012-02-03T15:44:00.000+01:00

To get an empty project with the AOT tree-nodes you can use this project:

EmptyProject.XPO

Change SSRS Report to orientation to landscape

2012-02-02T12:54:00.002+01:00

If you need to change the orientation of a report to landscape or to a different format like letter or DIN A4 there is a real easy way. But you'll have to know this way :)

Right click on the background beside the report and select report properties. (or in german: Berichtseigenschaften...)

Than the following form opens where it's possible to change the orientation, the size and so on...

SSRS Insert new field error - field token is invalid

2012-01-26T14:27:00.001+01:00

If you get this error message:

Field token Fields!MyNewField.Value is invalid. Could not find the identifier. \SSRS\Reports\Reports\

when you try to add a new field from AX to a SSRS Report.

The first thing to do is to refresh the datasets in VisualStudio.

After that you should check the Query property of the DS. If there is a fieldlist in the select statement. Just click into the property and open the "Select a Microsoft Dynamics AX Report Data Provider" Dialog. Select the required DataProvider Class and click Next. Than you'll get the possibility to select some or all fields from the tables that are provided by the DP class.

Workflow links - ax 2012

2012-01-19T17:22:00.005+01:00

Open Visual Studio with another AX configuration

2012-01-11T13:30:00.001+01:00

If you need to start Visual Studio connected to another AOS there are two ways to do this:

Create a shortcut:

add the/AxConfig command in the Target field:
"C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe" /AxConfig NameOfClientConfig
or
"C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe" /AxConfig C:\AX2012ClientConfig\ClientConfig.axc
CommandLine:

Dynamics AX 2012 SSRS links

2012-01-10T16:43:00.000+01:00