Dynamics 365: Learn in doing

Today, I have tried to upgrade RAM on my server and faced some challenges as the server is not recognizing the new RAM, I have added. So I did some googling and found some important and crisp information. So would like to share the same for everyone's convenience.  The below youtube links are all what you need in order to understand what and how you need to do a RAM upgrade in your desktop machine or a laptop.  Introduction to RAM (Memory) - Video link   Features and types of Memory - Video link Upgrading Memory in your Desktop - Video link  Upgrading Memory to Desktop and a Laptop - Video link Like mentioned in the video links, the sites and tools you must use before you make the decision of either buying or upgrading your RAM are:  www.crucial.com   www.cpuid.com   Hope this helps. Good luck. 

In X++, container is one of the primitive (value) types. A container can contain an ordered sequence of primitive values or other containers. A container can be used as one of the column types that you can select when you add a new column to a table in AOT. Thereby, it can be stored in the database. Container is not a class. Containers can be said to be similar to an arary or List/stack classes. But with Containers you can never change size or content of an existing container. Another interesting thing about containers is that they are immutable. Even though few X++ statements in the System code appear to modify a container, they are actually internally building a new container and copying values as necessary. Even an assignment of a container to another container variable creates a new copy of the container. Because of all this, usage of containers are said to have performance implications. The X++ function conPeek returns an anytype type. The flexibility of anytype makes contain...

