In the previous article, I explained how to use D365 joins to combine rows from two ore more tables together. In a continuation of that article, learn how to use D365 outer join, exists join, and NotExists join to retrieve data in some more complex scenarios. Being able to efficiently pull in the exact data... Continue Reading →
D365 Joins in X++
Microsoft Dynamics 365 for Finance and Operations is a relationship database. This means there are many tables that contain data that relates to each other. D365 joins combine rows from two or more tables together, based on related columns. Developers use D365 joins in x++ select statements to read and update the data they are... Continue Reading →
How To Write A While Select Statement
Any ERP system needs to process data. An x++ 'while select statement' allows developers to loop through specific records with ease. Then take action on those records. The x++ language in Microsoft Dynamics 365 for Finance and Operations combines the best of both SQL like language and object oriented programming. First, developers can efficiently tell... Continue Reading →
How To Create A D365 Project In Visual Studio
Whenever a developer needs to add code in Microsoft Dynamics 365 for Finance and Operations, the first step is to create a project. In this article I wanted to explain the steps of how to create a D365 Project in Visual Studio. And some of the key pieces to be aware of. In the future... Continue Reading →