/ Category / Microsoft Dynamics 365 Finance & Operations

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…

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…

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 add financial dimensions on form in D365FO

Default dimensions or financial dimensions is a very basic and important component of the Microsoft Dynamics ERP systems. Financial dimensions in Microsoft Dynamics 365 for Finance and Operations are very useful with respect to the business processes. In this…

Create form, automatic lookup and implement clicked() method of button in Microsoft Dynamics 365 for Finance & Operations

On a humble request of beginner developer of Microsoft Dynamics 365 for Finance & Operations, I have created this tutorial to create a new table, form and add lookup into them to select Sales Id and Customer Account. When OK button is clicked, the selected…

Writing data to TSV file using x++ in D365FO

Writing data from a program to a text file using any programming language is a very common task for the programmers. Writing data to text file using x++ is simple but logical. It is also used while you are customizing or developing a new solution in Microsoft…

Reading data from TSV file using x++ in D365FO

Sometimes, it is required to read the data from the text files to insert in to the system. Reading data from text file using x++ is simple to code but logical. I have created this job which reads the data from the TSV (tab-separated file) and prints it on…

Playing around with models in Microsoft Dynamics 365 Finance & Operations (D365FO)

Have you ever wonder that you can’t Import/Export/Delete Models in Microsoft Dynamics 365 Finance & Operations? The answer is that you can import, export and even delete models in Microsoft Dynamics 365 Finance & Operations (D365FO). But first understand…

Get financial dimension value by name using x++

To get financial dimension value by name using x++ in Microsoft Dynamics 365 for Finance and Operations or in Microsoft Dynamics AX 2012 is always difficult. This is a usual problem comes during the Microsoft Dynamics ERP customization or development. If you…

Calculate tax amount using x++

I was finding the solution to calculate the tax on the purchase order lines. And I was excited to share with you once I found out the solution and tested it in my scenario. One line code will calculate tax amount using x++ of the sales, purchase or any other…

How to start/stop report server service in D365FO & DAX2012?

It is very common question about restarting the report server service in D365FO & DAX2012. Many times it is required to refresh server and reflect your changes in SSRS reports and other changes related to report server service. I have created this tutorial…

Get on hand inventory (quantity) of an item using x++

To get on hand inventory (quantity) of an item using x++ in Microsoft Dynamics 365 for Finance and Operations or in Microsoft Dynamics AX 2012 is always a headache because there is no field in the table which gives the on hand inventory. So, to tackle…

Create default dimension using x++

Default dimensions are used very commonly in D365FO and DAX 2012. During development or customization of the system, it is very common that we often stuck at the time when we have to create default dimension using our own dimension values. To solve this problem,…

Create sales order using x++

Sales order can be created using X++ code. This helps you to create sales order using data from text files, excel sheets, databases and other data sources automatically. Following is the code to create sales order using x++ programming language: class Moeen_SalesOrder…

Creating your first model in D365FO

Microsoft Dynamics 365 Finance & Operations needs package, model and project to start development or customization. To learn that how does it start, I have created this tutorial. In this, you will learn how to create or use existing package, how to create…