Syam Kumar

  https://d365ffo.com/2022/08/18/ax-d365fo-list-of-all-symbols-fonts-image-icons-for-tiles-and-buttons-2/

Through X++ code we can perform database synchronization either on a required table (or) on all tables bases on our requirement. This could be very useful during on-premises environments package deployments because can can drastically reduce the downtime. In fact you can only synchronize the tables that you have actually modified rather than perform an entire synchronization public static void main(Args _args) {   // On specific table, for all tables just call the method dbSynchronize() without any parameters    appl.dbSynchronize(tableNum(CustTable)); }

 public class FormA extends FormRun implements OfficeIGeneratedWorkbookCustomExporter { public void customizeMenuOptions(OfficeMenuOptions _menuOptions)     {         DataEntityName       DataEntityNameA    = tableStr( DataEntityA  );         str menuItemId = strFmt( DataEntityNameA    , 'MenuId');         OfficeGeneratedExportMenuItem menuItem = OfficeGeneratedExportMenuItem::construct( DataEntityNameA    , menuItemId);         str displayName = new DictDataEntity(tableName2Id( DataEntityNameA    )).label();         menuItem.displayName(displayName);         _menuOptions.customMenuItems().addEnd(menuItem);         _menuOptions.dataEntityOptions().addEnd(OfficeMenuDataEntityOptions::construct(tableStr( DataEntityA   )));     }  public ExportToExcelDat...

In the future you could reduce AXDB size by running the following SQL query: truncate table BATCHHISTORY truncate table BATCHJOBHISTORY truncate table EVENTINBOX truncate table EventCUD truncate table EVENTCUDLINES   and then truncating the database:

 Labels with different languages saving issues 

 

https://rahulmsdax.blogspot.com/2018/12/try-catch-in-ax-2012-dynamics-365_20.html  

https://d365technext.blogspot.com/2018/07/get-field-label-type-and-name-using-x.html http://msdax.blogspot.com/2007/08/get-field-label-in-x.html fieldPName(CustTable,AccountNum)

  /// <summary>     /// insert     /// </summary>     public void insert()     {         if (!this.LineNum)         {             this.LineNum = this.getMaxLineNum() + 1;         }         super();     }     /// <summary>     /// Get maximum line number     /// </summary>     /// <returns>     ///Line number     ///</returns>     public LineNum getMaxLineNum()     {         Table     t ableBuffer;         select maxof(LineNum) from tableBuffer;         return tableBuffer.LineNum;     } Note: Data type is real and Edt use- "LineNum"

https://dynamicsnavax.blogspot.com/2010/08/ax-how-to-use-set-and-setenumerator.html  

https://daxonline.org/1690-extensible-enum-values-are-not-deterministically-assigned-to-a-numerical-value.html   https://community.dynamics.com/blogs/post/?postid=3e855da4-46e1-45e5-b0ef-2c2bbbb5831d

  https://d365technext.blogspot.com/2021/09/InterviewQuestion.html

 https:// syamkumar.cloudax.dynamics.com /?mi=SysTableBrowser&prt=initial&limitednav=true&TableName= TableName &cmp=USSI

   K:\AOSService\PackagesLocalDirectory\Bin\xppbp.exe -metadata=K:\AOSService\PackagesLocalDirectory -all -model=" ModelName " -xmlLog=BPCheckLog_ ModelName .xml -module= ModelName  -car=c:\temp\CAR_Report.xlsx packagesRoot K:\AOSService\PackagesLocalDirectory\Bin\xppbp.exe -metadata=K:\AOSService\PackagesLocalDirectory -all -model=" ModelName " -packagesRoot=K:\AOSService\PackagesLocalDirectory  -xmlLog=C:\temp\BPCheckLogcd.xml -module="FlexProperty" -car=c:\temp\CAReport.xlsx

  Link

Valid Time State link  

 k:\AOSService\PackagesLocalDirectory\Bin\xppfagen.exe -metadata=k:\AosService\PackagesLocalDirectory -model="FlexPropertyFormAdaptor" -xmllog="c:\temp\log1.xml"

 true if the validation succeeded; otherwise, false

MCP lunk  

K:\AosService\PackagesLocalDirectory\bin\labelc.exe -metadata="K:\AosService\PackagesLocalDirectory" -output="K:\AosService\PackagesLocalDirectory\ ModelNam \Resources" -modelmodule=" ModelName "

 cd K:\AosService\PackagesLocalDirectory\Bin\ Microsoft.Dynamics.AX.Deployment.Setup.exe --setupmode importlicensefile --metadatadir k:\AOSService\PackagesLocalDirectory --bindir k:\AOSService\PackagesLocalDirectory --sqlserver . --sqldatabase AxDB --sqluser axdbadmin --sqlpwd ***** --licensefilename C:\Temp\license.txt

Unblock the package after download Create a Folder and paste the downloaded file Extract the file Past "install.bat" file Run as admin the "install.bat" file ====================================== install.bat sample REM -- change current path to the local folder -- cd %0\.. REM -- install package -- AXUpdateInstaller.exe generate -runbookid="test1" -topologyfile="DefaultTopologyData.xml" -servicemodelfile="DefaultServiceModelData.xml" -runbookfile="Runbook.xml" AXUpdateInstaller.exe import -runbookfile=Runbook.xml AXUpdateInstaller.exe list AXUpdateInstaller.exe execute -runbookid="test1" pause

save the file in .bat format Start service  REM Run as Administrator! REM ********************* REM NET START MR2012ProcessService NET START DynamicsAxBatch NET START "Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.exe" NET START W3SVC Pause Stop service REM Run as Administrator! REM ********************* REM NET STOP MR2012ProcessService NET STOP DynamicsAxBatch NET STOP "Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.exe" NET STOP W3SVC Pause

 

  #ISOCountryRegionCodes if (SysCountryRegionCode::isLegalEntityInCountryRegion([#isoDK]) { }

 Link :  workflow

  SysTableLookup sysTableLookup;         QueryBuildDataSource queryBuildDataSourceContract;         Query query = new Query();         queryBuildDataSourceContract = Query.addDataSource(tableNum(FlxContractTable));         queryBuildDataSourceContract.addRange(fieldNum(FlxContractTable, ContractStatusId)).value(enum2Str(FlxContractStatus::Active));         queryBuildDataSourceContract.addRange(fieldNum(FlxContractTable, CustAccount)).value(SysQuery::valueNotEmptyString());         queryBuildDataSourceContract.addRange(fieldNum(FlxContractTable, FeeContract)).value(SysQuery::value(NoYes::No));         sysTableLookup = SysTableLookup::newParameters(tableNum(FlxContractTable), _control,true);         sysTableLookup.addLookupfield(fieldNum(FlxContractTable, contractID), true);         sysTableLookup.pa...

  SysTableLookup sysTableLookup;         QueryBuildDataSource queryBuildDataSourceContractLease;         QueryBuildDataSource queryBuildDataSourcePeriodTable;         QueryBuildDataSource queryBuildDataSourceLeaseType;         Query query = new Query();         queryBuildDataSourceContractLease = Query.addDataSource(tableNum(FlxContractLease));         queryBuildDataSourceContractLease.addRange(fieldNum(FlxContractLease, contractId)).value(dialogContractID.value());         queryBuildDataSourcePeriodTable = queryBuildDataSourceContractLease.addDataSource(tableNum(FlxPeriodTable));         queryBuildDataSourcePeriodTable.addLink(fieldNum(FlxContractLease,BillingFrequencyPeriodId), fieldNum(FlxPeriodTable ,periodid));         queryBuildDataSourcePeriodTable.joinMode(JoinMode::InnerJoin);   ...