Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

Code sample to open excel file in Axapta. You can use below code in any version of Axapta. First, you need to paste the file in particular folder path then you can open it by using job or class. You can check below code through job x++ editor. This code can be helpful if you want to provide the menu item to export template for the user. fileName = "C:\\Users\\Public\\Documents\\TestTemplate.xlsx" ; WinAPI::shellExecute(fileName); WinAPI::setFileAttributes(filename,1);

To Update Project Status by Code in Ax 2012 You can get help from below code sample. In this code if Project status is created then it will update to In process stage. Same way you can try as per your requirement. Projtable projTable; int cnt; ttsBegin; while select forUpdate projtable where projTable.Status==ProjStatus::Created { cnt++; projtable.Status=ProjStatus::InProcess; projtable.update(); } ttsCommit; info(strFmt("%1 Project Updated",cnt));

This is Update and Update_RecordSet Code sample. Result of both will be same . TestTable TestTable; //Update_Recordset update_recordset TestTable setting Name ="New Enterprises" where TestTable.Accountnum =="uS-027"; //Update ttsBegin; while select forupdate TestTable where TestTable.Accountnum =="uS-027" { TestTable.Name ="New Enterprises"; TestTable.update(); } ttsCommit; info("OK");

• Uses a single database architecture for all companies in the organization. • Provides a highly integrated design between functional areas such as resource planning, sales, and manufacturing. • Dimension-based system for manufacturing and financial modules. • Advanced features such as Forecasting and Master Planning are available. • Provides multi currency and multi language capabilities. • The .NET Business Connector provides access to the complete Microsoft Dynamics AX application interface that makes it easy for the integration of third-party and Web applications.