Microsoft Dynamics D365 Finance and Operation

  If you want to activate the financial dimension in Dynamics 365 on on-premises, you need to do a following step. 1.      Open SQL and go to D365FO Database. 2.     Execute the following Query                   select * from SQLSYSTEMVARIABLES         update SQLSYSTEMVARIABLES SET VALUE = 1 WHERE PARM =                     'CONFIGURATIONMODE' 3.      Execute IIS Restart. 4.     Refresh the Page. 5.     After activating the financial dimension, you need to revert the option.              update SQLSYSTEMVARIABLES SET VALUE = 0 WHERE PARM                     =   'CONFIGURATIONMODE' 6.    Execute IIS Restart. 7.    Refresh the Page.

  Configure D365 from VHD. 1. Download VHD from LCS. Refer the link for how to download the VHD.           Download VHD from LCS 2. Configure the VHD 3. If Wi-Fi not enabled, then you need to Install the correct version of Wi-Fi driver. Connect to the internet 4. If windows license is expired, you need to run the following command from cmd prompt.          " slmgr /rearm.vbs" 5. Needs to Generate Self-Signed Certificates.            -     Go to  https://portal.azure.com .           -      Login with " XXXX@YYYY.onmicrosoft.com ". Password : ZZZZZZZZ          -     Go to "App Registration" >> Select the "D365FO" >> Copy the "Application  ( Client) ID"          -     Go to VHD Desktop select the " Generate Self-Signed Certificates" Shortcut"  ...

 Init Value:          While creating the new record this method will trigger. ValidateField: (Only  for Validation Purpose)          While Focus leave the Fields or Modifying the Fields it will trigger.  Return type is Boolean so we can do our custom validation on the specific fields we can introduced her. It will return the boolean value based on the Field validation. ModifiedField:      When ever any modification on the fields this method will trigger. if we have a customization on both ValidationField and  ModifiedField , this  ModifiedField  method will trigger if  ValidationField return true. ValidateWrite:     This is also validating the records, before committing the records to the database you need to do a validate for any custom logic then write it her. Based on this condition value true it will allow your records to save in the database. ValidateDelete:     S...

 Problem Statement:           Create basic composite data entity. while creating the composite data entity, we need to do the following steps. First we needs to analysis the what are all the relevant tables needed for your requirement.   After that needs to find out what is the relation between them. In Visual studio >> create individual entity for each tables. Make sure all the mandatory fields are selected in the data entity. If you want you to expose the entity to the outside word you needs to enter the " Public Collection Name and Public Entity Name ". Configure the relations between newly created data entity and needs to configure the staging table relations also. Export the relevant table data via DMF, export option.

 Problem Statement:                How to get the D365FO Access Token via POSTMAN. Steps:  visit  https://portal.azure.com/  (For Active Directory Authentication)  Go to Azure Active Directory >> App Registration >>  New Registrations >> Fill the Following Details. After Complete the Registration following details will display in the registration section. Go to the "Certificates & Secrets" >> New Client Secrets. Refer the below attachment. Open the POSTMAN. Collection >> New Collection >> Add Request.(Get Token is a Request name.) Use the following URI in the "GET" method. " https://login.microsoftonline.com/{TenantID} . Note : Tenant ID :- Taken this ID from the Azure registration section.   POSTMAN Body section.  Body >> Form-data >> enter the following key-values.        Access Token will generate after hit the Send button...

 1. Login LCS. 2. Go to "Shared Asset Library" >> "Downloadable VHD" 3.Select the latest version. Each version has a multiple part. 4.Select the part one by one and click the "Generate SAS Link".     Note: if you click the Hyper link it takes more time for downloading. So, we have an alternative option for Generate SAS Link. 5.link copied to your clipboard. 6.Open the Power shell comment prompt. 7. Download the "Azcopy" from microsoft.     Link for download: " Copy or move data to Azure Storage by using AzCopy v10 | Microsoft Learn " 8.Copy and paste it in one folder. 9.In PowerShell go to the folder using the change directory command "cd" 10. Run the following copy command. Syntax: go to the  .\azcopy copy "XXX" "YYY" Note : "XXX" is your clipboard value of "Generate SAS link"               "YYY" is your local saving directory. 11. if  azcopy not executing, install the ...

  Problem Statement:           Read the data from outside Application. Here I am fetch the JSON data from Shopify Integration and push it in to the D365FO System.   Development steps:       Step 1 : Create Runnable Class.      Step 2 : After create the Runnable class, use the following Library in your solution.                               using System.Net.HttpWebRequest;                               using System.Net.HttpWebResponse;                               using System.Text.Json;                               using System.Text.Json.Serialization;  ...

  Error 1:        Table does not contain a valid time state key. A unique index needs to be marked as a valid time state key D365Basics (USR)[Muthu_Extension] C:\AOSService\PackagesLocalDirectory\KARYA_D365FO_Training\Muthu_Extension\AxTable\VAR_ChitMasterTable.xml 0 Solution :      Whenever we set the 'Valid Time State Field Type' as Property for a table, needs to update following property.      Table Property: W e need to map both 'Valid To' and 'Valid From' Columns in the Table Indexes.  Set the Primary Index as 'VAR_ChitGUID_Idx'(Newly Created Index) Instead of "SurrogateKey"                             Index Property:   Set "Alternate Key ": " Yes " in the Index property level. Set  "Valid Time State Key" : " Yes " in the Index Property. Error 2:     Warning BP Rule: [BPErrorTableFieldNotDefinedUsingType]:Path: [d...

Problem statement:     Specific user have a problem for opening the SSRS report in D365 FO. While trying to open following error message will shown. "RDCE process failed for report XXXXX with path C:\AOSService\PackagesLocalDirectory\ XXXXX   \Reports\ XXXXX .rdl." Solution :       Delete and recreate the account from user option it's working for me. 1.  D365 >> Modules >> System Administrator >> User >> Select the User >> Delete it >> Import the User again.