Install Enterprise Portal – Part 2
In the first part we installed Enterprise Portal on Dynamics AX and we should have it working, but there is more.
Install Enterprise Portal – Part 1
Looking at the documentation provided by Microsoft for installing Enterprise Portal, it should be an easy task, but sometimes it requires a little change in the order and options suggested by Microsoft.
SSRS with SSAS – message with no host or could not find host in AX 2012
When running report connected with SSAS users get message “No such host is known” or “A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond <host or IP>”.
SSRS with SSAS – message with no access to database in AX 2012
When running report connected with SSAS users get message “Either the user, <user>, does not have access to the <database> database, or the database does not exist.”.
Install CU9 – step by step – Part 2
This is a continuation of the cumulative updates installation guide. In this part I will focus on installing updates on a Live environment.
Install CU9 – step by step – Part 1
The difficulty of installing cumulative updates depends on how much customisation was done in the Client system. The relationship is quite easy: the more customisation, the harder it is, and the more time required to investigate and test issues.
Ghost object in USR layer in AX 2012
Sometimes after compilation you can get objects marked as changed in USR layer, but when you compare them with lower layer there are no changes.
AIF testing in AX 2012
There are a couple of ways to test AIF inbound classes in Dynamics AX:
Create and read XML using XSD tool in AX 2012
In Dynamics AX there is no standard feature to serialise/ de-serialise data to XML file based on an XSD schema.
Create standard class methods for AX 2012
In Dynamics AX is very often needed to create standard class methods like construct, main, parm methods etc. In this post I’ll show you how to create them the fastest way using Dynamics AX built-in functionality.
Resolving TFS synchronisation issues in AX 2012
There are plenty of problems in AX 2012 in synchronising elements with TFS, especially when multiple developers are working on isolated environments and adding new code frequently.
JSON utility class for AX 2012
When implementing Retail for Dynamics AX you could have a lot of different retail channels and with it a lot of different messages that need to communicate with Dynamics AX.
Advanced XDS policies (secret recipies in AX 2012)
Almost every production company has some secret recipe that needs to be visible only for specific group of people inside the company.
Table browser form enhancement in AOT
SysTableBrowser form or simply Table browser is form widely used from developers within the development workspace in Dynamics AX.
Quicksort procedure for containers (using recursion in AX 2012)
Quicksort is efficient sorting algorithm which is useful for sorting any data structures that have some sort of key. In this article I’ll show how to create basic quicksort algorithm in X++ for containers containing numbers.
Reference group in table browser in AX 2012
Table browser is a widely used tool for viewing table data directly from Microsoft Dynamics AX development workspace. A simple, grid-based form presents selected records from a particular table.
Insert_recordset with outer join – column does not allow nulls in AX 2012
The following error can be seen when using insert_recordset together with outer joins:
Import CSV File: AIF method – Part 3
So far we have created and deployed Service and created the transformation, we are almost there, now we need to put this together and create inbound port.
Import CSV File: AIF method – Part 2
In part 1 we have created and deployed Service. (AttributeTableConfigService). Now we need to create XML file from .csv that can be compiled with AIF schema. That can be done as it was already mentioned in part 1 by using .NET assembly transformation.
Reducing round-trips between database and server in AX 2012
X++ supports set – based manipulation on the database. There are three set-based operators available in Microsoft Dynamics AX 2012.
Read XML file from URL in AX 2012
In this article I would like to show how we can read from XML files.
Simple way to extend AIF outbound data in AX 2012
If there is a need to extend data produced for AIF export, i.e. from tables related to the root data source of AIF query, instead of adding data source(s) to the query we can simply extend the AxABC class with additional parameters. Below is the quick guide how to do it.
Refreshing data source on the calling form in AX 2012
Sometimes there is a need to refresh the calling form’s data source(s) after the operation. For this reason task on the form could be used.
Adding new feature to context menu for AOT objects in AX 2012
Sometimes there is a need to add new feature to standard context menu. Let’s assume that we want in a quick way change the developer’s startup project.
Test or debug with specific user privileges in AX 2012
Developers as default have a system administrator privileges so they can access all system functionality without any restrictions.
Data import export framework – get staging data error in AX 2012
When we are importing data using DIXF framework – during get staging data process – following error could be thrown:
Building queries with fetchmode property in AX 2012
Let’s assume that we want to have a query which will return the same records like following select statement:
Renaming primary key in AX 2012
In Microsoft Dynamics AX 2012 is a standard functionality to rename Primary Key. It renames primary key in master table and all allowed corresponding tables.
Full text indexes in AX 2012
Dynamics AX 2012 uses full-text indexes maintained by Full-Text Engine for SQL Server.
How to open AX 2012 form from intranet web page or external application
Hi fellow Microsoft Dynamics AX coders!
Invoking private methods outside declaring class in AX 2012
There are three method accessibility modifiers in X++ language. It is well known knowledge of their purpose, as they are common for many programming languages.
Initialisation and validation of data contract in AX 2012
If we need to initialise or validate data contract members’ values we can use two dedicated interfaces for that. They are named SysOperationInitializable and SysOperationValidatable.
Keep together property is not working properly in AX 2012
You can see this behaviour when you try to export your Report for example to PDF.
Additional empty page on SSRS reports in AX 2012
The problem with blank pages occurs when you try to print the report or save it in the pdf file.
Basics of working with date effective framework in AX 2012 – Part 3
In this short part of blog I will cover querying the data from code using select statements and code or application queries.
Basics of working with date effective framework in AX 2012 – Part 2
In previous part of blog I introduced the way of preparing tables in order to track data using date effective framework. This part is focusing on general operations with data inside date effective tables we prepared last time.
Basics of working with date effective framework in AX 2012 – Part 1
Sometimes we have a need to follow data changes during some period of time. In order to achieve this during development in Dynamics AX 2012 we might want to use date effective framework.
List panels with search option with AX 2012
In previous article we created form with list panels allowing us to specify which of suppliers need to be marked as temporary vendors.
List panels without tabs AX 2012
List panel can be very useful functionality especially from user perspective.
Drag and drop grid functionality in AX 2012
Drag and drop can be achieved by using different styles on form like: tree control or list panel control as those types of approach can be very easy from development perspective sometime they can be not so user friendly.
Data migration tool in AX 2012
After adding EDT that extends table we came across this error: “The relation under the extended data type (EDT) ProjId must be migrated to a table relation. Consider using the EDT relation migration tool.”
Inheritance form in AX 2012
Creation of form based on inheritance tables without “Specifying type of new record” dialog box.
OOP101 in AX 2012 part 3: Polymorphism
Using inheritance patterns or implementing an interfaces gives us quite a few advantages, one of which is undoubtedly the property of the inclusion polymorphism.
OOP101 in AX 2012 part 2: Inheritance and abstract classes
Inheritance is one of the most if not the most important OOP concept. If implemented properly it should keep us safe from the unnecessary code duplication.
OOP101 in AX 2012 part 1: Interfaces
X++ programming language is a class based object oriented programming language and it allows developers to use abstract types.
Classic Minesweeper mini-game for Dynamics AX 2012
As you might already know, there are a few minigames in Microsoft Dynamics AX to be found, like tutorial_Tetris and tutorial_Memory but there is no minesweeper and that is a shame.
Three ways to count time in Dynamic AX 2012
Today I would like to show you three useful approaches to count elapsed time, inside the Dynamics AX 2012. I will also perform simple comparison between the methods.
Design your custom code snippets inside AX 2012
In Dynamics AX 2012 there is a simple way to add custom code snippets and have them always by your side whenever you want them.
Using reflections – intrinsic functions
As you might notice already there is nothing that much annoying as well hidden run time error in the code that you written.
Get printable name – fieldId2PName function
Today I will show you how to use fieldId2pname and where in the standard it is being used.
Union view basics and common issues in Dynamics AX 2012
Views in Microsoft Dynamics AX 2012 are basically virtual tables which contents are defined by one or more sources of data.