Robin - robsCode (Page 2)

[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

[PS] Get AOS Errors of past two days

Sometimes it is necessary to have a look into the Windows Event Log and check for errors of the Dynamics AX AOS Service. This can be very time consuming especially when the log has a huge amount of entries. Even opening and filtering takes quite some time then. To speed

Dynamics

[X++] Deploy C# Project as assembly to AX

When using .NET Dlls in Dynamics AX 2012 the normal way to include them is to add the DLL files as reference to the References node in the AOT. But how to deploy a .NET assembly developed by yourself? The best way to develop a .NET assembly for AX is

ssrs

[SSRS] Use Enum values in filter expressions

When designing SSRS Reports with Data from Dynamcis AX, most of the datasets contains enum fields. But first let me give you a little background on enum fields. How to treat enum fields Those fields must be treated in a special way because each enum field appears as it is

X++

[X++] Wrong argument types in variable assignment

Quick reminder for common mistake: Error Message Sometimes it is the case that you modified a class and get an error when running the code afterwards in a different element or in a different method saying: Wrong argument types in variable assignment Solution compile forward on most upper class in

PowerShell

PowerShell list installed software

PowerShell is a mighty tool when it comes to Microsoft environments. But most of the time one is searching on the internet for the wanted CMDLets and functions. Today I was searching for a quick way to list the software currently installed on my (64-bit) maschine because I'm going to

C#

[C#] nameof function

Today I'd like to introduce you the neat build-in function called nameof from C# 6.0 and above. This function comes in handy when you want to obtain the string name of a variable, type or member. This is often used when logging errors on debug level to include the

Dynamics Featured

Imzy community for dynamics ax

There is a new thing on the net called imzy. It is led by the former SVP of product at Reddit and founder of Redditgifts, Dan McComas, and backed by the investors of Patreon, Twitter, and Foursquare, They are changing the way communities exist on the internet and build something

RaspberryPi

Setup script for auto mount external hdd's on raspberry pi

Since I am using multiple raspberry pi's at my house for different tasks, I am also having one working as a cheap NAS server on my home network. The setup is simple: * A raspberry pi * A USB hub with external power supply * An external hard drive But the problem with

C#

[C#] Cast Collection to List with Linq

Sometimes it is better to work with a List than a collection, but how to cast if only a collection is available? And to keep it short, how to accomplish that with Linq? The answer is simple: var resultList = (from TYPE mItem in originCollection select mItem).ToList(); Explained: * TYPE is

Dynamics

[X++] Labels and TFS

When using Dynamics AX 2012 with the Team Foundation Server as version control, the TFS handles your labels different than the standard AX. When creating a new label in AX, it will get a temporary ID. When checking in the label, it gets its real ID and the TFS will

Dynamics

[AX7] Synchronize only project contents

Full Database synchronization When using the new Microsoft Dynamics AX7 (Technical Preview) there is an option to perform a full database synchronization via Dynamics 'AX 7' > Synchronize database... Selective synchronization But there is no option on a table to synchronize only the selected table like in previous versions of AX.

Dynamics

[X++] Folder Lookup with FilePath on forms

Today I am writing myself a little reminder and I hope you can use it sometime, too. When using a field extended by the Extended Data Type FilePath on a form the user expects to see the following "Browse for Folder" dialog after clicking on the folder icon next to

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++] CIL Generation Error .NET Cast Type Name not found

Sometimes you create a new custom service or any other class and the CIL compilation will throw an error similar to the following: CIL generation: Error: .NET Cast Type Name not found. Type System.String found on the stack. This code in Class/Table: [ClassName], Method: [MethodName] may not work

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++] EntireTableCache and RecordViewCache

The Best Practice standards of Microsoft says that a table should be cached as much as possible. For small tables it's recommended to use the table property CacheLookup and set it to EntireTable. When using EnitreTableCache all records in the table will be cached on the server and the cache

Dynamics

[X++] Display methods on FormDatasource

Brief explanation Display methods are written quickly and can run logic to calucalte values that can't be calculated with joins on forms. They can appear on a form or a report. A display method is any method that includes the display keyword as a method modifier. You can use the

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

[SSRS] Split invoice lines into separate reports

I had the requirement from a customer to split certain lines into a separate report when printing an sales invoice. This requirement was new to me and I found it very interesting so I want to share my experience and my solution for this with you. Research First the process

Dynamics

[X++] Error "Voucher already in use as of date"

When seeing the error message "Voucher CEU-000001 is already used as of date 31.12.2014." (sequence number and date can vary) it is based on duplicate number sequences. In my case it appeared when posting a sales invoice. The number sequence for Sales order - free text invoice was

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

C#

[C#] Object Initializer - overloaded constructor belong to the past

Today I want to explain the Object Initializer in use with C#, which is a best practice for C# developers. Unfortunately overloaded Constructors can be found to initialize Objects with different kinds of parameters. Let's say we have a class called LogEntry: public class LogEntry { // Properties public string message { get;