How To Use A D365 Number Sequence
May23

How To Use A D365 Number Sequence

A D365 number sequence allows the system to generate a unique value. As well as use a defined format for the type of record being used. This is extremely helpful. There are sometimes, such as with item numbers, where you might have a specific value you use to already identify something. On the other hand,… Continue Reading → The post How To Use A D365 Number Sequence appeared first on

Read More
Create A D365 Development Environment
May09

Create A D365 Development Environment

In order to develop in Microsoft Dynamics 365 for Finance and Operations, you need a development environment. In this article, you will learn how to create a D365 development environment. Once this environment is setup, you can use it to perform testing of the system. As well as develop new functionality using Visual Studio. You… Continue Reading → The post Create A D365 Development… Continue Reading...

Read More
Segregation of Duties in D365FO
May03

Segregation of Duties in D365FO

I’ve referred to the Segregation of Duties (SOD) feature in Dynamics 365 for Finance & Operations before but haven’t really gotten into the specifics of the feature itself, what it allows you to do and the shortcomings/gaps. What is Segregation of Duties? The idea of Segregation of Duties (aka Separation of Duties) is that a single user should not be able to perform certain actions in a… Continue Reading...

Read More
How To Write A D365 Find Method
Apr25

How To Write A D365 Find Method

One of the most common tasks when writing code in Microsoft Dynamics 365 for Finance and Operations, is to retrieve a record from the database. Once you have the record, you can read, update, or delete it. In this article I will show you how to write a D365 find method. A ‘Find’ method makes… Continue Reading → The post How To Write A D365 Find Method appeared first on Dynamics 365… Continue Reading...

Read More
Customer advance and NTE
Apr22

Customer advance and NTE

 Customer advance created for GBP 12,000 but the NTE value on the project contract header is GBP 10,000. The customer advance invoice posted without any issues as NTE is not checked at advance level. The NTE values on the project contract are also unaltered. First project transaction of expense was posted for GBP 8,000, with a NTE check as “Success & Committed”. This transaction was successfully… Continue...

Read More
Document Attachment as Notes in D365FO
Apr22

Document Attachment as Notes in D365FO

