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/

Range of RecID in an AX Table

In every new table the recID (surrogate key) range starts from the no. 5637144576 and since it is int64 so it goes upto 2^63 (9223372036854775808). It also signifies an important fact that we can't have unique recIDs accross different tables.

Manipulating a form datasource in a class.

It is possible to pass a datasource bound to a grid in a class and then iterate like a query. In this post, I'll giving some code snippets to work with form datasource in some other object like classes. Step 1: Your method or constructor of the class should be able to recieve FormDataSource type

Separate workspace for development in AX 2009

Finally Microsoft has come up with different separate wrokspace for developers of AX. If you have access to the latest build of AX 2009, you'll notice the absence of all development related tools. Only AOT can be accessed by clicking Ctrl + D (I think they'll move it away too). For doing all kind of

How to check configuration key in code?

Q: How can I check whether the particular configuration key is enabled or not in the code at runtime? A: Simple, you can use the function isConfigurationkeyEnabled(configurationkeynum(LedgerBasic)) anywhere in the code. It returns a boolean type.

Test Driven Development

A good link to know about tools and theory of TDD (Test Driven Development) http://www.testdriven.com

Setting a table field mandatory doesn’t allow zero to enter

In Dynamics AX if you set any integer or real type field of a table mandatory, then it would not allow 0 to enter in that field. Whenever a user enters 0 and move to the next field the following infolog message appears. Field 'fieldname' must be filled in. But if you don't like this

Setting up test data for unit Testing

We should make sure that the unit tests should be independent of data as much possible. For this purpose the Unit Test framework provided by David Pokluda also talks about two very important methods. setUp() and tearDown(). These are very important methods provided by all unit testing framework designed for any technology. setUp() deals with

My Programmer Personality Type

The following results are taken from http://www.doolwind.com/index.php?page=11 ================================================================ Your programmer personality type is: DLSB You're a Doer. You are very quick at getting tasks done. You believe the outcome is the most important part of a task and the faster you can reach that outcome the better. After all, time is money. You like coding

Cascade Update in AX

Many people think that cascade update functionality is not available in AX. Since delete actions of 'Cascade' type are available to provide cascade delete functionality then why there is no cascade update. As usual Microsoft will not leave you in the middle of the sea. Cascade update is the default behavior of Ax if you
Newer Posts