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
Voting Now Open for DynamicsCon 2022 Sessions
Jan10

Voting Now Open for DynamicsCon 2022 Sessions

Voting has now opened for DynamicsCon 2022 sessions! I have submitted two different sessions and there are many more great sessions to check out and vote for! Be sure to get your votes in before January 19th 2022! Successfully Navigate D365FO User Licensing Do you find user licensing in D365FO confusing? Do you second guess the number and type of licenses you need? Are you worried you are… Continue Reading Alex’s Article...

Read More
How to Create Your Own Dynamics 365 Sales Demo
Jan07

How to Create Your Own Dynamics 365 Sales Demo

How to Create Your Own Dynamics 365 Sales Demo How to Create Your Own Dynamics 365 Sales Demo Try a… Continue Reading Gordon Schrenk’s Article on their blog Create Your Own Dynamics 365 Sales CRM Demo See the CRM capabilities that Microsoft has to offer. Follow the instructions below to try out Dynamics 365 Sales today! Blog Syndicated with Gordon Schrenk’s...

Read More
D365 – 252 Solution Blueprint review questions
Jan06

D365 – 252 Solution Blueprint review questions

One of the most important aspects of Success By Design program is to ensure quality in the implementation process and to set the right expectations. One important setup in this process is the Microsoft Solution Blueprint Review workshop that can be offered to customers through extended FastTrack Engagement. The Solution Blueprint Review workshop covers the … Continue reading D365 – 252… Continue Reading Kurt...

Read More
D365 Hidden Sales order gem; copy from item list
Jan05

D365 Hidden Sales order gem; copy from item list

A small but highly productive tip is the feature of “Item list”. It has been available for years but have not gotten the deserved attention. The feature does not even have a docs page. With this feature it makes it much easier to create sales order, by copying the lines from an ‘item list’. The … Continue reading D365 Hidden Sales order gem; copy from item list Continue Reading Kurt Hatlevik’s...

Read More
Automated Solution to Find Table Relations in AX 2012 and D365FO
Jan04

Automated Solution to Find Table Relations in AX 2012 and D365FO

Problem For anyone that has dealt with creating queries in AX 2012 and D365FO, you know it can be extremely difficult to determine possible table relations between tables. To help with this Microsoft released an ERD for AX 2012 (this can still be used for D365FO), unfortunately they no longer maintain this project but do allow for others to host it themselves. This ERD helps to show the… Continue Reading Alex’s Article on...

Read More
Delete Duplicate or Top row from SQL server
Jan04

Delete Duplicate or Top row from SQL server

