/ Category / Microsoft

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

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

Workflow Due Date Time Exceeded Error

January 27, 2019 - 12:41 am in Microsoft, Microsoft Dynamics AX 2012

In AX 2012, when we run Tutorial_WorkflowProcessor form, a list of errors start coming on infolog about workflows. Often, these errors can be summarized as workflow due date time exceeded error. These errors are as follows: SysWorkflowWorkItem-escalate WorkflowTrackingTable-saveTracking…

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…

Add personnel number of worker in person lookup of user worker relation form in Microsoft Dynamics AX 2012

January 10, 2019 - 2:23 pm in Microsoft, Microsoft Dynamics AX 2012

A lookup is very essential to find out the value of the list so quickly and select it. There are many lookup we see in Microsoft Dynamics AX or in Microsoft Dynamics 365 for Finance & Operations. The lookup is very useful while we are filling the form…

Solution of CTRL+F5 error in General Ledger module in Microsoft Dynamics AX 2012

January 10, 2019 - 12:27 pm in Microsoft, Microsoft Dynamics AX 2012

 Sometimes while entering the data and creating journals, orders and invoices etc. in Microsoft Dynamics AX 2012, the user gets irritated if errors come up again and again. One of the example of such problem is the error which occur when modifying the…

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…

How to execute same report but different designs from different menu items?

January 3, 2019 - 5:31 pm in Microsoft, Microsoft Dynamics AX 2012

A very common requirement of SSRS reports are that sometimes two or more reports are same but their designs are slightly different. Or you don't want to customize the default report, but to develop same as the default report with slightly difference in the…

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…

Cascading drop down controls in Microsoft PowerApps integrated with Microsoft SharePoint Online

December 24, 2018 - 3:01 pm in Microsoft, Microsoft PowerApps, Microsoft SharePoint

A cascading drop down list/lookup is a series of dependent drop down controls in which one drop down control depends on the parent or previous drop down controls. The items in the drop down control are populated or filtered based on an item that is…

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…