Temporary table(Table whose property temporary set to "yes") is not persistent media , so at run-time you have to populate the temporary table and attach the same to the form/report. For illustration purpose ,I am using inventTable data and attaching the items whose group is Parts. Steps 1. Create temporary table as TmpTestTable with 3 fields(ItemId,Itemname,ItemGroup). 2. Create a form as TempTestTable and attach the table as datasource 3. Create a new method on the form and copy the following code TmpTestTable populateRecords(ItemGroupId _itemGroupId) { TmpTestTable tmpTable; InventTable inventTable; ; while select inventTable where inventTable.ItemGroupId == _itemGroupId { tmpTable.Itemid = inventTable.ItemId; tmpTable.ItemName = inventTable.ItemName; tmpTable.Itemgroup = inventTable.ItemGroupId; tmpTable.insert(); } return tmpTable; } 4. Call the above method in init() after super as below public void init() { super(); // Call the setTmpData method to attach rec...

Today I was working on SSRS report changes and everything went fine in the DEV environment. And the code changes had to be moved to UAT environment. However, even after a successfully deployment of the report, I was getting the below error when I was trying to view report from AX Form. Error message: " For more information about this error navigate to the report server on the local server machine, or enable remote errors " Why do we get this error: Most probably there are two reasons, 1. There is some error in the .net code 2. The IL code is not reflected with the .net code changes made for the report. Suggested solution approach: I have approached the troubleshooting in the below order, 1. Compile the objects 2. Generate Incremental CIL 3. Redeploy the SSRS report. Ideally you should be able to run the report, if the issue was with IL code not reflecting with your code changes. Hope this helps. Good luck! P.S. In case you are not able to resolve the issu...

The SSRS reporting concepts are very well explained in the below link, you can go through the same for a good understanding of SSRS with Dynamics Ax. Below are few important related points listed and also the Reporting Services Overview slide.  Reporting services overview The picture is self explantory and just to brief things up: Basically a Report Model can contain Reports, Layout Templates, Table Style templates, Report Database etc.. And nodes which we can find under Report/Report Model are Datasets, Desgin, Parameters, Data methods and Images. In Ax terms, a Datasets can be said to be a data source and collection of fields from data source. And basically an Ax Query, SQL Data, OLAP data (cube) and a Data method can act as a Data source for a report Design node of a Report/Report model will contain three major parts, namely, Header, Body and Footer. And the Desgins can be of two types, namely Auto Design and Precision design. Dynamics Ax will take of...

We have already created a very simple and basic report. For more details look at the Internal links listed below. And now we are going to make our report look better. And the simplest way to have the reports to have standard look and layout is "to set AutoDesign's several properties" AutoDesign has a property called Layout template , and DataRegion (CustTable) has a property called Style template. By modifying these two properties we can actually have a better look and feel for our report. Layout Template: This can be found under properties for AutoDesign node. When I click the comboBox to see the options avaliable for LayoutTemplate, I see the below and I choose "ReportLayoutStyleTemplateNoCompany". Lets see what changes does it make to my report. The report looks much better now. The Header and the Footer of the template have been automatically designed to somewhat similar to standard Ax reports. Style Template: This can be found under p...

If we look at the Simple SSRS report we created using dataset CustTableSRS (use below internal link for more details), we observe that while rendering the report - we had to enter a value in the parameters tab. i.e, Value for CustGroup. So how and why does this value appear? How does this parameter appear: The answer can be found if we go to AOT in Dynamics Ax Client. Open the query CustTableSRS which we used as a Dataset for our report. In the CustTableSRS AxQuery , we find several nodes. Lets concentrate on the DataSources node. And in the Datasources node, we can find the CustTable from which the data into the report has be rendered from. And we can also see the Fields, AccountNum & CustGroup, which were displayed in the report. Now if you look at Ranges , we see that CustGroup lies here. That means, the query has a range and is defined by CustGroup. And this is how the CustGroup parameter is shown and is required while rendering the report. Why does the paramete...

This is an attempt to create the simplest SSRS report for Dynamics Ax. And to start with, lets see what all tools I am using. Microsoft Dynamics Ax 2012 R2 Visual studio 2010 Ultimate Visual studio tools (Dynamics Ax Component) Microsoft SQL 2008 R2 Steps to create the simplest SSRS Report: Launch Visual studio. Create a new project and select Template "Microsoft Dynamics Ax" and select Report Model. And in the Solution explorer, you will find a ReportModel. You will need to Add report, by clicking the Add button shown in the below image and then selecting Report. Then you will see a new report " Report1 " as shown. If you double click the Report1. Then you will see something like a part of AOT in Dynamics Ax as shown. The nodes available under the Report1 are Datasets, Desgins, Images, Data methods & Parameters. And for a simple SSRS report, our task will be to create something under the Datasets & Designs and then bind the two. Dataset - w...

In Dynamics Ax 2012, Microsoft SQL Server Reporting Services (SSRS) is the primary reporting platform. So all the default preconfigured reports that are shipped with Microsoft Dynamics Ax run on the Reporting services platform. And therefore, the below installations should be done perfectly: SQL Server Reporting Services (SSRS - Part of SQL Installation) Reporting Server extensions (Business Intelligence components of Microsoft Dynamics Ax) If your installation went wrong somewhere, then there is a chance that you might get the error: Only integrated security is supported for AX queries when trying to open an report in Ax 2012. Or you might see that the report will be opened, but you will be asked to enter the username and password to proceed further. Below is the related screenshot: Solution if error occurs for a single report: Identify the Report name Open Reporting Services Configuration Manager ( All Programs > Microsoft SQL Server 2008/2012 ...

If you are working with a Dynamics Ax 2012, you would need SQL 2008/2012 to have the database in it. And if you have a Development or a Test environment, you tend to put both SQL and Dynamics Ax in the same Machine. And that is when this post can help you. I have Dev machine in my local box along side Dynamics Ax 2012 and many other applications. And even though I am not using Major applications I see that the Memory usage of my box goes real high . And I understood that this is because of Microsoft SQL. Microsoft SQL tends to eat up as much as memory it can get whenever memory is free, and thereby, causing less memory for other applications when needed. Solution for that would be to limit the Memory usage of SQL to a certain amount based on your usage of SQL. I use SQL only to store Dynamics Ax 2012's data and the memory required for SQL to manage the transactions to and forth Dynamics Ax isn't much. So I limit the memory usage of SQL server to 1024 MB and thereby incre...

What are Integration ports?   Integrations ports are basically the inbound or outbound ports through which external applications can communicate with Dynamics AOS via AIF (WCF).   The exchange of data between External/Internal application is divided into: InBound Exchange  Both Basic and Enhanced Integration ports can be used. Basically to Receive data and create in Ax OutBound Exchange  Only Enhanced Integration ports can be used. To Send data to ext. applications To Send data to ext. applications in response to their Requests   How to: Create a Basic Inbound Integration Port [AX 2012]   Basic port is used to test the operation of a custom service that does not require any data processing or exposure to the Internet. Only a developer can create a new basic integration port    To create a basic inbound port Open the Application Object Tree (AOT). Right-click the Service Groups node, and then click New Serv...

When you create a page in Enterprise Portal, you will add it to the navigation to enable users to access it. This walkthrough demonstrates how to add the Tutorial_MessagePrompt page to the Quick Launch navigation for the Sales module site in Enterprise Portal. It illustrates the following tasks: 1.       Creating a Web Menu Item 2.      Modifying the Quick Launch Menu 3.      Viewing the Page in Enterprise Portal Prerequisites to complete this walkthrough: 1.       Microsoft Dynamics AX 2.      Enterprise Portal #1: Creating a Web Menu Item A web menu item points to a specific page in Enterprise Portal. You must create a web menu item for each page that you will be adding to the navigation. To create a web menu item: 1.       In the AOT, expand the Web node, and then expand the Web Menu Items node. 2.      Right-c...

In this example, the customer page in EP displays detailed information about a customer. The User Control displayed in a User Control web part is used to display the data on the page and the AxForm is the main component of the User Control used. A common customization is adding/changing the fields that are displayed in an entity overview page. This walkthrough demonstrates how to add a field to the first group that appears on the View customer entity overview page. The below figure illustrates the tasks be performed: Prerequisites: Basic prerequisites to be checked and available before proceeding for the walkthrough are: 1. Microsoft Dynamics AX 2. Enterprise portal 3. Visual Studio 2010 4. Visual Studio Tools installed (Ax Installation) 5. EP Administrator rights #1: Determining the User Control to Modify Before you can modify the fields displayed on the View customer page, you must determine which User Control is being used for that page. To determine the U...