Friday, 9 May 2014 Dynamics performance very slow in AX 2009 1. sql server activity monitor, kill all suspending transactions. 2. Go to the Administrations->Periodic->sql administration -index actions->press re-index for all tables 3. Administrations->Periodic->sql administration -table actions->Synchronize your database 4. restart all the servers like: application server, database server, etc, hope it will increase performance . http://blogs.msdn.com/b/axperf/archive/2008/03/13/ax-database-configuration-checklist-part-2.aspx
Posts
Developing a SSRS report using the Report Data Provider in Microsoft Dynamics AX 2012 Overview There are multiple methods to develop SSRS reports in Microsoft Dynamics AX 2012. This tutorial will guide you in developing Report Data Provider (RDP) based SSRS reports. RDP based SSRS Reports are used when complex business logic cannot be achieved using AOT query. Pre-requisites Microsoft Dynamics AX 2012 Visual studio 2012 SQL Server Reporting Services (SSRS) must be configured Reporting services extensions must be installed in Dynamics AX Important Concepts Report Data Provider (RDP) Class Report Data Provider Class is an X++ class that is used to access and process data for a SSRS report. The RDP class processes the business logic based on a specified parameter and/or query and returns a dataset to the reporting services. In order to create a RDP class in AX, you have to extend that class with SRSReportDataProviderBase . This tells AX that this class wil...
Exploring SysQuery class SysQuery is a helper class provided by Microsoft for working with queries dynamically. It has all its methods set as ‘static.’ It provides numerous functionalities that allow one to add data source in a query, add range, apply sort, etc. in a user-friendly system. This article will provide demonstrations for the most commonly used methods from SysQuery: findOrCreateDataSource() FindOrCreate is mainly used to check whether or not the query already contains the data source. If it does not, a data source will be created. FindOrCreate is most efficient when an event developer must write a code in which the event must be fired multiple times. This function allows developers to prevent adding additional elements to data sources. This is the most common situation in which findOrCreateDatasource() is used to avoid multiple addition of data sources in a query. Because this method is static, it uses Query as the first parameter. The next parameter w...
Understanding the Settlement Mechanism in Microsoft Dynamics AX Settlement is an accounting transaction that occurs on accounts payable, accounts receivables, and general ledger. This transaction is used mainly for settling vendor invoices against vendor payments or advanced payment, and customer invoices against customer collections or advanced collection. Settlement could occur on general ledger transactions as well. It is necessary to classify posting profiles of the vendor and customer in the opening balance since it will affect the settlement process. The settlement transaction affects vendor and customer balances, and it is reported in the vendor or customer statement
Few of the table name changes in ax 2009 to ax 2012 InventSize : EcoResSize, EcoResProductMasterSize InventColor : EcoResColor, EcoResProductMasterColor ConfigTable : EcoResConfiguration, EcoResProductMasterConfiguration, InventDim (InventColorId, InventSizeId, ConfigIdfields) : EcoResProductDimensionAttribute InventDimCombination : EcoResProductVariantSize , EcoResProductVariantColor, EcoResProductVariantConfiguratio LedgerTable and LedgerTrans table name changes in ax 2012 LedgerTable To MainAccounts in ax 2012 LedgerTrans to...
How to import Contoso Demo Data to Dynamics Ax 2012 R3. The setup contoso demo data for Dynamics Ax 2012 R3 is different from previous version. I remember, I used .dat file to load demo data into Dynamics Ax 2012 R2. Now DynamicsAX2012R3DemoData.exe available partner Resource. DynamicsAX2012R3DemoData.exe extracted files round 15 GB. Extracted folder contains three types of files. According to MSDN Xml (A bcp data file that contains table data. Columns are separated by #|EOC|#. Rows are separated by #|EOR|#\n.) Out (A bcp data file that contains the table metadata (column descriptions). OutModel (This metadata includes all names and IDs of the table and its fields. This file also includes the elementType attribute, which stores the names and IDs of any Microsoft Dynamics AX tables, classes, or extended data types that are referenced by the table) Installation of Test Data Transfer Tool: The MSDN Described The Import export with Test Data Transfer Tool (beta) as follow...
Dynamics Ax 2012 R3 Cu8 demo data download link Demo data file for Dynamics Ax 2012 R3 CU8 is available for download. You can download it from following link https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials To log on here you must have partner source or customer source credentials.
Test Data Transfer Tool (beta) (AX 2012) The Microsoft Dynamics AX 2012 Test Data Transfer Tool (beta) (DP.exe) is a command-line tool that exports data from a Microsoft Dynamics AX 2012 business database in a production or non-production environment. The tool also imports data into a Microsoft Dynamics AX 2012 business database in a non-production environment. The non-production environment can be either a development or test environment. Table of Contents Benefits Limitations Who should use this tool Personally identifiable information The Test Data Transfer Tool (beta) has been moved. It is now available from the Downloadable tools section of Microsoft Dynamics Lifecycle Services. Go to Lifecycle Services . Note: Microsoft does not support using the Test Data Transfer Tool (beta) to import data into a production environment. The tool can be used only to export data from a production environment, and to import data into a test or development environment. The T...