I`ve already posted on exporting and importing attachments in D365 FO. There are various types of attachment available in FO . For instance, as File, image, Notes, URL etc. If you are importing the attachment as Notes, it can be handled in a simple way with the OOB entity . There is no need to export or import the package mentioned in earlier post which is suitable for Files and image… Continue Reading AnithaEswaran’s...

Read More
Creation of Credit Note in ProjOps
Apr21

Creation of Credit Note in ProjOps

 Once the invoice is “Confirmed” in ProjOps and project invoice proposal “Posted” in FinOps , user can create a credit note by clicking the “Correct invoice” button, which creates a negative invoice in ProjOps. Once the negative invoice is “Confirmed”, then system does NOT automatically create a negative project invoice proposal in FinOps. System gives this error: The user has to...

Read More
Insertar Power Apps en Dynamics 365 Finance and Operations
Apr20

Insertar Power Apps en Dynamics 365 Finance and Operations

Gracias a la Power Platform, se han multiplicado las opciones que tenemos para extender Dynamics 365 Finance and Operations sin necesidad de escribir código. En artículos anteriores vimos como podíamos aprovechar los flujos de Power Automate para ello, y en esta ocasión, nos vamos a centrar en las distintas formas que tenemos para insertar aplicaciones de lienzo de Power Apps dentro de… Continue Reading ja.tomas’s Article...

Read More
D365 Store Commerce performance test
Apr20

D365 Store Commerce performance test

Hi friends. A few weeks ago, Microsoft announced that the D365 Store Commerce App is now GA. The MPOS will enter “end-of-support” in release 10.0.33(Spring 2023) according to the following whitepaper. There are still features missing in Store Commerce, like dual display etc, but this will be added in later releases (10.0.28+). One of the … Continue reading D365 Store Commerce… Continue Reading Kurt...

Read More
How To Update Data In D365
Apr18

How To Update Data In D365

After users enter in data in Microsoft Dynamics 365 for Finance and Operations you often need to process the data. In this article you will learn how to update data in D365 using x++. There are several different ways to update data. And there are several important things you need to know in order to… Continue Reading → The post How To Update Data In D365 appeared first on Dynamics 365… Continue Reading...

Read More
D365: My take on the new Microsoft focus
Apr13

D365: My take on the new Microsoft focus

On the 6. April 2022 Microsoft had a launch event for Dynamics 365, where Charles Lamanna (Corporate Vice President, Business Applications & Platform) was the key speaker, and presented the latest wave of Dynamics 365. The main innovation theme was organized around 3 concepts; Data, AI and Collaboration. The main keynote states that Data is … Continue reading D365: My take on the new… Continue Reading Kurt...

Read More
How To Insert Data In D365
Apr11

How To Insert Data In D365

Of the of the most important things to know how to do in Microsoft Dynamics 365 for Finance and Operations is to work with data. In this article you will learn how to insert data in D365 using x++. There are several different ways to insert data. Therefore, understanding when to use each one is… Continue Reading → The post How To Insert Data In D365 appeared first on Dynamics 365 Musings. Continue Reading...

Read More
Part 4 – GitHub
Apr07

Part 4 – GitHub

Can you use Git Hub? yes. GitHub is also an option you could pursue when moving to Git. GitHub has a lot of new features and offerings that Azure DevOps does not have. However, there is basically no documentation from MSFT on how to configure builds and various other automation options in GitHub. I’m sure it’s possible but there will be a fair amount of guess work. Getting your pipelines fully… Continue Reading...

Read More
Part 3 – Developing with VS 2019 / 2022
Apr07

Part 3 – Developing with VS 2019 / 2022

What’s it like developing using Git? Developing in VS with Git is easy but I wanted to call out a few changes. First, you don’t need to manually add items to your repo. Your repo will have a .gitingore file that says what can be committed – and what can’t. If your .gitIgnore file doesn’t specifically ignore it, it will automatically be added. Also, your project folder will need to be in the…...

Read More
D365 : A messy tips blogpost
Apr06

D365 : A messy tips blogpost

Hi friends. We learn new things every day, and I wanted to share a new messy blogpost where you will find undocumented some tips. Enjoy. Azure Zone Pinning Sometimes I have experienced that Dynamics 365 performs slower than expected. I have in a few scenarios tracked this down the fact that the services are distributed … Continue reading D365 : A messy tips blogpost Continue Reading Kurt Hatlevik’s Article on their...

Read More
How To Use The D365 Table Browser
Apr04

How To Use The D365 Table Browser

There exist many forms to show the user data in Microsoft Dynamics 365 for Finance and Operations. However, sometimes it is very useful to look at all of the unfiltered data in a specific table. In this article, you will learn the multiple ways to use the D365 table browser. There have been many articles… Continue Reading → The post How To Use The D365 Table Browser appeared first on

Read More
Part 2 – Lifecycle of a Branch
Apr04

Part 2 – Lifecycle of a Branch

Let’s take a look at the lifecyle of a Git Branch. Unlike TFVC, branches in Git are typically short lived when it comes to development. In TFVC you may have a branch for each developer or a branch for development in general, another for test then a release branch. In Git, we will be using branches differently. We’ll get a change request as a work item in DevOps, review it, create a branch,… Continue Reading Nathan...

Read More
Part 1 – Package Management
Apr03

Part 1 – Package Management

How Shoud I Manage Packages in Git? There are 2 options when looking at Git for managing your X++ code. The main driver for which option you select is if you will only ever have 1 package in your code base or more than 1. This include any ISVs or any other item that will have a code footprint anywhere in F&O. To learn more about packages, please see 

Read More
Using Git with 1 Package
Apr01

Using Git with 1 Package

Submitted by Nathan Clouse on 04/01/22. Using Git with 1 Package When using Git for F&O, there are 2 basic flavors of using it; with 1 package or more than 1 package. This post will cover how to setup Git for use with 1 package. To learn out to create a Git repo in Azure DevOps, please refer to MSFT documentation. To learn how to create a repo on Github, please refer to GitHub… Continue Reading Nathan Clouse’s Article...

Read More
GIT ALM Field Guide
Apr01

GIT ALM Field Guide

Using Git rather than TFVC, a field guide. This collection of works will help you with moving from using TFVC to using Git for your x++ development. This page will have several chapters linked as they are published. However, how do you know which is the best fit for you, your team, your organization or your project? Let’s take an inventory. You If you’re reading this, I assume you’re… Continue Reading Nathan...

Read More
Using Git with More than 1 Package
Mar26

Using Git with More than 1 Package

Submitted by Nathan Clouse on 03/25/22. Tags:  Git Source Control Want to use Git with more than 1 Package? Let’s review. The process to get Git working with F&O can be a little involved and it may not make sense the first time. The issue we’re presented with is that Git assumes you are starting with nothing – a… Continue Reading Nathan Clouse’s Article on their blog Using Git with More than 1...

Read More
Select FirstOnly vs Select FirstOnly ForceSelectOrder ForceNestedLoop
Mar16

Select FirstOnly vs Select FirstOnly ForceSelectOrder ForceNestedLoop

Submitted by Nathan Clouse on 03/15/22. Tags:  forceselectorder forcenestedloop Let’s explore what keywords forceSelectOrder and ForceNestedLoop do. Introduction The database access layer in X++ largely conceals it magic from us as developers and we hope it gets the SQL right – and it does. SQL is largely 99.9%… Continue Reading Nathan Clouse’s Article on their blog Select FirstOnly vs Select FirstOnly...

Read More
D365 Development Tips And Tricks
Mar14

D365 Development Tips And Tricks

Do you know all of the D365 development tips and tricks when working with Microsoft Dynamics 365 for Finance and Operations? Find out by watching this video. Two time Microsoft Business Applications MVP Nathan Clouse invited me to co-present with him. And I was honored and thrilled to be asked. Watch as we show you… Continue Reading → The post D365 Development Tips And Tricks appeared first… Continue Reading...

Read More
Power Automate to trigger the post alert in LinkedIn
Mar10

Power Automate to trigger the post alert in LinkedIn

Everytime when I add a new post to my blog, I manually update my LinkedIn Account about it. With PowerAutomate, this job is automated with two simple steps, If you have a Office365 account, login and then search for either Flow or Automate in the Search bar. Click on Create New flow and Search for ‘WordPress’ Connector. Since I am using wordpress , this connector is configure… Continue Reading AnithaEswaran’s...

Read More
Access D365FO pages from Microsoft Teams
Mar10

Access D365FO pages from Microsoft Teams

It is now possible to access the FO pages from Microsoft teams. We can simultaneously chat and get the doubts cleared if any . Select the form which needs to be embedded in the teams. Copy the URL from address bar. If you need to limit the navigation, I`ve explained it here . Now , Go to teams and click on + icon as displayed below. Search for website Follow the… Continue Reading AnithaEswaran’s Article on their blog...

