Need help regarding address

Finance and Operations/AX Developer Forum
1

Hi Guys,

I am building a custom query, which will eventually be used to build AIF Service that spits out customized XML of Invoice.

I need to include addresses such as delivery, Bill To & Sold To.

Can any one plz tell me which address tables and joins that needs to be used to get any one of the above addressess?

Thanks in Advance.

2

Look at TableCollections\DirPartyCollection to see a big group of tables that relate. You will need tables like Address, DirPartyTable, CustTable, etc. They join on PartyId, AddrTableId, AddrRecId. There is a ton of relating information, but it sounds like you really only need some of the address info.

3

Thanks Alex for your reply. I only have 2 items in my table collections node. Batch & Centralized payments.

I am using ax 2012. Do you think this might be installation problem?

Is there any other way that i can find the relation between the address tables? Thanks

4

Have look a at this,

http://dynamicsuser.net/members/kranthi/files/Implementing_5F00_the_5F00_Address_5F00_Book_5F00_Framework_5F00_for_5F00_Microsoft_5F00_Dynamics_5F00_AX_5F00_Applications_5F00_AX2012.pdf.aspx

5

Hi,

The table ‘LogisticsPostalAddress’ holds postal addresses. And the table ‘LogisticsElectronicAddress’ holds electronic addresses such as email, fax etc.