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

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

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…

Automatic role assignment and named user license count reports processing batch job

December 20, 2018 - 1:05 pm in Microsoft, Microsoft Dynamics AX 2012

Batch jobs are very useful to do recurring and back end jobs to achieve the requirements. Different batch jobs are written for different purposes. There are two standard Batch Jobs in Dynamics AX that are as follows: Automatic role assignment batch job -…

Get date in PowerApps

December 18, 2018 - 3:38 pm in Microsoft, Microsoft PowerApps

Microsoft PowerApps gives you many default function to fulfill the requirements. To get the today date in PowerApps is very easy. To do this, use the following function: Today() - It returns the current date & time. To format the date & time value…

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…