Read More
Project Contract – Before and after confirmation
Mar10

Project Contract – Before and after confirmation

Scenario 1 – Change of cost and sales price before confirmation of project contract  Before project contract confirmation, the time transaction has following actuals transactions: The cost and sales price are updated and the project contract is “Confirmed”. This is the message which system gives. Highlighted part is important. After project contract confirmation, the time transaction has… Continue Reading...

Read More
Limit the navigation in D365FO
Mar10

Limit the navigation in D365FO

How do we limit the navigation options to the users ? For instance, I am asked to share only the Vendor form to a particular user . If the complete URL is shared, then the user will be able to navigate to all the menus. In order to handle this, there is no additional development needed. Add another parameter in the URL to limit the navigation

Read More
Straight Line Rev Rec – Observation with respect to dimensions on individual milestones (On-account)
Mar04

Straight Line Rev Rec – Observation with respect to dimensions on individual milestones (On-account)

If there are two on-account (milestones) lines on the Straight Line Rev Rec project, with different dimensions, other than the one on the project, for example as below, then rev-rec line ignores the dimensions on the lines and inherits the dimensions from the project. If the project has no dimensions, then the rev-rec line also will inherit no dimensions, even if there are dimensions on the… Continue Reading noreply@blogger.com...

Read More
Invoice, Invoice in Advance and Invoice in Arrears – T&M
Mar04

