Pages

Monday, April 17, 2017

Address Validation in Dynamics AX - QuAAX

I wanted to talk about a new product for address validation and discovery in AX called QuAAX (Quality Addressing for AX), powered by Experian Data Quality. It's more than a simple "is this address valid or not" type of program and allows for address discovery, quick entry, and some fuzzy operations.  It also works internationally with 200+ countries supported.


Disclaimer: I worked on this product.



Addresses in AX can be a headache.  Between data migrations from years of different systems, order imports from external sources, and user entry error you can end up with a mess of postal address records that you have varying degrees of confidence in. This is where QuAAX can help solve many of those issues.


The code is almost entirely X++ and lives in AX, which makes desired customization easy and provides transparency. It's designed to be an easy install via model file with a few overlayered objects to merge.

It is powered by Experian Data Quality web services, so for the configuration you simply put in your Auth Token and set a few minor settings. This means you don't need to update any on-premise software. It also back-fills related tables, so no need to create new zip-codes and it can automatically complete zip+4 codes.


There is a new indicator on the address records throughout the system that visually indicates the status of the address and shortcut buttons to verify addresses.


It will automatically create suggestions for validated addresses that are more well formatted.



When you have an address that is close to correct, it will automatically jump into the edit view with the parts it was able to verify and ask for user input. An example is this address (401 B St, San Diego, CA 92101) where I forgot to enter the suite #. It prompts me to enter it and provides acceptable ranges of input.


There is a fancy engine used for keying in new addresses that lets you very quickly enter data and also suggests inputs as you type.


It also has a bulk processing engine and simple API, so you can perform cleanup on your legacy data or perform validation calls on new addresses input from external sources.


Some final comments. Right now it's supported for AX 2012 and it's coming soon to Dynamics 365 for Operations.  There are plenty more features I wasn't able to cover in this post such as lat/long, address type indicator (residential vs commercial), and more.

More information can be found here: http://axmentor.com/solutions/products/quality-addressing-for-ax/

As always, happy DAX'ing!

7 comments:

  1. Hi there! I could have sworn I've been to this site before but after checking through some of the post I realized it's new to me. Anyhow, I'm definitely happy I found it and I'll be bookmarking and checking back often! paypal login my account

    ReplyDelete
  2. A 30-year fixed-rate mortgage is among the most common type of mortgage. books

    ReplyDelete
  3. Mortgage default insurance protects your lender in the event you can't repay your mortgage loan. mortgage payment calculator canada You'll understand commercial loan terms, its payment structure, and rates. mortgage calculator

    ReplyDelete
  4. Good post. I learn something totally new and challenging on blog IS stumbleupon everyday. It’s always helpful to read through articles from other authors and use a little something from their sites. Turkey tourism.You can check all Turkey tourism Guidelines Turkey through Turkey e-Visa website.

    ReplyDelete
  5. I love what you guys do too. Much clever work and reporting! Keep up the good work guys...Turkish visa US citizen, You can apply online via Turkish visa website.

    ReplyDelete
  6. Hii sir, how are you? You're welcome. India tourist visa covid, Are you looking for information about getting an India e tourist visa? Our site has more details about tourist visa to India. You can read about the requirements of an e visa for India here.

    ReplyDelete