Microsoft Dynamics AX Support

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

Prerequisites to allow cancelling a packing slip for WHS items

We’re very happy to announce that in AX 2012 R3 CU12 you are now able to reverse loads, cancel packing slip updates for sales orders and product receipts for purchase orders. This means you are now able to reverse the loads even when these updates have been done. This change will come through KB 3196554… Read more

How to set email notification for Workflow in Dynamics 365 for Operation

The emails notification will not be send if email template will not be set up on the workflow configuration: Depend on if the workflow is global or company related there are different ways you need to set it up: For the company related workflow you need to set it up in:  Organization administration > Setup… Read more

Dynamics 365 for Operations – Import Bank Statement using BAI2 format

***[BRIEF DESCRIPTION] *** Import Bank statement for multiple bank using BAI2 format. 1. Login to Visual studio to download following files and save them in local drive: 2. Set up BAI2 bank statements format from System administration > Data management 3. Create Bank statement format from Cash and bank management > Setup > Advanced bank… Read more

Financial dimensions that contain the same character as used in the chart of accounts delimiter

In Dynamics 365 Operations (AX7) if a financial dimension contains the same character as the chart of accounts delimiter you may experience some instability. The Chart of Accounts delimiter is set on the general ledger parameters and once this is setup the field is greyed out. (Previously this field was located in the system parameters)… Read more

Deal with Dynamics Deployment Services [wsfed-enabled]

Issue background Sometimes when we use organization account(o365 type) to log on to LCS in order to deploy AX7 VM to Azure, we want to deploy VM to an Azure subscription which is a Microsoft account (hotmail) or live id, other than the organization account. We’ll run into below issue symptoms and cannot proceed with… Read more

SSRS Report label shown as @SYSxxxx in AX2012

Here in this blog I will share two scenarios when this happening and basic troubleshooting steps when facing this issue. Issue: When you are rendering SSRS report, the data will load correctly, but all AX labels are not resolved: Two known causes of this: SQL Server Reporting service version does not meet AX requirement. You… 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

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