Posts

Showing posts from July, 2020

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());    

Parameter System Design Pattern AX / D365 FO

Parameter System Design Pattern AX / D365 FO The parameter system design pattern holds static setup information for the modules in a company, such as information on the national currency, the posting method, and so on.  The parameter system should be set up as described in this topic.  The parameter record is automatically created by the system and has the following: ·           A parameter table ·           A parameter form ·           A parameter menu item Parameter Table There should be one parameter table per module. Parameter tables have a single record per company, holding the required parameters for the module. The record is cached. To enable the Found-cache, a key is defined. The following table shows the property setup of the table. Property Value Description Name MyModuleParameters Module name (prefix) + "Parameters". Label @.... Mandatory.

Split a string into a container in Microsoft Dynamics 365 FO using X++

Split a string into a container in Microsoft Dynamics 365 FO using X++ Some times when developing we need some string of which we only need a segment of the string, Code :         List  _list      =  new   List ( Types ::String);           Container      con;          ListIterator  iterator;          str                     String1;         ;         String 1         =  "Test-test1-test2 " ;         _list               =  Global ::strSplit(String1, "-" );         Iterator          = new   ListIterator (_list);          while  (iterator.more())         {             con += iterator.value();             iterator.next();            info(conPeek(con,conLen(con)));// retrieve the elements from the container by the index.         }