Remove CR LF from Notepad++
In case if you wanted to remove these characters CR LF from your Notepad++ file, Below the file menu, unselect the ‘Show all characters’ option. Continue Reading AnithaEswaran’s Article on their blog Remove CR LF from Notepad++ In case if you wanted to remove these characters CR LF from your Notepad++ file, Below the file menu, unselect the ‘Show all characters’ option. Blog Syndicated with...
Currency and Exchange rates in ProjOps and FinOps
Currency on the Project record There are 3 currencies in FinOps:Transaction currency – In which transaction happensAccounting currency – In which the company accounts (configured in the Ledger under Accounting currency)Reporting currency – In which the company reports (configured in the Ledger under Reporting currency)There are 3 currencies in ProjOps as well, but shown differently in the… Continue Reading...
There is already an object named ‘LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2’ in the database
I encountered the error when a new VM with 10.0.39 was deployed and trying to sync the database. Execute this below command in SQL and try the sync again. DROP PROCEDURE IF EXISTS LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2 GO Continue Reading AnithaEswaran’s Article on their blog There is already an object named ‘LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2’ in the database I encountered the error when a new VM with...
ISVLicenseGenerator v0.9: a farewell?
I’ve been working on the ISVLicenseGenerator open source tool for some years now, almost five. It all started when I ordered a code-signing certificate to sign ISV solutions, and I got a USB token instead of a software certificate. After many years of Microsoft not offering support for these devices to sign the license files,… Click here to continue reading ISVLicenseGenerator v0.9: a… Continue Reading Adrià Ariste...
Preparing for the Transition to Power Platform Admin Center (PPAC)
A Unified Future for Admin and Dev Experiences It’s clear the deprecation of Lifecycle Services (LCS) has started as seen in the “LCS System Diagnostics being retired in September 2024 notification message”. Microsoft is removing features from LCS as part of the transition to the Power Platform Admin Center (PPAC). This is a big signal for organizations to start preparing for the… Continue Reading adalhix’s Article on...
Database Inserts – Code Data Entity Comparison
Submitted by Nathan Clouse on 09/15/24.Last modified: 09/15/24 Reading this article is a good place to start as we continue testing but with data entities for the same table. We review performance from a Microsoft-hosted Sandbox environment as well a (new) PPAC-hosted Unified Development Environment, or UDE, which used to be known as a UNO environment – Unified Operations. In the charts… Continue Reading Nathan...
New field in SSRS Temp table not reflecting the data – D365FO
Since D365FO is highly customizable, customers frequently request the addition of new fields in reports. However, this can sometimes become cumbersome or challenging when a straightforward extension of the field and logic fails to populate the value in the report as expected. When a new field is added to an SSRS temp table, even if the logic is correct, the report might not display the… Continue Reading AnithaEswaran’s...
What License Do SysAdmins Need in D365FO?
Photo designed by FreePik Licensing in Dynamics 365 is complex, licensing in D365FO is even more difficult. I’ve written numerous articles in the past on licensing but one question I get quite often is ‘What License Do SysAdmins Need in D365FO?’ Let’s take a look at what the Dynamics 365 Licensing Guide says and if that matches what D365FO itself reports. < h4>Dynamics 365 Licensing… Continue Reading...
APIOps: ALM for Azure API Management
In this post, I’m going to talk about APIOps, the DevOps techniques applied to Azure API Management, that allow us to automate the promotion of changes between API Management instances. It would be possible to attain a certain degree of automation using Bicep, but it wouldn’t apply to many elements of the APIM, and that’s… Click here to continue reading APIOps: ALM for Azure API… Continue Reading Adrià...
Session information in D365FO – Why and Where?
When a support ticket is logged with Microsoft for D365FO . Microsoft often requests session information. What is the purpose ? Identifying the Affected User and Session: Session information allows Microsoft to pinpoint the specific user and session in which the issue occurred. This is important because different users may have varying roles, permissions, and settings, meaning the… Continue Reading AnithaEswaran’s Article...
Summit Academy – D365FO Administration & Developer Overview Class Plan
With the Dynamics Communities Summit Conference fast approaching, I wanted to share a lesson plan overview of the Summit Academy class that Peter Ramer and myself are presenting. Links D365FO Administration & Developer Overview – Academy Class Class Overview YouTube Video Dynamic Communities Summit Conference Course Lesson Plan Overview Development Options Cloud Hosted Environment Local… Continue Reading Alex’s...
Export and download attachment- D365FO Document management
Often we find it difficult to export the documents / attachments from D365FO as there is no direct way to handle this ask. I had similar requirement and managed to do it via Odata action and Logic apps. Logic apps need not be mandatory , but I prefer to follow the same integration pattern in my current assignment. There are many out of box attachments entity ,in case you don`t have one… Continue Reading AnithaEswaran’s...
D365 Performance Checklist: Troubleshooting and Resolving Performance Issues
You often hear phrases like: Performance in Dynamics 365 is a critical aspect for both users and system owners. For end users, poor performance can lead to frustration, while system owners face challenges in identifying and resolving performance issues. To help streamline this process, I’ve created a practical checklist that outlines steps to quickly diagnose … Continue reading D365… Continue Reading Kurt Hatlevik’s...
D365FO Data Entity Metadata in 10.0.40
A while ago I wrote a blog post on how you could obtain metadata about data entities within D365FO. Originally this was written against version 10.0.35, I wanted to update this for the 10.0.40 release. The updated file can be found here: D365FO Data Entity Metadata 10.0.40 As a refresher, this Excel has the following tabs: Metadata – which shows the label, public collection name, and public… Continue Reading Alex’s...
D365 : Purge Incremental Changes History
If you have looked into your D365 F&O capacity, you sometimes see a lot of data being stored in the tables EventEntitySyncTables and BIIncrementalTableModifications. I see in the code, that there are things in place to clean them up, but there be situations where this code for some reason is not executed. The contents of … Continue reading D365 : Purge Incremental Changes History Continue Reading Kurt Hatlevik’s...
New Release of D365FO Admin Toolkit v1.7
We’ve had another contribution from the Microsoft Dynamics community and are ready to release the v1.7 version of the D365FO Admin Toolkit! D365FO Admin Toolkit v1.7 D365FO Admin Toolkit v1.7 Release D365FO Admin Toolkit GitHub Note: This has been built against a 10.0.39 version of D365FO Let’s look at the new features, functionality, and bug fixes in this release! New Feature Overview The… Continue Reading...
D365FO Document Management with Sharepoint
Document management with SharePoint in Dynamics 365 Finance and Operations (D365FO) integrates powerful document management capabilities, allowing users to efficiently store, manage, and collaborate on documents within the D365FO environment. Integration Setup Navigate to the Document Management parameters in D365FO and configure the integration with SharePoint. This setup involves… Continue Reading AnithaEswaran’s Article...
Power Platform Admin Center Known Issues: Simplifying Support and Workarounds
The transition from LCS to Power Platform admin center is steaming ahead, and I would like to put a spotlight into the “known issues” that is available in PPAC. If you go into the support menu in LCS, you are now directed to PPAC: Then you now have a known issues tab, where you can … Continue reading Power Platform Admin Center Known Issues: Simplifying Support and Workarounds Continue Reading Kurt Hatlevik’s Article...
D365 – Will 10.0.41 be the release where Copilot shows it value?
For quite some time we have heard that AI and Copilot will revolutionize everything. But I still feel I work in the same way as I have always done. There are some clear benefits of correcting my spelling and language. I also love the Copilot in Visual Studio when working. But what it comes to … Continue reading D365 – Will 10.0.41 be the release where Copilot shows… Continue Reading Kurt...
Logic apps Standard – Parameterization
In Logic Apps Standard, parameters play a crucial role in creating dynamic, flexible, and reusable workflows. Parameters enable the reuse of workflows by allowing you to define values that can be changed without modifying the workflow’s structure. By centralizing common values into parameters, maintenance becomes easier. If a value needs to be updated (e.g., an endpoint URL), it can be changed… Continue Reading...
Extracting Subfolder Details from Parent Directory using logic apps
I was working on a SharePoint integration that involved multiple subfolders within a parent folder. Files could be dropped into any of these subfolders, and the trigger needed to detect the folder name to create a corresponding document in D365FO. Below is the folder structure. When a file is placed in any of the folders (each representing a customer number), the flow should detect the… Continue Reading AnithaEswaran’s...
Comparing Security Between D365FO Versions
With Microsoft on a true ‘one version’ solution for Dynamics 365, it can become extremely important to ensure change management practices are followed during updates. I have previously released a tool that could potentially help with this process and I wanted to walk through how this can be done. Extract Configuration Settings Because of my work, I normally have multiple versions of D365FO… Continue Reading...
How To Use A Recurring Integration Endpoint
How To Use A Recurring Integration Endpoint 07/10/24 Integration How to use a recurring Integration Endpoint for importing data Recurring Integration Endpoints for Finance and Operations are an interesting option for integrations. From the Microsoft docs, it looks like it’s meant for an input/output scenario where we have an inbound message and… Continue Reading Nathan Clouse’s Article on their blog How To Use A...
How to use a recurring Integration Endpoint to Import Data
How to use a recurring Integration Endpoint to Import Data 07/10/24 Integration How to use a recurring Integration Endpoint for importing data Recurring Integration Endpoints for Finance and Operations are an interesting option for integrations. From the Microsoft docs, it looks like it’s meant for an input/output scenario where we have an inbound… Continue Reading Nathan Clouse’s Article on their blog How to use a...
New Release of D365FO Admin Toolkit v1.6
We’ve had some great community contributions to get us to v1.6 of the D365FO Admin Utility! D365FO Admin Toolkit v1.6 D365O Admin Toolkit v1.6 Release D365FO Admin Toolkit GitHub Note: This release has been built against a 10.0.39 version of D365FO. Let’s look at the new features and functionality and bug fixes in this release! New Features Adding support for having an automatic expiration… Continue Reading Alex’s...
How To Create A YouTube Video
As part of writing articles, I typically create a YouTube video that covers the same content. I have found that some people like to read articles while others like to watch videos. Creating content in both of these formats can help reach a wider audience. In this article and video, learn all of the tips… Continue Reading → The post How To Create A YouTube Video appeared first on Dynamics 365… Continue Reading...
Database Inserts – Code Table Comparison
Submitted by Nathan Clouse on 07/07/24. Last modified: 07/07/24 Tags: performance Database Inserts – Primary Table Comparison between dev box and Sandbox Environment In a previous article, I wrote about the fastest ways to insert data but only looked at it from a development VM ( In Azure ) perspective. I thought it would be worthwhile to… Continue Reading Nathan Clouse’s Article on their blog Database...
The Book of Batch Jobs
I created a collection of articles on Finance and Operations (F&O) batch jobs to have a comprehensive resource for understanding and optimizing batch processing. This compilation includes guides on configuring and scheduling batch jobs, troubleshooting common issues, and best practices for performance tuning. Each article delves into specific aspects, such as leveraging the RunBaseBatch… Continue Reading Nathan...
BatchRetryable Top Picking Batch Job Example
BatchRetryable Top Picking Batch Job Example 06/29/24 BatchRetryable Top Picking Batch Job Example I recently presented at DynamicsMinds on batch jobs and how to design them for specific types of workloads. There was interest in code samples so this in one of those code samples talking about Top Picking with a review. Top picking is a method of creating a list of work that is stored in… Continue Reading Nathan Clouse’s...
BatchRetryable Bundled Batch Job Example
BatchRetryable Bundled Batch Job Example 06/27/24 BatchRetryable Bundled Batch Job Example I recently presented at DynamicsMinds on batch jobs and how to design them for specific types of workloads. There was interest in code samples so this in one of those code samples talking about Batch bundling with a review of the code and design. Batch Bundling is a way of designing and managing a… Continue Reading Nathan Clouse’s...
Powershell to Deploy a PPAC UNO Environment
Submitted by Nathan Clouse on 06/27/24. Last modified: 06/27/24 PowerShell Script to Deploy an UNO Environment Below is a PowerShell script to deploy a unified developer environment for F&O. But first, be sure to read Aurélien CLERE’s great blog post about this type of environment. You should also check out this tech talk on the UDE environment type and some additional reading from MSFT…. Continue Reading Nathan...
Installation of one or more roles, role services, or features failed. Error: 0x800f0954
Installation of one or more roles, role services, or features failed. Error: 0x800f0954 06/24/24 LBD Installation of one or more roles, role services, or features failed. Error: 0x800f0954 when configuration an AOS for Local Business Data (LBD) When you attempt to install .NET Framework 3.5 for Local Business Data Finance and Operations, you can… Continue Reading Nathan Clouse’s Article on their blog Installation of one or...
New Release of D365FO Admin Toolkit v1.5
It’s time for another release of the D365FO Admin Toolkit, we are now on version 1.5! Version 1.5 Release D365FO Admin Toolkit v1.5 Release D365FO Admin Toolkit GitHub Note: This release has been built against a 10.0.39 version of D365FO. Let’s look at the new features and functionality and bug fixes in this release! New Features Excluded Users Added ability to dynamically add / remove users… Continue Reading Alex’s...
Expense Reports Dates (TBD)
Expense Creation Date = Document Date in the GLTransaction Date (when the expenses occurred) = Project Date in the sub-ledgerGL Posting Date will be equal to Transaction Date, if the period is not closed. If the period is closed, then GL Posting Date will be the 1st day of the next open period, if the “Correct accounting date during posting” parameter is ON. Continue Reading noreply@blogger.com (Sarang...
How To Write A Blog Article
Over the last few years, I have been writing D365 articles and tutorials. During that time, I have learned some tips and tricks on how to write a blog article that I would love to share with you. Like me, you may love learning and teaching others new things. As part of that, you want… Continue Reading → The post How To Write A Blog Article appeared first on Dynamics 365 Musings. Continue Reading peter.ramer’s Article...
BatchRetryable Individual Task Modeled Batch Job Example
BatchRetryable Individual Task Modeled Batch Job Example 06/14/24 Batch Individual Task Modeling BatchRetryable With lots of Individual tasks from 1 batch job I recently presented at DynamicsMinds on batch jobs and how to design them for specific types of workloads. There was interest in code samples so this in one of those… Continue Reading Nathan Clouse’s Article on their blog BatchRetryable Individual Task Modeled Batch...
BatchRetryable RunBaseBatch Class
BatchRetryable RunBaseBatch Class 06/09/24 RunBaseBatch RunBaseBatch Updated “Standard” Batch Job for BatchRetryable I wrote an article on how to create a batch class several years ago. I thought I’d update it for modern times with the implementation of BatchRetryable. All source code for this article can be… Continue Reading Nathan Clouse’s Article on their blog BatchRetryable RunBaseBatch Class Updated...
GA of D365F&O 10.0.40
In my previous article , I have mentioned about the preview features of 10.0.40 This post gives an overview of the features includes with GA. Copilot in finance and operations apps for developers Feature name : Extend Copilot with client plugins – – Enabled by default Developers can extend Copilot in finance and operations apps by creating client actions that are based on… Continue Reading AnithaEswaran’s...
D365 Commerce versioning
Have you ever wondered about the versioning numbering in the Dynamics 365 Commerce? Here is a small explanation. If you have a version like 9.49.24030.9, this means 9 – Main release number.49 – This is the number that increments for each service release. Like 10.0.39, 10.0.40 etc. .24 – This is the year of the … Continue reading D365 Commerce versioning Continue Reading Kurt Hatlevik’s Article on their...
Webhook validation handshake failed – Azure Event Grid
There are various ways to integrate EventGrid in portal. In this article, let us learn how to create a Topic using Web Hook in the event grid. Read till the end , as the developers face challenge when saving the Web hook. For the Webhook input, I have created a logic apps. Trigger for this logic apps is ‘Https’ . Upon saving the workflow, a URL will be generated . Make a note of the URL… Continue Reading...
Starting Azure VMs from Postman
Being a technical architect, my day usually begins with starting the FO azure VMs. This will be possible only if the user has access to LCS or azure portal. Auto start and auto shut -down is possible in Azure but if you plan to start the day in advance or if the VM turns off due to auto shut down enabled, you will need to wait for someone to turn on the machine. I have experienced myself… Continue Reading AnithaEswaran’s...
Odata query options with D365FO – Multiple filter
In my earlier posts , part1 , part2 I have explained about the various options for Odata. This is a short post on filter query. See the below query Select * from SalesTable where SalesOrderNumber=”SO-1500″ and DataAreaid = ‘USRT’ How do you pass this to the odata query https://fourl/data/SalesOrderHeadersV2?cross-company=true&$filter=SalesOrderNumber eq ‘015601 ‘ and… Continue Reading...
Intercompany Setup in D365PO (non-stock)
Intercompany Configuration • Parameter setup in both legal entities • Intercompany customer vendor set up in both legal entities • Intercompany setup in the General Ledger setup • Project category to be created in both legal entities...
Fee transaction on the Fixed Price Project in D365 Project Operations (non-stock)
Fee transactions are only allowed on the Fixed Price projects in standard D365FO. However, when it comes to the Non-Stock version of D365PO (where D365PO is connected to D365FO), the system does not stop you from posting fee transactions (journals) on a fixed-price project. The fee journal is “Confirmed” successfully in ProjOps and the transaction starts appearing under the posted project… Continue Reading...
Activación automática de Virtual Tables en D365F&O
A estas alturas, todos sabemos de la importancia que tiene el uso de Tablas Virtuales o Virtual Tables (aka Virtual Entities) en en Dynamics 365 Finance and Operations apps. Quizá uno de los usos más comunes y conocidos es el de utilizar Dynamics 365 F&O como origen de datos en Power Apps de tipo lienzo (canvas) sin la necesidad de almacenar datos en Dataverse, con el sobrecoste (de… Continue Reading ja.tomas’s Article...
Default dashboard issue in D365FO 10.0.39
We upgraded to 10.0.39 and found the home page of D365FO was throwing error ‘Menu item with default dashboard could not be opened’. Initially we assumed it might be due to some issue in the custom models.. We found a temporary workaround by directly directly accessing a menu item rather than accesssing the URL to landing page. https://URL/?cmp=PL01&mi=CustTable But when the same… Continue Reading...
How do I Determine the Azure Region for my Production Dynamics 365 Environment with AI
There are a lot of considerations when looking at where a production environment should be deployed. The first question that comes to mind is whether we can “get away with” one production instance or need to support multiple production instances by region or even country/division. Additional factors apply: Latency, weighted by number of workers in each location/geo Licensing: every user needs… Continue Reading Dag...
New Release of D365FO Admin Toolkit v1.4
I’m excited to announce the v1.4 release of the D365FO Admin Toolkit! Version 1.4 Release D365FO Admin Toolkit v1.4 Deployable Package D365FO Admin Toolkit GitHub Note: This release has been built against a 10.0.39 version of D365FO, which is the current GA release. Let’s look at the new features and functionality and bug fixes in this release! New Features Automatically Disable Users Who… Continue Reading...
Preview of D365FO SCM 10.0.40
Preview of release: April 2024 General availability of release (self-update): June 2024 General availability of release (auto-update): July 2024 Features included in the release : Copilot and AI innovation : (Enabled by default) Enable efficient, accurate demand planning with Copilot In-product guidance, forecast insights, and the ability to explore trends, anomalies, and… Continue Reading AnithaEswaran’s Article on their...
How to Clone and Configure a D365FO Project From GitHub
Earlier this year I released the initial version of the D365FO Admin Toolkit as an open source project on GitHub. One piece of (extremely fair) feedback I got was that I did not explain the process on how to clone the source code of that project to a local machine if you wanted to extend the solution or even if you wanted to help contribute to it by creating new features or functionalities…. Continue Reading Alex’s Article...