Dynamics Online

Microsoft Business Apps and Microsoft Cloud

How to get table size of all table in a SQL DB in a spreadsheet

Many times while upgrading or migrating from on-prem to cloud hosted ERP, our customers would like to know if their current AX DB size would be applicable on cloud. Do they need to buy extra DB storage or should that be enough given the number of licenses they are buying. And for any SQL Server

How to setup claim based site on EP in AX2012

Alright. In last post, I jot down the steps to setup public portal on EP. In this post, I'll extend it for those who wants to setup claim-aware (or secure site if you will) on top of that. The process of setting up claim based site on Enterprise Portal is specifically for AX2012 R2/R3. At

How to setup a Public site on Enterprise portal in AX2012

The public site is a custom site collection deployed/created on top of regular SharePoint app (Sharepoin-80) that we configure while installing EP on AX2012. This post will list down steps to setup a public site. Pre-Requisites: The SharePoint foundation 2010 or 2013 has already been installed and configured on the box. The regular EP site

How to launch the internet browser with a data field bound to URL data?

While working on a project, I figured out a way in AX that could trigger your system default internet browser within the AX. Many of you already have seen this while playing with SSRS or EP when you click on 'view in browser' kind of a buttons. Its really simple. For the sake of example,

Dynamics AX 2012: Role based security framework

In addition to many new frameworks that are introduced in the current release of Microsoft Dynamics AX (a leading ERP of Microsoft Business Solution suite), role based authorization framework is one of the key elements that would make the life of AX 2012 customers and vendors easier. Though the security rights and user access management has been

New X++ Editor in AX 2012


How to persist values on runtime in SysLastValue?

Sometimes we need to store values on runtime which are not really worthy of storing in database. Examples could be the fiscal calendar year and period entered by a particular user last time during the session. In many situations, the user would like to know what values he entered last time while doing some processing.

Everything tool

Recently, I came across a very light and handy tool to find out files stored anywhere on computer at the blink of an eye. Although, windows search have been improved alot lately but still its quite slow. This tool creates file indexes very quickly and therefor privide search results earlier then windows search. its simple and easy

AOT Maps – the consistent approach to access same data

The AOT maps residing in the data dictionary is very useful element under DD node after tables, enums and EDTs. Perhaps they aren't as widely used as they should be in usual application programming. However, they have the power to solve some key daily problems in AX running in the production environment. Map defines X++

How to cache records on run-time in AX?

The simple answer is RecordViewCache class. This class is used to implement set-based caching in your code at run-time. 1.    First declare the variables. CustTrans                    custTrans; RecordViewCache      recordViewCache; 2 .  Call a nofetch query to create a record buffer. It will define the set of records that you want to cache. //Define records to cache select