/ Category / Microsoft Dynamics 365 Finance & Operations

Get total debit and credit against voucher in x++

In Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012, it is really difficult to get total debit and credit against voucher of payment journal shown as follows: Total debit and credit against voucher Voucher debit and…

Custom number sequence in D365FO

What is number sequence? The number sequence is a series of numbers that are linked by a rule. It is very important for any ERP and business application.…

Get company logo in SSRS report

Company logo is an important part of the SSRS report. Many developers and customization consultant often get this task to show the company logo on the…

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 very important and significant feature. It helps the right users to get the right information about the business…

Format date using SSRS expression

A very common need is to format date using SSRS expression. I have formalized two expressions which helps you to meet a very basic requirement. It works for SSRS reports of Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012…

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 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…