Do you need the accrued purchases report in a UK localization in Dynamics AX 2012?

Hi Everyone, Recently I was asked by a customer to look into a securityissue around one of their reports in Dynamics AX 2012 R2.  Users were reporting that some people withinthe customer organization had access to the accrued purchases report and somedid not. After reviewing the security we found that the user that hadaccess to…


Dynamics AX and little Orphaned SPID Annie

  One of the top questions I am asked by customers when I am on site is what causes AX Orphaned SPIDS and what to do with them and how to identify them.  As we know Orphaned SPIDS can cause blocking which lead to end user frustration.  They are usually caused by users not exiting…

2

SQL Server Parameter Sniffing with Dynamics AX, just plain evil

I do not want to write a novel or a technical manual on Dynamics AX and SQL Server Parameter Sniffing and the problems it causes so I try and keep this as short as possible. When Dynamics AX X++ code in converted in TSQL cursors it is usually in the form of a SQL Statement…

21

Announcing RAP as a Service for Dynamics AX

I am pleased to announce the General Availability of RAP as a Service for Dynamics AX.  This Microsoft Premier Service takes our existing Health Check to the next level with on-demand data collection and analysis to give you the flexibility to check and re-check the state of your system whenever you want as many times…


Dynamics AX is crashing what should I do? VIDEO

If your Microsoft Dynamics AX application ever crashes then you should know what troubleshooting steps to take to find out why this exception has occurred. Please see the attached videos recorded by one of our Escalation Engineer’s from the Support team.   The first video includes information about; What is a crash? The second video includes information…


Dynamics AX 2012 Cumulative Update 7 (CU7) is now released!

In case you missed it, I’m happy to relay we recently released Dynamics AX 2012 R2 Cumulative Update 7! CU7 includes enhancements to several modules or feature areas, including the highly anticipated Data import, export, migration improvements, and integration with Lifecycle services. AX 2012 R2 CU7 is posted as KB number 2885603, build number 6.2.1000.4051….

5

Critical issue in SQL Server 2012 Service Pack 1 that could crash your SQL server

There is a known issue with SQL Server 2012 Service Pack 1 that everyone should be aware of.  If you have installed Service Pack 1 not part of a slipstream install, the registry on your SQL server could reach the 2GB limit and crash your SQL Server.  To avoid this issue for Dynamics products it…

1

Improve performance of your external applications querying Dynamics AX

Are you having performance issues with some of your external applications extracting data from Dynamics AX?   There are some rules in writing queries for Dynamics AX that you need to be aware.  These rules are implemented in Dynamics AX by the kernel when it executes queries against your SQL Server database.  The rule is…


Improving performance in the DynamicsPerf benchmark sample queries

In Performance Analyzer for Microsoft Dynamics, we a script called 7-Benchmark Queries.  The first set of sample queries in this script helps you answer the questions “What change?”.  It does this by showing you the hourly difference in row counts on your tables.    As part of developing our next version of Performance Analyzer for…


Management Reporter 2012 CU7 Release Review

Management Reporter 2012 CU7 is now available. This release, which has been posted for download, includes the ability to drill back to Dynamics from the Management Reporter Web Viewer, currency translation for Dynamics AX 2012 customers, plus a few more enhancements. Here’s a summary of the new Management Reporter CU7 features: Ability to drill back…

1

Management Reporter 2012 Introduction + CU6 Release Review

It has come to my attention that Microsoft will be deprecating financial statement report design functionality/features from future releases of Dynamics AX and relying more on Management Reporter 2012 to replace these deprecations that currently reside in the General ledger module of Dynamics AX.  Microsoft is moving quickly on their initiative to establish Management Reporter…


What is my data distribution by company(PARTITON and or DATAAREAID) for a specific Dynamics AX table?

  If you have ever asked yourself the question “What is my data distribution by company(PARTITION an or DATAAREAID) for a specific Dynamics AX table?”, wonder no longer.  Attached is a TSQL Stored Procedure you can add to your Dynamics AX database (4.0, 2009, 2012, 2012 R2…) and then run it against any table in…

