Manipulating Addresses in Microsoft Dynamics AX 2012


Making the switch from Microsoft Dynamics AX 2009 to AX 2012 is a change for users and developers alike. One of the  changes you will notice, is that Dynamics AX 2012 changes how addresses are stored and handled.

For example, in Dynamics AX 2009, if you want to store the address for the customer, you would add it on the main customer table (CustTable). In Dynamics AX 2012 however, this address is stored on the LogisticsPostalAddress table and there are several relations that need to be made before you can grab the address.

Storing Addresses in AX 2012

With the addresses being stored on the LogisticsPostalAddress table in Dynamics AX 2012, you are able to keep track of historical changes to addresses. AX 2012 stores whichever address is valid and the effective date ranges for the previous iterations of the address. 

(DirPartyPostalAddresssView) is a view in Dynamics AX 2012 that displays all of the relevant address information for each customer. This keeps you from having to write long select statements each time you need to grab an address.

Selecting & Updating Addresses in AX 2012

From a development standpoint, this changes the way we need to think about selecting the address. Instead of going to the main customer table to grab the address, we need to go to a view.

When updating addresses, instead of using a direct update statement you will call the method createOrUpdatePostalAddress. Remember to pass in the correct validTimeStateUpdateMode to enable Dynamics AX 2012 to track the address history properly.

These changes will give developers more tools to help customize the addresses to meet their clients’ needs.

If you have questions about manipulating addresses in Dynamics AX 2012, or any other AX 2012 questions, fill out the form below and our team of experts will contact you soon.

As Vice President of Digital Transformation at Blue Horseshoe, Steve Shebuski guides businesses through their digital transformation journey. Steve has 20+ years of experience as a Program Manager/Design Lead/Project Manager implementing both Microsoft Dynamics AX / Dynamics 365 as well as tier I and tier II warehouse management and transportation software solutions. Steve's deep knowledge within the distribution industry and his innovative approach to solution architecture are the backbone of the solution implementation and deployment by Blue Horseshoe.

Learn How Others Have Improved Their Supply Chain Operations With Blue Horseshoe

Microsoft Extended Support for Dynamics AX 2012 R3: What's Next?

Read More
Supply Chain Technology

D365 Wave Updates (Updated for 2021)

Read More
Dynamics 365 ERP

Overcoming Cloud ERP Misconceptions: Your Guide to D365

Read More