Dynamics ax global address book

转载 2010年05月27日 14:17:00

From: http://blog.rahulsharma.in/2010/04/dynamics-ax-global-address-book.html (需要翻墙才能浏览)


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. Gook 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 vender. Wouldn’t 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.

This concept works on business parties. You create a business party in the global address book, defines various information regarding this, like addresses, communication details etc. You can create two types of parties, Organization (customer, vendor, business relation etc.) or Person (contact etc.).

All these parties are uniquely identified by PartyId in Ax. Ax uses this PartyId to connect address book to master records. Open customer from and go to general tab, you will see it.

You can create global address book entry in two ways. First create address book record and then attach it to customer/vendor at the time of customer/vendor creation. Customer (same applies to other business entities as well) form actually do it automatically. If you specify the same Customer Name as of your address book, it will attach it correctly. Second, if you are creating customer first, then also, if Ax does not find name in address book, it will create one address book entry for the same.

Ok, it’s good that you can share address but what about the cases where you don’t want to share a particular address entry on address book between business entities. Yeah, there may be chances where you want to keep address private to your business entity. Do you see Public checkbox on customer form address tab?

Public/Private Address: Only public addresses are stored in global address book. Private addresses are stored with respect to the business entity. I will explain how all this stuff is handled in a short while.

In the above picture, you can see same addresses that you have created on your customer but not it’s private address. And if you see grid at the bottom, it says that I am sharing the same address for customer ‘RahulCust’ and vendor ‘RahVend’. Cool, hmmm!


Primary address: This is your primary address for the address book. You can create only one primary address per address book entry.


Techies Talk:

Below are the tables involved in Global Address Book(Public addresses) creation:

1.       DirECommunicationAddress

2.       DirECommunicationTypeTable

3.       DirECommunicationTypeTxt

4.       DirOrganizationDetail

5.       DirParameters

6.       DirPartyAddressRelationship

7.       DirPartyAddressRelationshipMapping

8.       DirPartyECommunicationRelationship

9.       DirPartyRelationship

10.   DirPartyTable

11.   DirPersonGenerationalSuffixTable

12.   DirPersonPartyDetail

13.   DirPersonSalutationTable

14.   DirPrivacyGroupTable

15.   DirRelationshipTypeTable

16.   Address

17.   Entity table. (CustTable, VendTable etc.)


Most of the tables store some related information about the party. So we will only discuss about the important ones used in creating links between address and business entities.

DirPartyTable, DirPartyECommunicationRelationship, DirPartyAddressRelationshipMapping, Address and for business entity we will use CustTable.


So, to define the relationship between Address and Customer, see SQL query below. It’s a very simple SQL query with describes relationship between all these tables. Here you go…

Below are the tables involved in the private addresses:

1.       Address

2.       Entity table. (CustTable, VendTable etc.)

This is the query to reach at private address of an entity (CustTable).

Select * From Address

         Where AddrTableId = 77 and AddrRecId = 5637144580


AddrTableId = Entity table id.

AddrRecId  = Entity record id.

Now after seeing these queries you should be able to define the relationship between address and any business entity in AX.

Just for the quick note, there are three parts involved in Global Address Book.

1.       Entity Tables like, CustTable, VendTable etc.

2.       Global Address Book tables, all tables starting with Dir*. Already mentioned above.

3.       Address tables, tables used to store actual address like Address, Address countryRegion, AddressState, AddressZipCode etc.

Microsoft Dynamics AX发展历史

Microsoft Dynamics系列: 企业资源计划(ERP) Microsoft Dynamics AX(Axapta)中大型企业国际化应用 Microsoft Dynamics G...
  • pockeyfan
  • pockeyfan
  • 2014年12月07日 23:07
  • 774

Microsoft Dynamics AX2012 R2吐槽系列(4)

  • herotangabc
  • herotangabc
  • 2014年06月10日 10:50
  • 969

Dynamics AX 相关资源(持续更新中)

感谢版主。。 http://www.krely.cn/archives/360.html
  • MeteorBorn
  • MeteorBorn
  • 2015年06月17日 21:20
  • 864

AX 2012 R3 将下架, Dynamics 365将新增中间价位的用户许可 & 更多

微软将会在今年7月1日停止对新客户销售Dynamics AX 2012 R3。这个时间点比大多数人的预想来得早了点。它将会对现在或将来打算上DAX的客户造成诸多影响。 现存的DAX201...
  • jetxuzhi
  • jetxuzhi
  • 2017年04月19日 15:09
  • 815

Dynamics Ax 微软官方社区地址

  • mahailiang
  • mahailiang
  • 2016年07月25日 12:35
  • 300

Microsoft Dynamics AX 2012

2013年3月微软提供了一个Microsoft Dynamics AX 2012 R2 Solution  Demo Package。 是用Hyper-V虚拟机形式提供的,有三个虚拟机,如下: VM ...
  • kevingao
  • kevingao
  • 2013年12月16日 21:00
  • 3519


国外的大神已经找到好的方法,可以把DynamicsAX2012R3VM安装在自己的笔记本上,而且运行流畅。 注意,不需要64位的服务器,不需要16GB以上的内存,甚至不需要一个专用的电脑。 正在测试安...
  • MeteorBorn
  • MeteorBorn
  • 2015年06月27日 22:19
  • 1374

Dynamics Ax 2012中调用外部web服务

Dynamics Ax 2012中调用外部web服务不同系统的功能集成,多用的web service或wcf或是轻量级的web api ,调用方式虽然有所不同,但原理基本上都是相似的其他语言的调用方式...
  • q274974359
  • q274974359
  • 2016年12月12日 13:15
  • 417


 国外的大神已经找到好的方法,可以把DynamicsAX2012R3VM安装在自己的笔记本上,而且运行流畅。 注意,不需要64位的服务器,不需要16GB以上的内存,甚至不需要一个dynamic...
  • mahailiang
  • mahailiang
  • 2016年07月26日 13:31
  • 492

Microsoft ERP Dynamic AX 学习笔记

2007/04/20 开始学习AX42008/01/25Ctrl+D可调出开发环境,在数据字典中建立表后,右击表名,在弹出的菜单中选“同步”,在dynamics数据库中会建立同名的表,其中包含所建立的...
  • kevingao
  • kevingao
  • 2007年04月21日 16:54
  • 8813
您举报文章:Dynamics ax global address book