Microsoft Dynamics AX Support

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

Microsoft Dynamics AX 2012: How to set up Grid column width on fixed value

In Microsoft Dynamics AX 2012 the width property set up on column is ignored when is lower than length of label. The issue in this case is the length of the label. You cannot set a default column width that is smaller than the label. This is because labels are different lengths in different languages,… Read more

AX 2012: Enabling Allow Check Reuse for Canadian Environments

Per TechNet article (CAN, USA) Reuse a check number [AX 2012] environments that are on AX 2012 with the Feature Pack have the ability to enable the Allow Check Reuse feature in Cash and Bank Management Parameter for US and Canadian Companies. I wanted to provide information that will allow you to enable the Allow Check Reuse… Read more

AX 2012 Database: How to enable SQL compression (Enterprise edition)

Description: We now fully support database compression from within the AX system. If you are running Enterprise Edition, you can apply compression, which will save you Storage Space and decrease time for backup and restore. Read about the feature in the links section below.    How to: The form SysSQLSetup is used to set the… Read more

How to perform foreign currency revaluation in Consolidation company to satisfy reporting requirements

This scenario covers entering a transaction in a subsidiary company with an accounting currency of USD and then consolidating to a consolidation company having EUR for accounting currency.  In this scenario there is a balance sheet account that has been consolidated, followed by two currency revaluations to demonstrate the impact. (NOTE:  The scenario can be reversed as… Read more

Answers to common questions about moving average costing in Microsoft Dynamics AX 2012

The moving average inventory valuation method has been added to Microsoft Dynamics AX 2012. This method of inventory valuation is often used by retailers and wholesale distributors. A fourth product/item dimension (style) has been added to better enable Stock Keeping Unit (SKU) support across Microsoft Dynamics AX.Additionally, support for high volume sales processing has been… Read more

Changing the Background Color on AX Forms in AX 2012

I recently wrote some additions to a nice little utility that changes the background color in forms.  For each company you can set the background color to a different color of your liking.  The color serves as a visual reminder of which company you are currently logged into.  Enjoy!   Addendum:  I just added a… Read more

Setup principals for processing pallets in Microsoft Dynamics AX 2012

Setup principals for processing pallets in Microsoft Dynamics AX   So the scenario might be that in your warehouse you want to receive pallets of items using the arrival overview and arrival journals.  Here are some principals to remember when setting up and processing.   1.      You need to enable the pallet dimension on the… Read more

White Paper on Common Upgrade Performance Tips

*** Author note *** As is mentioned in the Whitepaper itself, much of the information in the document does NOT apply to upgrading to Dynamics AX 2012 R2 and beyond. For example, if you disable the updateGABDateTimeFields method in Dynamics AX 2012 R2, because of the changes to the script itself and the R2 table… Read more

AX2012 List Pages – Performance Improvement

I’ve been working on some performance issues recently, and some of these were related to list page performance in AX 2012. The problem is that for some of the list pages, even with CU3, the main query performance is slow due to the fact that the query parameter OPTION(FAST) is not being added automatically to… Read more

The Report Server Configuration ID could not be found in the SRSServers table

When attempting to run a report in Microsoft Dynamics AX 2012 you might run into an error that says ‘ ‘The default Report Server Configuration ID could not be found in the SRSServers table.’   If you are faced with this error, try to go to System administration> Setup> Business intelligence> Reporting services> Report servers>… Read more