Posts

Showing posts from March, 2021

How to Import Records from Excel Using X++ Code in D365FO

  How to Import Records from Excel Using X++ Code in D365FO   Include the below namespace in X++ code it will requires to import Excel. Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange;   In addition to the basic reference, include (Directory and DirectoryUpgrade Packages) X++ Code: Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange; class ReadExcel {   public static void main(Args _args)    {     Int id;     Str Name;      System.IO.Stream stream;       ExcelSpreadsheetName sheet;              FileUploadBuild fileUpload,fileUploadBuild;       DialogGroup dialogUploadGroup;       FormBuildControl formBuildControl;       Dialog dialog=new Dialog("Excel Import using dialog");       dialogUploadGroup=dialog.addGroup("@SYS54759");       formBuildControl=dialog.formBuildDesign().control(dialogUploadGroup.name());    

D365 FO :ENABLE MAINTENANCE MODE FOR LICENSE CONFIGURATION

D365 FO :ENABLE MAINTENANCE MODE FOR LICENSE CONFIGURATION In D365 FO ,   For change settings in License configuration have to enable maintenance   mode. By default it is turned off. But you can easily enable the maintenance mode in development environment.   For SAT and Production need to submit service request.   Two ways we can enable maintenance mode and edit license configuration : 1.        Run the   below SQL query on transaction database of environment(AxDB)  After executing the query, restart the environment.          update  dbo.SQLSYSTEMVARIABLES  set dbo.SQLSYSTEMVARIABLES.VALUE = 1  where dbo.SQLSYSTEMVARIABLES.PARM = ‘CONFIGURATIONMODE’   2.       Take RDP and Run command prompt as administrator.  Execute below command in CMD.   K:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe –metadatadir K:\AosService\PackagesLocalDirectory –bindir K:\AosService\PackagesLocalDirectory\Bin –sqlserver . –sqldatabase axdb –sqluser

D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++

 D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++ class DemoRefresh { static void main(Args args) { Table                                      table; FormDataSource                 formDataSource ; ;   table = args.record();   if (table.RecId) { formDataSource = args.record().dataSource();   ttsbegin; table.selectForUpdate(true); table.field1 = “ABC”; table.doUpdate();   formDataSource.executeQuery();   formDataSource.refresh();   ttscommit; info(table updated'); } }   }