Back to the Case Study Home Page... 

In order to assist in data integrity, and to facilitate a quicker address entry process, a custom zip code lookup was added to the Edit Address screen.  Based upon the five digit zip code entered, a lookup is performed on a postal code reference table, and based upon a match the city, state, county, and country are automatically filled in.  In the event that the zip code entered, has more than one match in the reference table, a dialog is presented to the user to have them select the correct information.  Once the address information is populated, the Tax Schedule list is populated for the State selected.

Once a postal code is entered the system populates the rest of the address, if more than one possible match is found the user is prompted to choose the preferred information.

Management of the postal code reference table is handled via a custom management interface, accessed by a drop down menu item in the SalesLogix client.

From this screen, single zip code definitions can be added, edited, or removed.  An import utility was also provided where an external zip code file can be used to populate the reference table. The client currently populates this table with all US zip codes, though it could be expanded to include worldwide postal code management, if desired.

Back to the Case Study Home Page...