Browse by Tags

Related Posts
  • Blog Post: Product attributes and beyond [AX 2012]

    Product attributes is a great piece of functionality that was introduced in AX 2012. It allows you to set up and capture additional information against a product. I recently have taken it one step further to make it more visible and user friendly. At the moment it is hidden away on a form you have to...
  • Blog Post: Delete Private AOT projects in AX 2012

    This is a common problem since the old days. People leave projects in their private project and no one can get to it to clean it up. In pre AX2012, it was a matter of selecting the utilElements and calling the AOTDelete method. I won’t go through it here. In AX2012, it is all maintained in the model...
  • Blog Post: SRS report does not reflect the new query changes – cache issue [AX 2012]

    In some scenarios you may see that your query changes doe not reflect in the report. This is due to some caching that is done. The obvious thing is to delete the AUC files and clear out your data usage. But there is a new table that we need to be aware of in this scenario. Navigate to the AOT and delete...
  • Blog Post: Modify Microsoft Dynamics AX 2012 R2 SSRS configurations

    Last year I had posted some powershell scripts to update the config files when installing multiple instances. I have update the scripts today to be compatible with R2. As usual, open up the scripts in notepad or powershell editor. Change the path of the instance and now there is a version number. For...
  • Blog Post: How to: Add a Drill Through Action on a Report [AX 2012]

    MSDN does document how to add a drill through action on a report. http://msdn.microsoft.com/EN-US/library/cc582049.aspx However I feel it is quite invasive and it could be done a lot cleaner without touching too many standard objects. Open up the SRSDrillThroughCommon class. Change the method GetDrillThroughUrl...
  • Blog Post: SSRS built in methods [AX 2012]

    This post is just as a reminder to the msdn links and for those that are not aware. There are a number of built in methods that can be used on SSRS reports. Such things as formatting numbers, getting current user etc. http://msdn.microsoft.com/en-us/library/ee874032.aspx http://msdn.microsoft.com/en...
  • Blog Post: ERROR: The model file MyModel.axmodel is from a newer version of Microsoft Dynamics AX (version 6.0.1108.670) and cannot be installed.

    This is a common problem you may encounter when you are dealing with multiple build versions of AX 2012. Specially on a single server. This is because of the axutil used to import is a later (newer) version than the axutil used to export the model. If you have multiple build versions on a single server...
  • Blog Post: How to comment when modifying standard code [AX 2012]

    I have seen many ways of modifying standard code and how commenting is done. The best practice is to make as little change as possible or as little impact to the standard solution as possible. Otherwise, making it stand out and the next person can clearly see the difference between standard code and...
  • Blog Post: Blank workspace on open of AX 2012 with Feature pack

    I recently upgraded an environment and everything ran fine. After I finished the upgrade I tried opening AX and the workspace just showed nothing. No menus, just a blank workspace. This was an issue with the the Retail license key. It enabled a check during start up which failed. I had to run this script...
  • Blog Post: Analyse license types [AX 2012]

    I wanted to do a quick analysis on the license types in AX and how the menu items affect them (by count). This is extremely useful when you are creating new roles too. I created a pivot table displaying the Roles on the Row, the License types on the Column and the Count of the Entry points (Menu items...
  • Blog Post: Installing Feature pack on AX 2012 CU3

    I recently had to install the Feature pack on CU3 environment and I thought I should share my experience. Note: I won’t go through every single detail. Just the database and models. Install the Feature pack for the Database using the full Feature pack disc This will warn you that you have a new model...
  • Blog Post: Inventory dimension fields on reports [AX 2012 Feature pack]

    Some minor changes in the feature pack with the way inventory dimension fields are handled in reports. They are now using a map (\Data Dictionary\Maps\InventDimFieldsMap).\ Lets look at an example. I decided to look at the InventTransferOrderOverview report. Notice how populating each InventDim field...
  • Blog Post: Create a custom entity mapping using the Data Migration Framework [AX 2012]

    In my last blog post, I went through the steps to using the Data Migration Framework. This post, I will explain the technical side of it. To create a custom entity mapping, click on the Data migration framework > Create a custom entity for migration . Follow the wizard and enter your main table you...
  • Blog Post: Step by step import with Data Migration Framework [AX 2012]

    Follow the steps on msdn to install the Data Migration Framework. http://technet.microsoft.com/EN-US/library/jj225595 Once you have install, there is also a user guide on msdn but not very detailed. I did my first walk through today and took some notes along the way. There are demo files you should look...
  • Blog Post: Turn off industry specific license configuration [AX 2012]

    One thing to be aware of. In AX 2012 the root module configuration key cannot be turned off from the "License configuration" (in the figure below the locked licence configuration is represented with red pad lock). You have to go to "License information" and blank out the license code...
  • Blog Post: Import default dimension into a table (eg. Customer table) [AX 2012]

    I hear this question a lot. How do I update dimensions or import default dimensions? I wrote a job to import a csv file. Lets take the example below with 4 dimensions. Create a csv file to import with the following columns. CustNum,Dim1,Dim2,Dim3,Dim4 The result should be something like this. Below is...
  • Blog Post: How to add financial dimensions to cubes [AX 2012]

    AX 2012 BI is so much easier and enjoyable to use. Seeing how easy it is, I don’t see a reason for not deploying it all clients. To add a financial dimension Click Tools > Business Intelligence (BI) tools > SQL ServerAnalysis Services project wizard. Click Next . Select Update and then click Next...
  • Blog Post: Override a lookup on a report dialog [AX 2012]

    A good example of overriding a lookup on a report dialog is on the ProjMissingHourRegUIBuilder class. In simple, you need to create a UIBuilder class that extends SrsReportDataContractUIBuilder . You can create grouping; vertical or horizontal alignment; change the number of columns; or add look ups...
  • Blog Post: Add an Image/Icon to an Action Pane Button [AX 2012]

    Let start with the result. Below is a screenshot of Super Mario replacing the Customer icon. This is becoming a common question with AX 2012 using Action panes and all the buttons having images associated to them. It definitely adds to the usability. Follow the below steps and you’ll be alright. Get...
  • Blog Post: Data Migration Framework Beta Released [AX 2012]

    The Data Migration Framework for Microsoft Dynamics AX 2012 is an extension that helps you migrate data into Microsoft Dynamics AX. Examples of the data that you can migrate include master data, open stock, and balances. The Data Migration Framework is available from the InformationSource services download...
  • Blog Post: Hot Fixes Released For Microsoft Dynamics AX 2012

    View a list of hot fixes released by Microsoft for Dynamics AX 2012 since its initial release. The beauty about this page is, it is a consolidated list and makes it easy to find the hotfix in relation to the cumulative update. https://mbs.microsoft.com/customersource/downloads/hotfixes/ax2012hotfixes...
  • Blog Post: Selection query with a foreign key [AX 2012]

    With the new concept of surrogate (foreign) keys in AX 2012. We now use the RecId for setting up relationships. If you wondered how it affects your filters in the query selection. Below is an example of what it looks like. You will have both the RecId and the Primary key of the related table available...
  • Blog Post: View computed column – switch statement [AX 2012]

    I was trying to write a switch statement for a computed column recently. Below is the code I used in the end. public static server str StartDate() { tableName viewName = identifierStr(MyView); Map comparisonExpressionMap = SysComputedColumn::comparisionExpressionMap(); str fieldNameActualStartDate =...
  • Blog Post: Visual studio temp project files [AX 2012]

    I had some weird problems on my local environment. I have multiple environments with the same project. I just did a clean up and delete the files under the following folders. %USERPROFILE%\AppData\Local\Temp\Microsoft Dynamics AX\ %USERPROFILE%\AppData\Local\Microsoft\Dynamics AX\
  • Blog Post: Default dimensions – Order of controls on form [AX 2012]

    You might notice the order of the dimension controls on forms is by Name. I recently had the question asked if you could change the order the controls are displayed in. Standard sorts by name in the code. So, I found the place and commented it out. Before After (This now order the fields the same as...