Posts

How to Maintain Log in App insight directly from D365F&O/x++ code

Image
 What is Application Insights? Application Insights, a feature of Azure Monitor, is an extensible Application Performance Management (APM) service for developers and DevOps professionals. Use it to monitor your live applications. It will automatically detect performance anomalies, and includes powerful analytics tools to help you diagnose issues and to understand what users do with your app. It’s designed to help you continuously improve performance and usability.  Application Insights can be used to log: Events Azure Application Insights Telemetry Data Model – Event Telemetry – Azure Monitor | Microsoft Docs Exceptions Azure Application Insights Exception Telemetry Data model – Azure Monitor | Microsoft Docs Requests Data model for request telemetry – Azure Application Insights – Azure Monitor | Microsoft Docs Metrics Data model for metric telemetry – Azure Application Insights – Azure Monitor | Microsoft Docs Traces Azure Application Insights Data Model – Trace Telemetry – A...

Process to Provision Target Tool in Dynamics 365 Finance and Operations

Image
  Introduction: When Copying a database between environments, you will need to run the Environment Re-Provisioning tool before the copied Database is fully functional, to ensure that all the Retail Components are up-to date. Steps: Steps to Process Re-Provisioning Tool: 1. Log in to your LCS Project. 2. Go to Asset Library. 3. Select “Software Deployment Package”. 4. Click on Import. 5. Select “Environment Provisioning Tool”. 6. Click Pick. 7. Once this Package is available in your Asset Library, upload this package to your system and schedule it to run as you do for any other deployable package. 8. Go to Maintain and Apply updates.

How to Create Reatil Sales Order without CSU license

 There is a form called " online store transaction" in D365 F&O.

Activate Change Management on POs Through X++

 I had a requirement to update a field on a Purchase Order (PO) during the confirmation process. To make this change, I temporarily set Change Management to "No". After updating the field, I attempted to set ChangeRequestRequired back to "Yes". However, I encountered the following error: "Changes to the document are only allowed in the state Draft, because change management is activated." The error occurs on the second update() call because the system considers Change Management as already enabled, even though the flag hasn’t been persisted to the database yet. As a result, the update is blocked due to the PO no longer being in the Draft state. using (var purchTableSkipBusinessLogicContext = PurchTableSkipBusinessLogicContext::construct()) { purchTableSkipBusinessLogicContext.parmSkipUpdate(true); purchTableSelected.CE_ApplyAttachment = NoYes::No; purchTableSelected.update(); }

Update Deployment Failed due to Missing MpProvider Module

 While upgrading a Tier-1 development environment, the deployment failed with the following error: The specified module 'C:\Program Files\Microsoft Security Client\MpProvider' was not loaded because no valid module file was found in any module directory. Cause: This error indicates that Visual Studio cannot locate the MpProvider module, which may be due to outdated or incomplete installations of Visual Studio. Resolution: Upgrade both Visual Studio 2019 and Visual Studio 2022 to their latest versions. This ensures all required modules are installed correctly. 🔧 Steps to Upgrade Visual Studio For Visual Studio 2019: Open Visual Studio Installer from the Start menu. Locate the Visual Studio 2019 entry. Click Update (if available). Follow the installation prompts. Restart your machine after installation. Launch Visual Studio 2019 to confirm the error is resolved. For Visual Studio 2022: Open Visual Studio Installer . Locate the Visual S...

Rename the DB name in SQL / D365F&O

Image
You just go to SSMS and write these 3 queries on your Database. In my case, I am working with  Microsoft Dynamics 365 Finance & Operations  Alter database AxDB set single_user with rollback immediate; Alter database AxDB modify name = AxDB_old alter database AxDB set multi_user;

Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)

Image
 In the context of a relational database, Keys are one of the basic requirements of a relational database model. keys are fundamental components that ensure data integrity, uniqueness, and efficient access. It is widely used to identify the tuples(rows) uniquely in the table. We also use keys to set up relations amongst various columns and tables of a relational database. Let’s explore the various types of keys used in a relational model, which are essential for organizing and querying data effectively. Why do we require Keys in a DBMS? Keys are crucial in a Database Management System (DBMS) for several reasons: Uniqueness: Keys ensure that each record in a table is unique and can be identified distinctly. Data Integrity: Keys prevent data duplication and maintain the consistency of the data. Efficient Data Retrieval: By defining relationships between tables, keys enable faster querying and better data organization. Without keys, it would be extremely difficult to manage large data...