Learn Dynamics 365 Finance and Operations(Axapta)

How to delete all transactions from AX 2012. Previously we were using SysDatabaseTransDelete class to do the same but as of now we need to modify that class to work properly with AX 2012 due to DB changes : We need to modify the SysDatabaseTransDelete.handletable method with the below code : void handleTable(SysDictTable sysDictTable) {     TableGroup      tableGroup;     if (tableSet.in(sysDictTable.id()))         return;     tableSet.add(sysDictTable.id());     if (sysDictTable && !sysDictTable.isTmp() && !sysDictTable.isMap())     {         tableGroup = sysDictTable.tableGroup();         // Handle company specific tables to be deleted         if (sysDictTable.dataPrCompany())         {             switch(tableGroup)             {                 case TableGroup::Transaction:                 case TableGroup::WorksheetHeader:                 case TableGroup::WorksheetLine:                 //FIX - Support new AX2012 transaction table types

Self diagnostics   this Script will check if all tables have  Primary index  Cluster index Caching //NOTE: temp tables are skipped static void TableTuningTest(Args _args) {     boolean         skipEmptyTables = true;     boolean         result;     treeNode        treeNode;     SysDictTable    sdt;     str             TableAndCound;     int             recordCount;     boolean         skipEmptyrecordCount = false;     treeNodeIterator treeNodeIterator =TreeNode::findNode("\\Data Dictionary\\Tables").AOTiterator();     ;     treeNode = treeNodeIterator.next();     setPrefix("Tuning");     while (treeNode)     {         sdt  = new SysDictTable(tablename2id(treeNode.AOTname()));         recordCount = sdt.recordCount();            if(!sdt.isTmp() && (!skipEmptyTables || (recordCount != 0))  )         {             TableAndCound = treeNode.AOTname()+ ' ('+ int2str(sdt.recordCount())+')';             setPrefix(TableAndCou

http://schunk.dk/DocWeb2009/class%20index.html

Installing AX 2009 Reporting Extensions in MSSQL 2008 & WIN 2008 When we try to install AX 2009 SP1 Reporting Services on a PC running SQL 2008, we get an error saying that MSSQL 2005 SP2 is required. Well there is a solution to this issue which is as follows: 1. Locate the AX Reporting services dll from the extracted AX 2009 SP1 folder [\\AX2009SP1\support\axsetupresources\microsoft.dynamics.setup.reportingservices.dll;File Version - 5.0.1000.52] 2. Copy the microsoft.dynamics.setup.reportingservices.dll into the folder: \\DynamicsAX\Msi\Components32\Program Files\Microsoft Dynamics AX\50\Setup [since my system is 32-bit so Components32] 3. It will ask to replace the existing dll having File Version - 5.0.593.0. Say Yes and replace. Now, carry on with the installation process.