2012 - robsCode

[TFS] Object is already checked out to . (empty user)

This morning I wanted to check out an object within Dynamics AX 2012 which is connected to a local TFS instance. The system came up with the following error message: '\Forms\CustSettlement' is already checked out to . After checking it withing source control explorer from Visual Studio, the object

X++

[X++] Alternative: Get rid of BP error 839: Only foreign key constraints are allowed on this table

Property EnforceFKRelation When creating new tables in Dynamics AX 2012, there is a hidden property in the background called EnforceFKRelation. This property defines if the tables enforces ForeignKey Relations or not and is set to 1 (True) on newly created tables. This property does not appear anywhere in the AOT,

X++

[X++] Tip: Clear all nodes in shared AOT project

I had the need to modify a SharedProject and remove some nodes from it, add groups and add new nodes to it. All by code. One requirement was to clear all content from the AOT Project first and then add groups and the single nodes again. There is a simple

Dynamics

[X++] getFirstSelection global function

Today I stumpled upon a global function called getFirstSelection that I never saw before in Dynamics AX 2012. What is getFirstSelection? Basically this is a function residing in the Global class to return the first selected record of a FormDataSource or the current cursor position if no selection can be

Dynamics

[X++] Find worker assigned to specific user

I already posted an article how to find the worker related to the current logged in User in Dynamics AX 2012 (here). Now here is a peace of code to get the associated worker of any specific user, not just the current logged in user: HcmWorkerRecId workerRecId; HcmWorker hcmWorker; UserId

Dynamics

[X++] Product and Item (AIF) Services in Dynamics AX 2012

Just to give a short overview about the 4 most common used AIF Services in Dynamics AX 2012 and their purpose, I created a short graphic: Service Purpose EcoResProductService Create products (all types). The service can also be used to retrieve data that has already been created. EcoResProductMasterDimValueService Specify values

Dynamics

[X++] Client performance options and preview panes

Preview Panes, Info parts and fact boxes were introduced with Dynamics AX 2012. Info parts and fact boxes are shown on the right side of ListPages while preview panes are shown at the bottom. One good example is the ListPage for the sales orders SalesTableListPage: You can hide the preview

Dynamics

[X++] Get all sizes for a product by code

When dealing with product dimensions by code, a developer can have a hard time finding the right combinations of dimensions and understanding the hardly normalized table structure behind the products in AX 2012. I was searching for an elegant way to get all available combinations of the product dimension Size

Dynamics

Dynamics AX7 Launch Portal

Microsoft just published a Launch Portal for Dynamics AX7 with sessions from WPC, Sales & Marketing informations, various Launch Events and stuff. It's worth a look! https://mbs.microsoft.com/partnersource/northamerica/readiness-training/readiness-training-news/AX7LaunchPortal

Dynamics

[X++] class AxaptaUserManager, PowerShell and BusinessConnector

Today I stumpled on a little inconspicuous class called AxaptaUserManager. Taking a closer look to the methods, there are some useful ones. Now to combine the class with some useful functionallity, for example we can get all security roles assigned to the current user. To make it even more interesting

Dynamics

[X++] DMF/DIXF Custom generate method R2/R3

With the Data Import/Export Framework => DIXF (old: Data Migration Framework => DMF) we have the possibillity to import all kinds of data. But when it comes to writing custom logic for imports, there is a small but significant change between Dynamics AX 2012 R2 and R3. First of all, lets

Dynamics

[SSRS] AgreementConirmation add new Design

I tried to add a new Design to the Report AgreementConfirmation recently and struggled to get the new Design printed out. My approach was to set the parmReportName() in the main method of the AgreementConfirmationController class. Unfortunately that doesn't worked. The default Design Report always got printed. After digging deeper

Dynamics

[X++] TempDB refresh Data on FormDatasource

When using a TempDB as a FormDatasource and populating the data with a populateData method returning a Common i struggled to change the data when the caller changes. In Dynamics AX it's a normal behavior on journal forms that the lines / details form changes displays the data related to the

Dynamics

[X++] BOF / SOF Change Query in dialog dynamically

Normally you have a DataContract with a method for your query and the SOF puts it to the dialog automatically and you do not have to worry about anything. We all know how to override methods in a SOF Dialog (if not, don't worry i explain it later). But what

Dynamics

[X++] BOF / SOF Change Query in dialog dynamically

Normally you have a DataContract with a method for your query and the SOF puts it to the dialog automatically and you do not have to worry about anything. We all know how to override methods in a SOF Dialog (if not, don't worry i explain it later). But what

Dynamics

[X++] Find worker assigned to current user

To find the worker / employee of the current user in Dynamics AX 2012 you can use the currentWorker method of table DirPersonUser. It returns the RecId of HcmWorker table. HcmWorkerRecId workerRecId; workerRecId = DirPersonUser::currentWorker(); Note: Find out how to retrieve associated worker for a specific user here

Dynamics

[X++] Find worker assigned to current user

To find the worker / employee of the current user in Dynamics AX 2012 you can use the currentWorker method of table DirPersonUser. It returns the RecId of HcmWorker table. HcmWorkerRecId workerRecId; workerRecId = DirPersonUser::currentWorker();