In order to delete a particular record from a table in SQL server, a normal delete statement would not be helpful For instance, take an example as shown in the below screenshot Due to manual error, there are duplicate records in the field ‘Country_region’. (Of course, this would not have occurred if index was defined. I am using this example for our demo so that we can apply my… Continue Reading AnithaEswaran’s...

Read More
Create Security In D365
Jan03

Create Security In D365

Developers often forget to add security in D365. After developing a new form, report, or batch job in Microsoft Dynamics 365 for Finance and Operations, you need to create Menu Items so a user can see and run the new functionality. And those Menu Items need to be added to new or existing Security objects,… Continue Reading → The post Create Security In D365 appeared first on Dynamics 365… Continue Reading...

Read More
Single-Line string to Multi-line – Postman
Jan02

Single-Line string to Multi-line – Postman

There are scenarios when a single string separated by commas(or any other character) to be imported as multi line string to the target application . One of my assignment had unformatted data and the requirement was to map them to the FO fields . One such field is Address Street and thus needed transformation before import. My next post will show how this transformation is handled using ADF …. Continue Reading...

Read More
Connect to Azure SQL from logic apps to execute D365FO Enqueue
Jan02

Connect to Azure SQL from logic apps to execute D365FO Enqueue

In one of my assignments, I am using Azure SQL database acting as staging where I am importing the data on to it for further transformations. In order to push the data to D365 FO using recurrence, I used logic apps to establish connection to the azure db . Given below the steps Create a logic apps and select ‘SQL Server’ connector. On clicking, there will be list of actions displayed… Continue Reading...

Read More
test
Jan01

test

test Module:  3rd Party Solution Enabled By Default: On By Default Continue Reading Nathan Clouse’s Article on their blog test test Blog Syndicated with Nathan Clouse’s...

Read More
Dynamics 365 – top things to learn and tools to use in 2022
Jan01

Dynamics 365 – top things to learn and tools to use in 2022

I first want to thank the 92.898 visitors to my blog in 2021. It has been my pleasure to share with the community, and 2021 have been the best so far. This time, I would like to summarize my tips on what to learn and tools to use that can further bring value to our … Continue reading Dynamics 365 – top things to learn and tools to use in 2022 Continue Reading Kurt Hatlevik’s Article on their blog Dynamics 365 –...

Read More
Get Custom D365FO Objects at Runtime Using X++
Dec21

Get Custom D365FO Objects at Runtime Using X++

A while back, I asked a question on the D365FO forums about being able to generate a list of custom objects within an environment at runtime via X++. I never followed up on my answer there so I wanted to give a detailed response to how I ended up solving this. Before We Begin In the discussion on my initial question post it was brought up that you should be using a source control system (TFS,… Continue Reading Alex’s...

Read More
Diagrams.net
Dec16

Diagrams.net

Most of us in the field have traditionally used Microsoft Visio to show architecture, processes and systems. But there is an alternative that I would recommend to the community: https://www.diagrams.net/ This is a free, online and easy to use tool to quickly represent graphics related to what you want to show. Give it a try, … Continue reading Diagrams.net Continue Reading Kurt Hatlevik’s Article on their blog Diagrams.net...

Read More
Use Workflow, Automation, and Templates to Streamline Operations with CRM
Dec15

Use Workflow, Automation, and Templates to Streamline Operations with CRM

Use Workflow, Automation, and Templates to Streamline Operations with CRM Use Workflow, Automation, and Templates to Streamline Operations with CRM

Read More
Restoring Deleted Security in D365FO
Dec15

Restoring Deleted Security in D365FO

Recently ran into an interesting scenario where an end user deleted a security layer from the user interface and wanted to restore it. This security layer was an out of box security layer so it existed in the AOT. Here is the process on how to perform this task. Note: The following process only works in the scenario that the security layer exists in the AOT and you remove it from the user… Continue Reading Alex’s Article...

Read More
New features for Dynamics 365 in 2021: my year-in-review
Dec15

New features for Dynamics 365 in 2021: my year-in-review

The year 2021 has almost come to an end, and it’s time to review the changes we’ve had this past year. So in case you’ve missed something, I hope you can find it here, although I won’t include all new or changed Dynamics 365 Finance & Operations features, only some of them, the ones I’ve […] ariste.info New features for Dynamics 365 in 2021: my year-in-review Continue Reading Adrià Ariste...

Read More
Change Security In D365
Dec13

Change Security In D365

Microsoft Dynamics 365 for Finance and Operations has existing Roles set up. These roles are associated with Users and provide access to the Menu Items. The Menu Items allow users to run forms, reports, and batch jobs. There are times when you need to change Security In D365. Perhaps you need one Role to have… Continue Reading → The post Change Security In D365 appeared first on Dynamics 365… Continue Reading...

Read More
Getting ready for the next Azure DevOps pipeline agent update
Dec10

Getting ready for the next Azure DevOps pipeline agent update

Context Maybe you have noticed the following warning message related to a brownout that will take place on December, 15, starting from the next week for 1h30 min in Azure DevOps while using hosted azure pipelines agent. A brownout will take place on December, 15 3:00 PM – 4:30 PM UTC to raise awareness of the upcoming windows-2016 environment removal here is how to handle… Continue Reading adalhix’s Article on their...

Read More
Determine Where Form Data is Stored in D365FO
Dec08

Determine Where Form Data is Stored in D365FO

There are many scenarios in D365FO where knowing where data on a form is coming from is needed. A couple scenarios include trying to write custom reports or for tracking data changes using something like the Fastpath Audit Trail tool. There are a couple different options on how to accomplish this so I wanted to walk through them. I’ve written about a similar topic to this in the past, but… Continue Reading Alex’s...

Read More
Customize Security In D365
Dec06

Customize Security In D365

In this article I will teach you how to customize security in D365 using the Security Configuration form. How to add new Roles, and add Menu Items to them. In the last article, titled ‘Security in D365‘, I explained how to setup a D365 User, and add Roles to that User. Additionally, you learned how… Continue Reading → The post Customize Security In D365 appeared first on Dynamics 365… Continue Reading...

Read More
Convert Power Apps Portal Into A  Progressive Web Apps (PWA) : Introduction & Demo
Dec03

Convert Power Apps Portal Into A Progressive Web Apps (PWA) : Introduction & Demo

What is Progressive Web App (PWA) ? PWA is a web app that is optimized to run “like an app” on a mobile device .They look & feel like a Native App and also appear to be a like a native app that you would install from your device’s app store, but actually work within … Continue reading Convert Power Apps Portal Into A Progressive Web Apps (PWA) : Introduction & Demo → The post Convert… Continue Reading...

Read More
Combine & Merging images to a single image using X++ & C# Dot Net Libraries
Dec01

Combine & Merging images to a single image using X++ & C# Dot Net Libraries

Requirement – The requirement is to combine and merging images to a single image using X++ & C# Dot Net Libraries in Microsoft Dynamics 365 finance and operation. Classes & Libraries – System.Drawing.BitmapSystem.Drawing.ImageSystem.Drawing.GraphicsSystem.Drawing.Imaging.ImageFormatSystem.Drawing.Color Sample Code – The post Combine & Merging images to a single image using X++ & C# Dot Net…...

Read More
Part 18 – Order Of Operations for Data Entities
Dec01

Part 18 – Order Of Operations for Data Entities

Let’s explore the order of operations when using a data entity. When creating a solution that may use a data entity, OData or not, it may be helpful to understand the precise order of operations for what gets called when in the call stack. Also, when extending OOTB data entities, what changes you are going to make may have changes to the overall performance of the data entity depending on… Continue Reading Nathan...

Read More
Free Access To Microsoft Office 365 (Create Microsoft Education Account & Office 365 A1 for faculty trial)
Nov30

Free Access To Microsoft Office 365 (Create Microsoft Education Account & Office 365 A1 for faculty trial)

In this post I will show you how you can create a free Microsoft education account & get free access to Microsoft office 365 (Office 365 A1 for faculty trial). After creating the free Microsoft office 365 account (Office 365 A1 for faculty trial) , you can access various online apps (like outlook, word, excel, … Continue reading Free Access To Microsoft Office 365 (Create Microsoft Education… Continue Reading Piyush...

Read More
Security In D365
Nov29

Security In D365

In this article, I will explain how to use role based security in D365. This is a complicated topic. Before learning how to customize the security, it is important to know how to provide access to users using the existing functionality. In the next article, I will teach you how to customize security in D365… Continue Reading → The post Security In D365 appeared first on Dynamics 365… Continue Reading...

Read More
Get Free Access To A Microsoft Dynamics 365 FO Development & Training environment
Nov28

Get Free Access To A Microsoft Dynamics 365 FO Development & Training environment

Get Free Access To A Microsoft Dynamics 365 FO Development & Training environment The post Get Free Access To A Microsoft Dynamics 365 FO Development & Training environment appeared first on All About Microsoft Dynamics. Continue Reading Piyush Adhikari’s Article on their blog Get Free Access To A Microsoft Dynamics 365 FO Development & Training environment – All About Microsoft Dynamics Get Free Access To A...

Read More
D365 FO : Developing Business Events with X++ from scratch
Nov27

D365 FO : Developing Business Events with X++ from scratch

Business events provide a mechanism that allow external system receives notifications from Microsoft Dynamics 365 Finance and operations. For example – When you are posting a purchase invoice then you can send notifications/ payload / message to an external system. You can use existing standard business events which are available in the D365 FO or … Continue reading D365 FO : Developing… Continue Reading Piyush...

Read More