Posts

D365FO - X++ View | Assign value to String Computed Column in X++ View

Image
 1. Create a view.  2. Add new field in the customize view. 3. Go to Property >> View Method >> Initially No Method will shown. 4. Go to Methods >> Right Click >> New Method. 5. Write the following X++ code to assigning the value to newly added view field.  public static server  str getValue() { return SysComputedColumn::returnField(viewstr( XXX View Name ) ,identifierStr( YYY DataSource Name ),fieldStr( YYY DataSource Name , ZZZ Field Name )); } Note : Target field's  view (XXX), data source(YYY) and field(ZZZ)  name need to replace in the red color Highlighted 6. Build and Synchronize the database.  7. Select the Newly added field and Go to the Property >> View Method >> .Dropdown and Select the newly created method  getValue(). 8. Build the Project once again. NOTE: if you are facing any issue, you can verify the input value from SQL Trace. 
Post a Comment
Read more

Activate Financial Dimension in Dynamics 365 FO. (On- Premises)

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

Configure D365 from VHD.

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

Table Methods

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

D365 FO -Composite Data Entity

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

D365 FO - Data Entity (Azure AD & Postman Access Token)

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

Download VHD from LCS

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