Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Default descriptions Key4 – Key6 definitions

I’ve seen a few requests asking to provide a list of all transaction types and the correlating key definitions that can be used to default text of the accounting entries in the general ledger. I’ve made a research looking at the cross-references of the TransactionTxt class and here’s what I’ve got. Standard AX normally populates the… Read more

Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,… Read more

Microsoft Dynamics AX (7) Power BI financial pack shows only zeros

We have a situation when Microsoft Dynamics AX Power BI financial pack on all the reports shows zero. The account structure, fiscal year and all other data was imported correctly but the transactions were always showing zero. This due to configuration in Dynamics AX you need setup value for System currency and exchange rate type… Read more

Clustered SQL Server instance – Example AX TEST environment configuration concepts and points of interest

Consider a scenario where you are running AX 2012 and your Dynamics AX databases are hosted on a Clustered SQL Server instance. I’ll discuss some concepts and points of interest below which are relevant when running AX 2012 RTM, R2 or R3. The screenshots are from a VM TEST environment with CONTOSO DEMO DATA that is… Read more

How to use DIXF to import an Inventory counting journal into AX 2012 from an Excel source file

I have recently worked with customers whom are using DIXF to import Inventory counting journals into AX 2012 as part of their monthly Inventory counts. As a result of this, I documented an example of how you can use DIXF to import an Inventory counting journal into AX 2012. NOTE:  In this example, the items… Read more

How to configure Bulk items into a Formula for a Packed Item and have MRP generate Planned orders for both

I’ve recently worked with customers whom are attempting to create Bulk item conversions into the Formula configuration for a Packed Item and have MRP have the capability to generate Planned Orders for both the Pack and the Bulk Item. As a result of this, I’ve documented the overall setup\configuration, as an example, in order to… Read more

Serialising containers in X++

A problem I’ve hit a few times during troubleshooting is transferring containers from one environment to another. Importing a whole 100GB database to be able to access the results of a report packed into a 20MB container seems like a bit of an overkill. So, a natural idea would be to save the container to… Read more

Check AOS event logs and SQL Server error logs for key messages using DynamicsPerf

As part of general monitoring of Dynamics AX overall system health and/or troubleshooting, you’ll want to check the Windows event logs in your AOS server(s) and SQL Server error logs. If you have DynamicsPerf (Performance Analyzer for Microsoft Dynamics) installed, you can quickly check for key messages and if necessary, export and move them all… Read more

Microsoft Dynamics AX (7) error when running bank reconciliation

You can get error “Cannot create a record in Open bank document (BankReconciliationDocumentOpenTmp). The record already exists” while running advanced bank reconciliation journal on Microsoft Dynamics AX (7). To fix this error you need to install application hotfix KB3170675… Read more