Posts

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.
Post a Comment
Read more

How to Create Reatil Sales Order without CSU license

 There is a form called " online store transaction" in D365 F&O.
Post a Comment
Read more

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(); }
Post a Comment
Read more

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...
Post a Comment
Read more

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;
Post a Comment
Read more

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...
Post a Comment
Read more

Creating a class, the best practice way in D365F&O

 Some time ago, I shared my thoughts on the 'construct' pattern, which is commonly used in AX. While I often make use of it, it’s not without its flaws—it can actually violate some best practices. (I’ll cover the issue of deep class hierarchies resulting from this pattern in a future post.) First, it’s worth noting that you can customize the compiler level and the best practice checks it performs. To do this, compile something to bring up the compiler output window. Then, click the Setup button to adjust the settings. For this example, I used compiler level 4 and enabled all best practice checks. Now, let’s create a simple class. This class will simply display information from an InventTable record. 1. ClassDeclaration As we start designing this class, it quickly becomes clear that we need to declare an InventTable record as a member variable. /// <summary> /// Class written to test the construct and new... patterns /// </summary> /// <remarks> /// De...
Post a Comment
Read more