Invoice, Invoice in Advance and Invoice in Arrears – T&M

  Scenario 1 – Rev rec at Invoicing Fee Journal DR Project WIP Sale Value (B/S) – 1000                              CR Project Accrued Revenue – Sale value (P&L) – 1000               Expense Journal – Consumption...

Read More
Presenting at Upcoming Microsoft Dynamics Conferences
Mar01

Presenting at Upcoming Microsoft Dynamics Conferences

DynamicsCon (virtual) When: March 15 – 17th 2022 Price: Free Register Here Session Information: Common D365FO Mistakes and How to Avoid Them I am co-presenting this session with another Microsoft MVP Andre Arnaud de Calavon. In this session, we will demonstrate real-world common D365FO security mistakes that customers make, discuss why these actions can introduce risk into your organization,… Continue Reading Alex’s...

Read More
D365 Outer Join In X++
Feb28

D365 Outer Join In X++

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 → The post D365 Outer Join In X++ appeared first on Dynamics 365… Continue Reading...

Read More
Changing the Bill Type – D365 Project Operations
Feb24

Changing the Bill Type – D365 Project Operations

  Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on their blog Changing the Bill Type – D365 Project Operations Changing the Bill Type – D365 Project Operations Blog Syndicated with noreply@blogger.com (Sarang Kusare)’s...

Read More
Comparing D365FO Security Between Versions
Feb22

Comparing D365FO Security Between Versions

A frequent request I get is with OneVersion updates in D365FO, how do we as end users know what security changes are occurring between D365FO versions? A fellow Microsoft MVP, Nathan Clouse, reached out to me asking about wanting to add the same information to his dynamics.fo website. He has dedicated this site to show changes that are occuring between D365FO versions. We decided to… Continue Reading Alex’s Article on...

Read More
D365 Joins in X++
Feb21

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 → The post D365 Joins in X++ appeared first on

Read More
Lead to Project journey – Project Operations
Feb21

Lead to Project journey – Project Operations

  Continue Reading noreply@blogger.com (Sarang Kusare)’s Article on their blog Lead to Project journey – Project Operations No Description Blog Syndicated with noreply@blogger.com (Sarang Kusare)’s...

Read More
Using Notepad++ for easy formatting
Feb15

Using Notepad++ for easy formatting

We often use Notepad++ for easy editing which allows us to open multiples file simultaneously. It also helps a developer to edit the code as it recognizes popular coding languages. As a developer, I found it useful not only for the purposes listed above but also in formatting the SQL query values as per the needed format. During Unit testing phase, developers often swap between FO and… Continue Reading AnithaEswaran’s...

Read More
How To Write A While Select Statement
Feb14

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 → The post How To Write… Continue...

Read More
D365FO Business Event with Https Endpoint
Feb11

D365FO Business Event with Https Endpoint