4

Benchmark your Dynamics AX solution with Load Testing

One of the most crucial time when implementing your Dynamics AX solution is the few weeks prior the Go Live. At that stage, the infrastructure has been configured with all components and all settings have been reviewed to match best practices. The functional team is running all test cases to sign off all design changes…


SQL Server Trace Flag 2371 for Dynamics AX

In my travels around the country from one Dynamics AX customer to another the customer is usually aware of how important database Statistics are to the overall performance of Dynamics AX.  The one thing I do not find though is Trace Flag 2371 enabled (or even know that it exists) or an in-depth understanding of…

5

Dynamics AX, Index Fragmentation, and You.

I have been onsite at a lot of Customers who believe that Index Fragmentation is major influence on overall Performance for Dynamics AX.  I actually have a hard time convincing them that its impact is relatively low on overall performance.  They also raise the issue that they can no longer fit their re-index job into…

3

AX ERD site for AX 2012 R2 is here!!

Hi Everyone – I wanted to put this site out on the blog for everyone who is not yet familiar with it.  As we all know there were a lot a table structure changes to AX 2012 from AX 2009. I hope that the ERD diagrams on this site will help us all navigate the…


Payroll for Dynamics AX: Enabling Tax Engine Debugging

The Tax Engine for Payroll for Dynamics AX has a logging capability for debugging that is very helpful for debugging tax issues and seeing specifically what Dynamics AX is sending into the tax engine. The logging capability allows you to debug what values are being sent to the tax engine, what calls are being made,…

1

Payroll for Dynamics AX: New Tax Updates available (2013)

New tax updates for Payroll for Dynamics AX are available for download. Find the latest updates at the links below. Enjoy! Microsoft Dynamics AX 2012 US Payroll The AX 2012 Payroll tax update 2013-R11 contains the updated tax engine. AX 2012 Payroll tax update 2013-R11 now available (KB2872380) – PartnerSource AX 2012 Payroll tax update 2013-R11…


Top 10 issues discovered from Dynamics AX Health Check

The Premier Field Engineer team has been running several hundred of Dynamics AX Health Check worldwide and I thought it would be interested to share the most common issues discovered during onsite. Some of the following issues might look trivial but the reality is that despite all the literature that exists today on the solution…


Do not assume, Benchmark your X++ code

Some might argue Dynamics AX is an opened source ERP. With the developer license, you can see the whole stack of Microsoft code (SYS and SYP layers), and you can overwrite its core business logic to match your specific needs (VAR or CUS layers). That flexibility is maybe the number one strength of the product,…


Performance Analyzer 1.16 for Microsoft Dynamics IS HERE !!

You can download the latest release of Performance Analyzer 1.16 for Microsoft Dynamics at the following:  http://dynamicsperf.codeplex.com.   This release officially supports SQL Server 2012 and all currently released Dynamics Products.  There have been several performance improvements incorporated into this version especially around analyzing QUERY data.  For the operational staff, we have enhanced the QUICK…

5

Dynamics AX 2012 and SQL Server 2012 AlwaysOn Availability Groups

When setting up Microsoft SQL Server 2012 AlwaysOn Availability Groups with Microsoft Dynamics AX 2012 you may run into an issue when attempt to enable the “Partial Containment” option on the Dynamics AX production database, which is a pre-requisite for AlwaysOn. Written by Michael DeVoe When you attempt to enable “Partial Containment” on the Dynamics…


Lean Manufacturing in Dynamics AX 2012

I recently spent some time digging into Lean Manufacturing in AX 2012, so I thought I’d post a few notes and some information about lean concepts in AX 2012. Overall, I think it looks great and appears to work well in mixed mode. You can use lean kanbans and production orders even within the same…

4

Database Maintenance Strategies for Dynamics AX

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 not be…

5

The Microsoft Dynamics AX Technical Conference 2012 is coming soon!

We’re getting close to the launch of Microsoft Dynamics AX 2012 R2 and the opportunity to learn all about it (and AX in general) at the Microsoft Dynamics AX Technical Conference 2012.  This year’s event will be held in Bellevue (Seattle), WA where you’ll have access to the best and brightest minds on AX.  The…


