Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

This blog is intended for Axapta technical Consulatant and Retail Professionals. Just visit link below to get many posts on Retail Troubleshootings , problems and solution.   http://axretail.blogspot.com   What's New in Microsoft Dynamics AX 2012 Feature Pack for Retail                   http://www.microsoft.com/en-in/download/details.aspx?id=28780

To Delete duplicate records  from salesTable or any other table through ax 2012 by x++ code you can write code in Ax job. Set fieldSet = new set(Types::Integer); DictIndex IndexName = new DictIndex( tablenum(SalesTable), indexnum(SalesTable,SalesIdx)); int i; ; if(IndexName.numberOfFields()) { for(i=1;i<=IndexName.numberOfFields();i++) { fieldSet.add(IndexName.field(i)); } ReleaseUpdateDB::indexAllowDup(IndexName); ReleaseUpdateDB::deleteDuplicatesUsingIds(tablenum(SalesTable),0, fieldSet); ReleaseUpdateDB::indexAllowNoDup(IndexName); } info("Duplicate records deleted successfully");

For Calling a SSRS Report from x++ in Ax 2012 you can try following code hints. You can use SrsReportRunController  class to call SSRS Report. SrsReportRunController controller; controller = new SrsReportRunController(); controller.parmReportName(ssrsReportStr(TestReport, Detail)); controller.startOperation();

To set Alert in Ax 2012 its easy. You can visit following link to get step by step details. http://daxing2012.wordpress.com/2012/11/19/alerts-in-ax2012/  

I want to share a link to get details about Data Export Import using Excel Add-in in Dynamics AX 2012 . http://ax2012exceldataimport.blogspot.in/

To Display query which are currently exceuting from form datasource in Axapta. You just need to user toString method with Querybuilddatasource clase object, Query q; QueryBuildDataSource qbds; ; q = this.query(); qbds = q.dataSourceName("CustTable"); strfmt("%1", qbds.toString());   

This UI Builder class is a class help you to customize your dialog which pop ups when you open a Report. UI Builder Class also  helps you to add run time lookups and other controls like combobox,textbox,checkboxes etc on the dialog form. I want to share import Link for Simple UI Builder Class in SSRS Report in AX 2012 . http://kdynamics.blogspot.in/2013/09/simple-ui-builder-class-in-ssrs-report.html