With the latest FO versions, Business event endpoints doesn`t support ‘Power Automate’ and ‘CDS’. One of my projects had the Business event integration with logic apps and we used ‘Power automate’ to create the endpoint. In this post, let me give a walk through of setting up ‘Https’ as endpoint in D365FO Business Events. To understand the set up of BE, please refer my post , post2...

Read More
Azure API Management for Dynamics 365 F&O
Feb09

Azure API Management for Dynamics 365 F&O

In today’s post, I want to talk about using Azure API Management (APIM) along Dynamics 365 Finance and Operations. Azure API Management is a hybrid, multi-cloud management platform for APIs across all environments. This means that, after deploying an APIM account, you can create an API that can serve services from one system or multiple. […] ariste.info Azure API Management for Dynamics 365… Continue Reading Adrià...

Read More
Using ATL to Create Data to Model Data Volume Testing
Feb09

Using ATL to Create Data to Model Data Volume Testing

Submitted by Nathan Clouse on 02/08/22. What can we do with ATL to create some transactions? Let’s take a look. After this post, I wanted to manufacture some data to better show that adding computed fields adds overhead for every operation within a data entity. That post somewhat showed it but I wanted something more cut and dry. I thought a good way to manufacture data in a Contoso… Continue Reading Nathan Clouse’s...

Read More
How To Create A D365 Project In Visual Studio
Feb07

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 → The post How To Create A D365 Project In Visual Studio appeared first on Dynamics 365… Continue Reading...

Read More
Part 17 – Over Using Computed Fields
Feb07

Part 17 – Over Using Computed Fields

What happens when you add lots of computed fields to a data entity? Let’s take a look In part 16, we talked about using computed columns. Next, let’s take this to next logical conclusion – using them way too much. We’re going to compare 4 different scenarios from a performance perspective when working with customers. We’ll have the following data entities: CustCustomerV2Entity – we’ll...

Read More
My take on the X++ custom scripts feature
Feb03

My take on the X++ custom scripts feature

So three days ago I took a look at the new 10.0.25 features currently in the PEAP program, calmly scrolling through until I saw something about custom scripts on prod, something that read: Run custom X++ scripts with zero downtime You can imagine my face when I read this. At the beginning I was confused, […] ariste.info My take on the X++ custom scripts feature Continue Reading Adrià Ariste Santacreu’s Article on their...

Read More
Logic apps DIXF Export – Unique file name creation – D365FO
Feb02

Logic apps DIXF Export – Unique file name creation – D365FO

Triggering ‘Export to package’ API from logic apps creates the output as a data package. The data package has Data file, Manifest and Package Header . In order to pass the data file for third party processing , the compressed package has to be extracted. In such case, then the file name can cause an issue. As we are aware, name of the data file in the package is same as the entity name (which… Continue Reading...

Read More
How to Use Temp Tables as Grid Datasources for Data Analytics in D365FO
Feb01

How to Use Temp Tables as Grid Datasources for Data Analytics in D365FO

I was recently asked to find a way to perform some simple data analytics across some data within D365FO. In my case, this was audit data that could easily be millions of records so just exporting to an Excel file to do this was not really an option. Instead I wanted to build a simple form that would perform the analysis for me. Note: This could also be done very easily within a full data… Continue Reading Alex’s Article on...

Read More
How To Write An X++ Select Statement
Jan31

How To Write An X++ Select Statement

One of the coolest parts of the x++ language is using a select statement. A select statement allows developers to fetch and manipulate data from a database. The data is loaded into table variables. Finally, these table variables can have methods where code be added to work with the data. This allows developers to focus… Continue Reading → The post How To Write An X++ Select Statement… Continue Reading...

Read More
D365: 2022Wave1 – Unified pricing service
Jan26

D365: 2022Wave1 – Unified pricing service

I have had the chance to look deep into the 2022 release wave 1 plans. There are tons of goodies, and we again see the direction where things are going. There is a lot of investments in the microservices area, and we see the platform opening up like a blooming flower. There is one specific … Continue reading D365: 2022Wave1 – Unified pricing service Continue Reading Kurt Hatlevik’s Article on their blog D365:...

Read More
OData Throttling D365FO : “The request could not be processed at this time due to system experiencing high resource utilization”
Jan19

OData Throttling D365FO : “The request could not be processed at this time due to system experiencing high resource utilization”

Recently during the import of data using OData , I had encountered this error which status ‘The request could not be processed at this time due to system experiencing high resource utilization”. I had not faced this issue in dev machines (tier-1), but this occurred in Tier-2 . Microsoft has already given a work around for this issue. But before jumping on to the solution , let me… Continue Reading...

Read More
D365; 4 Lines to scroll at a time
Jan16

D365; 4 Lines to scroll at a time

Here is very small tip. Set your windows mouse line scrolling to 4 lines when using Dynamics 365. When you then scroll in D365 lookups, one scroll-click is then jumping one page down in the lookups (in my case). #LifeHack Continue Reading Kurt Hatlevik’s Article on their blog D365; 4 Lines to scroll at a time Here is very small tip. Set your windows mouse line scrolling to 4 lines when using Dynamics 365. When you then scroll in...

Read More
Create A D365 Batch Job
Jan10

Create A D365 Batch Job

Do you have a process that you need to run in the background of Microsoft Dynamics 365 F&SC? There are two ways to create a D365 batch job. The newer way is to use SysOperation Framework in D365. However, the older way is still very much supported and used within the system. Therefore, it is… Continue Reading → The post Create A D365 Batch Job appeared first on Dynamics 365 Musings. Continue Reading...

Read More