Database Maintenance Strategies with Microsoft Dynamics AX AX utilizes SQL Indexes in order to speed up queries to the database. It is important that any index created is analyzed for its usage pattern; for example, will the query only be made once per day, or thousands of times in a loop? It might...

[Updated for SQL Server 2012 and SharePoint 2013] When reviewing the Dynamics AX environment on customer site, we are often been asked question such as: “Do you know if this version of the product is officially supported by Microsoft”? This is quite natural because Microsoft products...

Dynamics Ax 2009 Retail Error messages & Possible resolutions: Error Code Title Error Description Possible Resolution 0 Error on sending request The distribution server for the location has not been specified in Retail...

I was recently working with an AX 2009 customer who wanted to compare the user accounts configured in AX with the user accounts in Active Directory. The basic goals were: Find all AX user accounts that no longer exist in Active Directory. Find all accounts that are disabled in Active Directory...

I've been questioned several times recently about AOS load balancing in Dynamics AX, and there seems to be quite a bit of confusion about how to properly configure AX for AOS load balancing, as well as high availability. Here are a few clarifications that apply to Dynamics AX version 4.0, AX 2009 and...

Back in November 2010 I talked about four SQL Server trace flags that I found to be helpful in improving performance for Dynamics AX. http://blogs.msdn.com/b/axinthefield/archive/2010/11/04/sql-server-trace-flags-for-dynamics-ax.aspx . One of the trace flags I mentioned was 1224. This is the one...

Summary: If you are in a situation where you have created your AX security settings on another AX instance and you now need to move them to your production server, below are a few options for how to accomplish this. Assumptions: This is a one-time transfer from the STAGING server to the...

Summary To properly test your xml documents for use with the Application Integration Framework (AIF) in AX 2009, it is best to use the File Adapter as it is easy to set up. You can use any Adapter for when you go-live. It is important to understand how the AIF file adapter security authorization...

Multiple AX 2009 Deployments versus a Single Deployment Dynamics AX2009 has the capability to run a single deployment supporting multiple companies within the same database. There are some considerations when deciding whether to have a single deployment of AX2009 or multiple deployments for each of...

Are you pushing a lot of transactions through the AX batch framework? Are you wondering if you've optimized the system for your workload? We recently did some testing in our lab to illustrate some of the performance and concurrency characteristics of the AX 2009 batch framework. Our goal was to show...

Please find the Part1 here . III) Perform a Consolidation: Options to perform consolidation: From the same database using the online option From and, or to another database using the Import/Export option Before you perform a consolidation at the close of a period, ensure that the...

Financial Consolidations process: 3 steps to perform consolidation in Microsoft Dynamics Ax 2009. I ) Consolidation company setup II) Subsidiary company setup III) Perform consolidation I) Consolidation company setup: Consolidation company creation: Consolidation designated company...

The Database Sychronization process within AX 2009 sychronizes the table information to the database by creating all the tables and indexes it needs to operate. This synchronization is necessary when there are schema changes in the Application Object Tree (AOT) and must be populated to the database....

When working with customers I have encountered many scenarios where the User in which they are trying to setup security permissions belonged to multiple User groups or had different permission sets in different Domains. Permissions are compared between User groups and Domains using the least restricive...

XBRL : eXtensible Business Reporting Language (XBRL) (Global Financial Reporting initiative) Reporting: Financial statements, information, non-financials information and regulatory filings. Use the XBRL feature in Microsoft Dynamics AX 2009 to: Import taxonomies Convert taxonomies into...

Automatic transactions in AX 2009: System Accounts Systems accounts are used for automatic transactions in Dynamics Ax. In the systems account form we add various automatic accounts on the basis of posting types. The following transaction types can be posted in case setup is missing. Path: Dynamics...

The Application Integration Framework (AIF) uses a set of services to asynchronously process inbound and outbound documents: AifGatewayReceiveService - Communicates with the file or msmq adapter and receives messages from an inbound location (e.g., Inbound folder) and bringing them into the AIF...

Number sequences handle automatic allocation of voucher numbers, invoice numbers, and journal numbers used by Microsoft Dynamics AX. You can set the allocation to be Continuous, or Preallocate a block of numbers. When using Continuous, gaps are not allowed, so a trip to the database is needed to get...

We're less than four weeks away from Convergence 2011 - it is coming up quick. Convergence 2011 will be held in Atlanta this year at the Atlanta Convention Center from Sun, April 10- Wed, April 13. Dynamics AX will be featured in well over 70 sessions covering topics across AX 2009 and the forthcoming...