Compatibility Testing for Microsoft Dynamics AX

[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 don’t have the exact roadmap and General Availability…


Dynamics Ax 2009 Retail Error Messages & Possible resolutions

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 Scheduler. Modify the location by specifying the distribution server for the location (Retail scheduler >  Common forms > Locations). 4096       …


Comparing AX and Active Directory User Accounts

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 but not in AX….

3

Are your AX 2012 AOS servers load balancing?

If you’re familiar with how AX 2009 load balancing works, you might get caught off guard when you find out that standard AX 2012 AOS clustering only load balances some of the communication to your AOS servers. The rest may only be going to a single server without you knowing about it. If that’s the…

2

Dynamics AX 2012 Links & Info

Our team has been getting lots of questions on all facets of Microsoft Dynamics AX 2012 – we’ve certainly seen a ton of interest from customers and partners in the new release.  There is a lot of great info available about the release, but this is my effort to try to tie some of that…


Performance Analyzer Reports

We’re excited to introduce the next evolution with our Performance Analyzer for Microsoft Dynamics toolset.  We’ll review the concepts today at Convergence at the Performance Analyzer for Microsoft Dynamics session at 5pm in the Hilton Ballroom B on the 2nd floor.  In this post, we’ll list the reports that are included in the attached zip…

1

AXUG Roundup – January in Minneapolis

Rod Hansen and I headed south to Minneapolis (yes, everything is south of Fargo) to join the Minnesota chapter of AXUG for dinner and a discussion on the Performance Analyzer tool.  The Minnesota chapter is very well attended and we had a good turnout for this meeting – about 20 folks there in total.  Ben Syltie…

1

AOS Load Balancing

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 AX 2012:…

3

Update on determining Disk Latencies with Performance Analyzer for Microsoft Dynamics

In my previous blog about Determining Disk Latency with Performance Analyzer for Microsoft Dynamics, I spoke of how to determine the disk latency.  In testing, we have determined that the computed latency from sys.dm_virtual_io_file_stats does not match Windows Performance Monitor Avg. Disk Sec/Read and Avg. Disk Sec/Write. There are many technical details around why the…


New DMVs in SQL Server 2008 R2 SP1 and SQL 2012 (‘Denali’) and Performance Analyzer for Microsoft Dynamics

One of the new features in Performance Analyzer 1.10 for Microsoft Dynamics is support for new DMVs in SQL 2008 R2 SP1 and SQL 2012. In this blog, we’ll explain what the new DMVs are and how they are used in analysis of performance issues in Microsoft Dynamics deployments.   New DMVs: sys.dm_os_windows_info                 This…

2

Performance Analyzer 1.10 for Microsoft Dynamics

We would like to announce the release of Performance Analyzer 1.10 for Microsoft Dynamics.  This new and exciting release has a long list of new features: Peformance Analyzer 1.10  NOTE: SQL Server 2008 and above only for this version. ·         An hourly capture of data that shows your transaction volume per table per hour ·        …

4

Consulting Corner: Customer Tasks before the Consultants Arrive.

Customers planning to implement Dynamics AX can save time and money on an implementation by pursuing a number of before implementation tasks. Create an IT Steering Committee if one does not exist. Designate a team of Subject Matter Experts (SME) from each major functional area (e.g. AP, AR, GL, Inventory, Production, etc.). Refer to Microsoft…


Top 5 Cases for Remote Service Delivery

Our Premier Field Engineers travel a lot.  When customers need assistance during deployments or need a workshop or want to make sure their team is up to speed on what we’re delivering, they request us to be onsite and we come on out.  The opportunity to be out working directly at the customer site greatly…


Dynamics AX Premier Field Engineering Team Is Hiring

If you’ve read some of my latest posts, you already know what we look for in Premier Field Engineers, and you even know the questions you’ll get asked and how to answer them.  (OK – we might have to change up the questions a little bit.  If I notice you reading off the answers during…