Posts

Showing posts from June, 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());    
Post a Comment
Read more

Filter the data in between two dates using query in X++

Filter the data in between two dates using query in X++ QueryBuildRange  datefilter; public void init() {        datefilter = this .query().dataSourceNo( 1 ).addRange( fieldNum ( TableName ,Date));        datefilter.value(queryRange( 15\06\2020 , 20\07\2020 )); }
Post a Comment
Read more

How to get workflow approvers list using x++

How to get workflow approvers list using x++ WorkflowTable            workflowTable; WorkflowVersionTable     workflowVersionTable; WorkflowElementTable     workflowElementTable; WorkflowStepTable        workflowStepTable; WorkflowAssignmentTable  workflowAssignmentTable; while   select  workflowAssignmentTable      join  workflowStepTable      where  workflowStepTable.RecId == workflowAssignmentTable.workflowStepTable      join  workflowElementTable      where  workflowElementTable.ElementId == workflowStepTable.ElementId      join  workflowVersionTable      where  workflowVersionTable.ConfigurationId == workflowElementTable.ConfigurationId         && workflowVersionTable.Enabled ==  NoYes ::Yes      join  workflowTable      where  workflowTable.RecId == workflowVersionTable.workflowTable     && workflowTable.DocumentTableName ==  "Table" {     info(strFmt( "%1" , workflowAssignmentTable.UserValue));
Post a Comment
Read more

Multi Select Lookup in SSRS Report in D365

Multi Select Lookup in SSRS Report in D365 Description:-   we will create multi select lookup in SSRS report so that we can select multiple data from lookup. Steps how to generate multi select lookup in SSRS report. Create contract class for that and create method for parameters. Contract Class: - [DataContractAttribute, SysOperationContractProcessingAttribute( classstr (TestUIBuilder))] class  TestContract  implements   SysOperationValidatable {      List   ListItemId; [DataMemberAttribute( "Item Id" ),AifCollectionTypeAttribute( "Item Id" ,  Types ::String),        SysOperationLabelAttribute( literalStr ( "Item Id" ))]         public   List  parmItemId( List  _ListItemId = ListItemId) {               ListItemId = _ListItemId;                return  ListItemId; } } //For validation parameters,      public   boolean  validate()     {          boolean              isValid =  true ;          List             
Post a Comment
Read more