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

My session on F&O to Azure Data Lake Sync in Urdu/Hindi bootcamp 2021 (in Urdu Language)


How to move data from on-prem to cloud using SSIS

In this video, I'll explain the steps of moving data from a flat file and SQL server to Azure SQL on cloud using SSIS. https://youtu.be/VTI3QErlMkU

My session on PowerCommunity virtual conference


Part 2 – Build azure function to process the messages in Azure Service topic

In this second part of my three part series, I am going to list down steps to build an azure function to process Confirmed Purchased orders which which we are

How to build REST APIs with Azure functions

Web APIs has been around for quite a while and one can develop REST APIs now in all most all technology platforms. Certainly in Azure as well. In this blog

Part 1 – Configure Business events with Service Bus Topics

In this blog post, I'll configure the business events in D365FO with Azure Service Bus topics. Configure Azure Service Queue Navigate to Azure portal - https://portal.azure.com/ and select Service Bus.

Avoid point-to-point integrations nightmare by using business events and Azure based middle layer

Integrating and communicating through standardized data sets with multiple systems is an indispensable requirement in every ERP project. No business can just rely on a single system or service to

Recurring Outbound Integrations using DMF and Azure Logic Apps

In this article, I am going to list down steps to create an Azure LogicApp based recurring integration for bulk data export. If LogicApps is new to you, don’t worry,

Download free eBooks on Kubernetes and distributed system on Azure

Just came across this link. Free eBooks from Microsoft to learn containerization in general with Kubernetes and how to deploy kubernetes IaaS on Azure. Check it out. https://azure.microsoft.com/en-us/resources/kubernetes-collection-host/

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

worth reading interview

I was reading an interview with Brandon George taken by DynamicsWorld. Thought it should be shared on my blog. worth reading it. http://www.dynamicsworld.co.uk/Brandon-George-Interview.php

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
Newer PostsOlder Posts