Dynamic 365 Finance and operation App

     public void lookup()         {             Query query = new Query();             QueryBuildDataSource queryBuildDataSource;             QueryBuildRange queryBuildRange;             SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(HcmWorker), this);             sysTableLookup.addLookupField(fieldNum(HcmWorker,PersonnelNumber));             sysTableLookup.addLookupMethod(tableMethodStr(HcmWorker,name),true);             queryBuildDataSource = query.addDataSource(tableNum(HcmWorker));             sysTableLookup.parmQuery(query);             sysTableLookup.performFormLookup();         }

 We can show the lookup of Designs of reports in d365 fo x++ the following code will show the report design    public void lookup()         {             TmpSrsReportDesignName reportDesignTable;             reportDesignTable = DSSReportRunUtil::getReportDesignTmpTable(HeaderGroup_Report.valueStr());             if (reportDesignTable)             {                 SysTableLookup lookupTable = SysTableLookup::newParameters(tableNum(TmpSrsReportDesignName), this);                 lookupTable.parmTmpBuffer(reportDesignTable);                 lookupTable.addLookupfield(fieldNum(TmpSrsReportDesignName, DesignName));                 lookupTable.performFormLookup();     ...

 We can show lookup of standered and Customized Report on form in d365 fo x++ The Following Code will show you the lookup    public void lookup()         {             SysTableLookup lookupTable = SysTableLookup::newParameters(tableNum(SysMetaReportNameLookup), this);             lookupTable.addLookupfield(fieldnum(SysMetaReportNameLookup, Name));             lookupTable.performFormLookup();         } this lookup show all the standered and customizes Report in d365 fo x++.

  public static DSSDisplayReportTmp getReports()     {                  Table tableBuf;         delete_from tableBuf;                  System.Type axMenuItemTypeDisplay = new Microsoft.Dynamics.AX.Metadata.MetaModel.AxMenuItemDisplay ().GetType ();         System.Collections.Specialized.StringEnumerator menuItemDisplayNames = Microsoft.Dynamics.Ax.Xpp.MetadataSupport::MenuItemDisplayNames ();         while (menuItemDisplayNames.moveNext ())         {             str menuItemName = menuItemDisplayNames.get_current ();             var enum = Microsoft.Dynamics.Ax.Xpp.MetadataSupport::GetModelsOfMetadataArtifact (menuItemName, axMenuItemTypeDisplay).GetEnumerator ();             str modelName = enum.moveNext () ? enum.C...

1). i want get a Subordinates of current user or Reportees of current user who are directly reporting to a peron who are currently logged in.    2). call this method by getting current users  3).this.getListOfSubordinates(HcmWorker::userId2Worker(curUserId())) 4). public List getListOfSubordinates(HcmWorkerRecId _recid)     {         List  responsibleWorkers  =   new List(Types::Int64);         int64 PositionId  =   HcmPositionDetail::findByPrimaryPositionForWorker(_recid).Position;         HcmWorker                   hcmWorker;         HcmPositionWorkerAssignment workerAssignment;         HcmPosition                 hcmPosition;         HcmPositionDetail           hcmPositionDetail; ...

  Override the initValue method of the table and add the below code to increment value of LineNum field whenever new record is created. public void initValue() { YourTableName tableName; super(); select firstonly maxof(LineNum) from tableName; this.LineNum = tableName.LineNum + 1; }

   public real ProductConversionFactor(ItemId _itemid)    {         InventTable inventTable;         UnitOfMeasureConversion MeasureConversion;         UnitOfMeasure fromUnitOfMeasure, toUnitOfMeasure;         RecId productId       =   InventTable::itemProduct(_itemId);                     select * from          MeasureConversion         join fromUnitOfMeasure          where fromUnitOfMeasure.RecId       == MeasureConversion.FromUnitOfMeasure         join toUnitOfMeasure         where toUnitOfMeasure.RecId         == MeasureConversion.TOUNITOFMEASURE         &&  MeasureConversion.Product       == productId...