This discussion has been locked.
You can no longer post new replies to this discussion. Posts are automatically locked, when no new replies have been made for a long time. If you have a question you can start a new discussion.

Enhance Your Dynamics NAV with UPS Address Validation Street Level

Web Services open up a secure and reliable way to integrate a business application with other business applications, whether those applications are locally hosted or in the cloud. Nowadays, Web Services are the best technology to integrate systems without re-implementing or breaking business logics in other systems.

In this article, I will discuss how we can use Web Services to integrate Microsoft Dynamics NAV with UPS (United Postal Service) to validate sales order addresses. It’s critical that the ship-to addresses on customer orders have been validated before they get out of the door. This saves shipping expenses and laboring costs by avoiding returned shipments and re-processing orders, and more importantly, satisfies customers by receiving their orders on time. By integrating Microsoft Dynamics NAV with UPS Address Validation Street Level, companies can make sure their shipments are getting to the right addresses on schedule. Additionally, the Address Validation Street Level Service provides for addresses being classified as residential or commercial. This is beneficial in that companies collect the correct amounts for freight from their customers.

When a sales order is ready to ship and released in Microsoft Dynamics NAV, the system immediately sends a web service request to the UPS server asking for address validation. The request, in XML format, contains the address information which needs to be validated, along with other pieces of information necessary to make the communication. Microsoft Dynamics NAV then goes into a waiting mode until it gets the feedback from the UPS server or when a specified waiting period expires. The UPS server processes the request, and responds to Microsoft Dynamics NAV with validation results, that are either valid or invalid. If the address is valid, the order would be automatically released by Microsoft Dynamics NAV, suggesting that the order is good to go. If the address is invalid, a list of matching addresses would show up on the screen where the users could simply choose the correct address from this list.

Following screenshot demonstrates sales order ship-to address validation in Microsoft Dynamic NAV with an incorrect address submitted for validation.

Sales order address validation is one of many useful implementations that we can to do to enhance Microsoft Dynamics NAV. Address validation feature could be applied to many areas in the ERP system such as customer address validation, contact address validation, etc. Valid addresses in systems are critical to businesses ensuring customer statements, invoices, newsletters and marketing materials are delivered accurately and timely.


For more information, please visit our website: