Running an SSRS report from the selected record

SSRS reports are used to display data in an organized way. It helps the users to get the data as per their own business formats and scenarios. In Microsoft Dynamics 365 for Finance and Operations or in Microsoft Dynamics AX 2012, SSRS reports play a vital…

Create SSRS report in D365FO

Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012 uses the SSRS reports for the business reporting purposes. It is a…

Format date using SSRS expression

A very common need is to format date using the SSRS expression. I have formalized two expressions which helps you to meet a very basic requirement. It…

Get company address using x++ in D365FO

To get company address using x++ is a two line solution. I have seen many times that developers/consultants are confused about how to get the value. Below is the picture in which I have high-lightened the field which we will get using the code. Figure 1. Company…

Get Display Value from Ledger Dimension in D365FO

Ledger Dimension in Microsoft Dynamics 365 for Finance and Operations or in Microsoft Dynamics AX 2012 contains very important information. Actually, ledger dimension is just a number without any information. But, to get display value from ledger dimension…

Get Main Account from Ledger Dimension in D365FO

Dimensions in Microsoft Dynamics 365 for Finance and Operations or in Microsoft Dynamics AX 2012 are always have a very important role. Playing with dimensions is always a hectic thing. To get main account from ledger dimension in D365FO is a very common requirement.…

Customize SSRS report using extension in D365FO

I was fulfilling the requirement to customize SSRS report using extension in D365FO. Extending the data set and customizing the design using extension approach in D365FO is difficult but a journey full of learning. Previously, in Microsoft Dynamics AX 2012,…

Apply platform update to D365FO VM

Few days ago, I have updated two local development environments (VMs) that are not connected to LCS. I have decided to share the knowledge with my community members. So, to apply platform update to D365FO VM, follow my this tutorial. The table below shows…

Can’t stop DynamicsAXBatch service error

In this article, I will explain you how to resolve the can't stop DynamicsAXBatch service error. While registering yourself through admin provisioning tool or stopping the service from Services. This article helps you to solve the problem within no time. Admin…

Convert date and time to utcDateTime using X++

Working with date and time is a common task while working with data and tables in Microsoft Dynamics 365 for Finance and Operations and in Microsoft Dynamics AX 2012. If you want to convert date and time to utcDateTime using X++, and both date and time are…

Databases in D365FO

Database for any Enterprise Resource Planning (ERP) system is essential to store and retrieve the data. In Microsoft ERP systems, multiple databases are used to do multiple and different tasks. They are very large and complex to understand. We often use them…

How to sort data on grid of form in D365FO using X++

Sorting data on grid of form in Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012 can be done through the form. But every time you have to do it whenever you will open the form. To sort the data on grid of form in D365FO whenever…

How to sort data on grid of form in AX 2012

March 12, 2019 - 11:26 am in Microsoft, Microsoft Dynamics AX 2012

In Microsoft Dynamics AX 2012 and Microsoft Dynamics 365 for Finance and Operations, grids are used very often on the form. If you want to sort data on grid of form in AX 2012 by ascending or descending orders. You are at the right place to learn. The requirement…

How to create lookup in form data source field in D365FO

Creating lookup on form is very common requirement for a better user experience. In this blog post, I will discuss about how to create lookup in form data source field using in D365FO. I will create this using extension approach in Microsoft Dynamics 365 for…

What is RecId in Microsoft Dynamics AX/365FO

Tables are very important component of Microsoft Dynamics ERP systems. In these tables, the data is stored, later on processed and information is fetched. If you open the table in Table Browser or in Microsoft SQL Server, you may have seen the RecId field…

Get the last inserted record from table using x++

In Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012, if you want to get the last inserted record form table using X++. You need to order the records as descending by RecId. RecId is the unique value stored with every row in…

Get name and personnel number of user using x++

I have shared the code to get the current user id using x++ which is only one-line code. In this blog post, I have written the code to get the name and personnel number of worker from user id using x++. I have used the user id which is current. And, the current…

Get current user id using x++

I have been answering the questions on the Microsoft Community to the questioner, I have thought to share this one line code on my blog to get current user id using x++ in Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012. I…

How to create lookup in D365FO using X++

Lookup makes the data entry for the users easy and error-less. I have already shared the video in which I have described about how to create lookup in Microsoft Dynamics 365 for Finance and Operations automatically, but in today's article I will discuss about…

How to insert data into table of AX 2012 from Enterprise Portal

February 4, 2019 - 2:52 pm in Microsoft, Microsoft Dynamics AX 2012

Few days ago, I came across a requirement to insert data into the table of AX 2012 from Enterprise Portal. I had talked to the community members, searched from the internet and read different blogs, but, I didn't get the code for this very basic requirement.…