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...
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...
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...
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...
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...
New pricing for Microsoft Dynamics 365 effective October 2024
Below is the list of products which has updated prices effective from October 1 , 2024. These increases will apply globally to new and existing customers (upon renewal as of October 1, 2024), and the products will be priced comparably in other currencies. To comply with local regulations, US government list prices for the same products will increase by 10% effective October 1, 2024,… Continue Reading AnithaEswaran’s...
Virtual entity in Data Management – 10.0.39
This new tile ‘Virtual Entity’ in 10.0.39 sparked my interest, prompting me to delve deeper into its functionalities. This lists all the virtual entities and their sync status. There is also an option to create/see the user flow in Power Automate. Whenever there is a refresh triggered in Dataverse, this would be automatically reflected here. You can force a refresh of a… Continue Reading AnithaEswaran’s Article...
One Dynamics One Platform – D365FO – LCS – PowerPlatform
Nice to see that One Dynamics One Platform is making strides towards a more seamless experience for its users. It’s exciting to hear that LCS is slowly merging with Power Platform. In fact, I recently tried to raise a support ticket from LCS and was pleasantly surprised to be directed to the Power Platform Admin page. It’s great to see these two platforms working together to provide a… Continue Reading...
D365FO Service updates
Microsoft is dedicated to providing consistent service updates. These updates are typically made accessible for self-deployment prior to Microsoft implementing automatic updates. The timing of self-update package release compared to production autoupdates may vary. Please refer to my earlier post to know the details of most recent service updates. Beginning April 2024, Microsoft is… Continue Reading AnithaEswaran’s Article...
D365 FO 10.0.39 revised release notes
Due to certain impediments, the release of version 10.0.39 has been postponed, and it is now slated to be released in April alongside a fresh array of features. General availability of release (self-update): March 2024 General availability of release (auto-update): April 2024 Application version: 10.0.1860.56 Platform version: 7.0.7198.66I have already given the list of features… Continue Reading AnithaEswaran’s Article on...
Azure security best practices
The purpose of Azure security best practices is to ensure that Azure cloud environments are adequately protected against security threats and vulnerabilities. These practices help organizations implement robust security measures to safeguard their data, applications, and infrastructure hosted on the Azure platform.By following these best practices, businesses can mitigate risks, maintain… Continue Reading AnithaEswaran’s...
Azure blob – Tier architechture
Azure services groups the services into four – Blob, Files, Queues,Tables. Though we are familiar with these terms , learning the usage and purpose can leverage cost benefit. Today`s post focuses on blobs and its tiers. Blob stands for Binary Large Object. Azure Blob Storage is a service that stores unstructured data in the cloud as objects or blobs Also referred as Object… Continue Reading AnithaEswaran’s Article on...
New update on Regulatory configuration service (RCS) as globalization studio in D365FO.
Regulatory Configuration Service (RCS) will be deprecated. This new feature implifies the experience of extending and customizing key globalization areas of tax e-invoicing regulatory reporting banking business documents. With the release of this feature, all new RCS provisioning is stopped. If provisioning is required, register a support ticket. We will be working… Continue Reading AnithaEswaran’s Article on their blog...
InvalidProtocolResponse – Logic apps
I was trying to configure composite entity for D365F&O using logic apps and faced the below error. The response to partial content upload initiating request is not valid. The response to initiating partial content upload request must contain a valid location header. This was due to a simple set up which was on by default in ‘Http’ action. Turning it off did the magic and… Continue Reading AnithaEswaran’s...
Cloud service types
Microsoft learn has abundant resources to get introduced to basics or refresh our knowledge to keep ourselves updated. One topic I refreshed this week is ‘Cloud service types’ Key terms : Managing and configuring resources Shared responsibility model IaaS, PaaS,SaaS Referred to as the cloud service stack, with each layer building upon the capabilities of the layer beneath… Continue Reading AnithaEswaran’s...
Logic apps – Key vaults for Encryption
I had to work on a task where they data has to be encrypted during automation and logic apps came to my rescue to make the job simple and easy. Logic apps has a Key Vault connector to do this job. I am encrypting my data from logic apps and thus necessary permissions has to be given to logic apps. Let us first create a Key vault. Create a new Key vault and enter the name. I… Continue Reading AnithaEswaran’s Article on...
SFTP connector with Private key – Logic apps
This article shows you how to connect SFTP gateway via logic apps using private key. In our instance, Standard logic apps is used. Create a new workflow. Let the trigger be Recurrence. Add the next step and search for ‘SFTP-SSH’ Let us select the action ‘List files in folder’ . In the above screenshot, when you try to paste the Private key directly, connection will… Continue Reading AnithaEswaran’s...
Punchout – CXml – External Catalog – D365 F&O Configuration – Part 1
Dynamics 365 Finance and Operations supports integration with various procurement and e-procurement solutions. The integration process allows the users to “punch out” to external supplier catalogs, select items, and seamlessly bring them back into the procurement workflow. This means it allows the users to purchase through vendors without need to store the master data and information such… Continue Reading...
Power platform integration for D365F&O VM
Are you unable to find the Power platform add-ins in the LCS ? It might be because your user id doesn`t have advanced privilege to view or the VM might not be configured with Power Platform Integration. I can read your next question what happens if the integration is not enabled during VM provisioning? Unfortunately there is no option now to enable after the vm is provisioned. So we… Continue Reading AnithaEswaran’s...
D365FO bacpac import – Unable to connect to target server localhost – Error occurred during the login process
My team had an issue today when importing the bacpac in their devVM. Though the first issue was resolved with this fix , the import again ended up in the error . Unable to connect to target server ‘localhost’. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server. A connection was successfully established with… Continue Reading...
Secure inputs / outputs in Logic apps
Logic apps is best in orchestrating the workflow integrations and it has close to 200+ connectors .With its simple UI designer , it has become the favourite middleware for any integration scenarios. Data plays a major role in today`s transactions and it is important to secure it. For instance, if the auth token which consists of secret / client id / tenant should be secured as these… Continue Reading AnithaEswaran’s...
OData query options with D365F&O (Part 2)
In the previous post, I have explained about the various options of quering F&O using OData. Let us continue the ARITHEMATIC queries in this post. Less than – Applicable for numeric fields . Retrives the records that have the value mentioned in the lt clause and includes zero values in the result. For instance, to fetch the products whose Salesprice is lessthan 150 . The query is… Continue Reading AnithaEswaran’s...
Lifecycle Management of Azure blob
Every data set has a unique lifecycle. Early in the lifecycle, users tend to access some of the data in the set, but not all of the data. As the data set ages, access to all of the data in the set tends to dramatically reduce. Some data set stays idle in the cloud and is rarely accessed after it’s stored. Some data expires within a few days or months after it’s created. Other data is… Continue Reading...
Resubmitting from an Action in Logic Apps Workflows
Resubmitting feature seeks to provide customers with more control over how they resubmit failed transactions and avoiding data duplication or increasing new operational friction. Earlier, if we need to reprocess the failed execution, we only had an option to select the execution and click ‘Resubmit’ . But this could potentially create duplication in the action calls that were successfully… Continue Reading...
Workflow Assistant – Standard Logic apps
The workflow assistant is a chat interface to answer any questions about Azure Logic Apps, from directly within designer. You can also use it to describe existing workflow or prompt for specific answers in the context of your workflow. The chat interface provides access to Azure Logic Apps documentation and best practices without requiring you to navigate documentation or search online… Continue Reading AnithaEswaran’s...
OData query options with D365F&O (Part 1)
As we all know, OData provides a standardized way for applications like D365F&O to expose their data, making it easier for developers and IT pros to work with, integrate, and leverage the data for a wide range of purposes. Though Odata querying is familiar to us, I will give a brief walkthrough of various CRUD operations with D365F&O. FILTER and COUNT Below query filters the Customer… Continue Reading...
Users can extract the tables list from Data entity – D365F&O
We are aware that Data Entities in D365F&O represent a specific data object, typically corresponding to a table or view in the underlying database. They define the structure and attributes of the data they represent. From a technical background , I have fair idea on the tables referred in a data entity. But for an external user who needs this information and without a developer help,… Continue Reading AnithaEswaran’s...
Data entity Export/Import for Feature Management
A data entity that is named Feature management lets you export the Feature management settings from one environment and then import them into another environment. This entity updates only existing features. The business logic in the entity also helps guarantee that the same rules that are used on the Feature management workspace will be applied when the import is done. For example, you… Continue Reading AnithaEswaran’s...
End of mainstream support for Microsoft Dynamics AX 2009, Dynamics AX 2012, Dynamics AX 2012 R2, and Dynamics AX 2012 R3
Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended on October 9, 2018. Security hotfixes were provided for those three versions through the extended support period, which ended on April 12, 2022 Mainstream support for Dynamics AX 2012 R3 ended on October 12, 2021. Only security hotfixes will continue to be provided through the… Continue Reading AnithaEswaran’s...
D365FO Business event for cloud hosted environments – Error Response Status code does not indicate success : 400
As we are aware Business events are used to send messages to third party applications when the active event is triggered. When you set up business events or virtual entities in a cloud-hosted environment, you might receive the following error message: Response Status code does not indicate success : 400 ({“error”:”invalid_client”,”error_description”;”Expected aud… Continue Reading...
‘Update a record’ action using FinOps connector in Logic apps
If you want to updates a single record in an entity using Logic apps, we have two options Use Odata URL directly in the POST method like below PATCH URL/data/SalesOrderPools(PoolId=’04’,dataAreaId=’usmf’) BODY { “PoolName”: “Updated text” } Second option is via logic apps connector. It is tricky to understand the field notation. But once we get the grip, it is easy If the… Continue...
Number sequence set up for SmmContactPersonId – D365F&O
There are many changes occuring with the latest updates in D365F&O. Few of them, though minor takes our time during troubleshooting. One such challenge was finding Number sequence set up for SmmContactPersonId. Earlier it was present in ‘Sales and Marketing -> Set up -> Parameters -> Number sequence’. We had to spend an hour to hunt for this set up as it is not seen in the above path…. Continue Reading...
Easy identification of D365FO Environments – Chrome extension
While working on multiple projects or environments, we will always have various windows left open . Rather than checking the Address bar every time , if we have some extension which highlights the environment name in the active window, that would be a life saver. I am using the chrome extension ‘Environment tagger’ which helps me to identify the active window tagged with a label.
SSMS – Color pattern to differentiate various environments
Being a technical, my SSMS window will have multiple active connections , thus at times it will be perplexful to identify the correct environment. I found the below solution long back , but thought of sharing to the community which would surely benefit people like me. SSMS has the option of choosing colors in the option ‘Connection Properties’. This option would highlight the SSMS… Continue Reading...
Latest update on Preview release of D365F&O
Customers can take up to four service updates per year and are required to take a minimum of two service updates per year. Customers can choose to pause one update at a time. Pausing a service update can apply to the designated user acceptance testing (UAT) sandbox, production, or both environments. After the pause window ends, and if the customer hasn’t self-updated to a supported service… Continue Reading...
Inventory Visibility Add-in – Supply Chain Management – Part 1
With more demand on integrating systems, it is time-consuming to get a clear picture of the inventory status . With the Microsoft`s Inventory visibility add-in for SCM, above issue is no more a challenge to get the real-time , accurate view of inventory . This is even applicable for larger volume organizations. Inventory visibility is a real-time service which helps the business to keep… Continue Reading AnithaEswaran’s...
Automatic import of Bank statement – D365FO
With the version 10.0.36, it is not possible to automate the import of Bank statement to Sharepoint folder. More details soon. Continue Reading AnithaEswaran’s Article on their blog Automatic import of Bank statement – D365FO With the version 10.0.36, it is not possible to automate the import of Bank statement to Sharepoint folder. More details soon. Blog Syndicated with AnithaEswaran’s...
Azure Active Directory applications to Microsoft Entra ID applications – D365FO 10.0.36
With the version 10.0.36, Azure Active Directory applications have been changed to Microsoft Entra ID applications D365FO 10.0.35 D365FO10.0.36 Continue Reading AnithaEswaran’s Article on their blog Azure Active Directory applications to Microsoft Entra ID applications – D365FO 10.0.36 With the version 10.0.36, Azure Active Directory applications have been changed to Microsoft Entra ID applications D365FO 10.0.35...
Microsoft AI Builder Challenge – Recognize Text with AI builder – Learning & Sharing – Part 2
In part 1, I explained about creating and training the model for document processsing. In this post, let us learn on using OCR(Optical Character Recognition) capabilities using AI model. AI Builder Text recognition is a prebuilt AI model that extracts lines of text from documents and images By providing samples of data, model can be trained to perform predictions. So far, only English… Continue Reading AnithaEswaran’s...
Microsoft AI Builder Challenge – Process Custom Documents – Learning & Sharing – Part 1
As I have completed Microsoft AI builder challenge, it is time to share the knowledge with our community from the topics which I learnt as a part of this challenge. I am starting with Processing Custom Documents using AI Builder. What is Document Processing? AI builder takes care of reviewing , extracting , organizing and saving the information Create and train the model to… Continue Reading AnithaEswaran’s Article on...
Archive data in D365FO – Part 2 -Inventory Transactions
In my earlier post , I detailed about archiving Sales order with the latest feature management. This post is on archiving ‘Inventory transactions‘ data . As we are aware, InventTrans table keeps increasing and consume maximum database space . System exhibits sluggish runs for the queries made against this table. New feature in FO has minimized this issue by moving the data to history… Continue Reading...
Free access to a D365FO environment(with dev box)
In this post, I will give a quick walkthrough of accessing free dev environment with Visual Studio, SSMS and URL. This can be used for training/development purpose. Click this link using Microsoft Learn account. If the browser is already signed in with this credential, a new button ‘Launch VM mode’ will appear. Else ‘Sign in to Learn’ is displayed. You can use the… Continue Reading AnithaEswaran’s...
Document management – Using AI builder – Power Automate
In my previous post , the document upload was done by reading the file name and proceeding with upload. Here, I will give a walkthrough of uploading the attachment by scanning the contents in the file through AI builder and training the AI model to read the sample documents. Then the document is imported as attachment to the specified PO in the content read by the model. To begin with,… Continue Reading AnithaEswaran’s...
Archive Data in D365FO – Part 1-Sales Order
Data grows over time and it is a good idea to archive it for the effective performance of the system. Latest feature in D365FO has the ‘Archive Set up’ solution which is simple to configure . This set up moves the data to another table , thus querying data from the current table is effacious. In our instance, as we are archiving sales order, the records are moved to SalesTableHistory… Continue Reading...
Embedding copilot in CanvasApp
Add Copilot control to a canvas app – Power Apps Add copilot AI control to your canvas app. Continue Reading AnithaEswaran’s Article on their blog Embedding copilot in CanvasApp Visit the post for more. Blog Syndicated with AnithaEswaran’s...
bak file restore error : The backup set holds a backup of a database other than the existing ‘xxx’ database
Recently I faced an issue when trying to restore a bak file . Though the option ‘Overwrite the existing database (with Replace)’ was selected during restore process, error was not resolved. Instead of executing the ‘Restore’ from database level, I tried to do it from query editor . This helped me to get more insight on the issue. RESTORE DATABASE NewDatabase FROM DISK =… Continue Reading...
Import attachments using PowerAutomate – D365FO
In this blog , let us have a walkthrough of uploading the attachments to FO using PowerAutomate. This approach can be used in logic apps also. In my instance, the files uploaded in one drive are read and imported to Customers. The file name carries the Customer number and this becomes one of the input in Attachment process. Given below the complete pic of the flow There are 2… Continue Reading AnithaEswaran’s Article on...