Rahul Sharma

Solutions Architect - Microsoft Dynamics AX | Azure

This is a technology blog covering Microsoft Dynamics 365, Microsoft Azure, IoT, Power Apps, Power BI, .Net, SQL Server, SSRS, and related technologies. Join this blog on facebook {Rahul Sharma}, to start a discussion !!! NOTE: My employer is not responsible for the content published here.

Index | MS Dynamics AX | MS Dynamics CRM
View blog as >> Magazine | Sidebar | Flipcard | Mosaic | Snapshot | Timeslide

Dynamics Ax Global Address Book

In this article we will discuss a very important and useful Dynamics Ax feature, Global Address Book. This article is good for both functional and technical consultants.

Note: This article is for advanced Dynamics Ax users. Good knowledge of Dynamics Ax and SQL server is required.

Global Address Book: It 's a mechanism to share organization details, mainly communication and address, between different business entities in the company. For example, you may have a customer which is also a vendor; in this case there would be data redundancy or unnecessary duplication of address data if you had to enter the same address on customer and vendor. Wouldn't it be good, if you can store data once in Address table and share this between different business identities of the company. Yeah, sounds good. Solution to this problem is global address book or sometimes you call it directory.

Dynamics Ax 'SqlStatementExecutePermission' failed

If you are running native SQL statements in Ax, you might see below error while executing code.

Request for the permission of type 'SqlStatementExecutePermission' failed.
(C)\Jobs\RahAddressImport - line 76