Menu

Public Displays of AX: Why ERP and the Public Sector Are A Perfect Match

Public Displays of AX: Why ERP and the Public Sector Are A Perfect Match Public sector entities are often thought of in completely separate terms than private ones. And rightly so, when we think in terms of who owns them, who they answer to, and how they’re funded. But when one strips away the trading […]

Serializing Financial Dimensions in Microsoft Dynamics AX 2012- Default Dimensions

This article will cover advanced x++ to show how developers can serialize financial dimensions to create a default dimension surrogate key from a series of financial dimensions. In Microsoft Dynamics AX 2012 the financial dimensions are stored as a 64bit integer surrogate key in the database. For example, the following financial dimension combination of BusinessUnit = 001, […]

Deserializing Financial Dimensions in Microsoft Dynamics AX 2012

Deserializing Financial Dimensions in Microsoft Dynamics AX 2012 Financial dimensions are stored as a 64bit integer surrogate key in the database. It may be necessary to extract this information to understand the financial dimensions that this surrogate key represents. For example, a custom BI solution, report or integration may require that this surrogate key be […]

Address Validation in Dynamics AX- QUAAX

I wanted to talk about a new product for address validation and discovery in AX called QuAAX (Quality Addressing for AX), powered by Experian Data Quality. It’s more than a simple “is this address valid or not” type of program and allows for address discovery, quick entry, and some fuzzy operations.  It also works internationally […]

Managing ISV Model or Hotfix Installation Errors in Dynamics AX 2012

Scenario: Your system is on a build which is incompatible with some code delivered by an ISV, or a hotfix from Microsoft. Upon installing the model using the Dynamics AX 2012 Management Shell, you may encounter the following error: “One or more conflicting model elements already exists in an installed model” The steps in this post […]

Quick Guide Dynamics AX 2012 Dta Layer Decimal Precision

We all know that Dynamics AX 2012 uses Microsoft SQL Server as its database backend, but how does AX handle decimal-based data types in the data layer? In this blog, we will be going into detail on how AX handles Real based Extended Data Types, how that data is saved in SQL, as well as […]

Key Benefits of Replacement and Surrogate Keys

Microsoft Dynamics® AX 2012 introduced the concept of surrogate keys and replacement keys to make life easier on the back-end database and the users responsible for creating forms. This blog post will define each of those terms as well as define the Auto Identification field group and reference groups. This blog post will also explain how […]

Dynamics AX Data Migration Importing Numerical Values from Text Files

During data migration you may have to import data from legacy systems that output data in a text or CSV file. This data may need special formatting so that the data can be properly read by Dynamics AX. This is especially true when importing numerical values from a text file. For Example, the value ’34,203.00’ […]

Querying Date Effective Tables in Microsoft Dynamics AX 2012

In Microsoft Dynamics AX 2012, valid time state tables (date effective tables) were introduced to help organizations keep track of data that changes over time. For example, currency exchange rates change over time and it is necessary to view exchange rate data at a specific point in time. For this blog, the exchange rate table […]