Address Verification

06/30/2025 1:28 pm EDT

Address Verification Setup - Review

Purpose

Address Verification is a licensed feature that allows validation and standardization of U.S. addresses by querying USPS data. It improves data quality by normalizing user-entered addresses and auto-filling missing or corrected information.

VerificationButton

Feature Summary

Validates U.S. street addresses, ZIP codes, cities, and states.
Detects commercial vs. residential delivery.
Retrieves time zone and daylight savings data.
Requires internet access to a gateway service.
Adds a “Verify” button to the address form in the software UI when enabled.
Clicking the “Verify” button sends the address to USPS via SmartyStreets for validation and returns a suggested standardized address.

Requirements

Activation
Original Notes Indicated this is a $100 annually licensed add-on.
Internet Access
The system must be able to access the following URL:
https://addrverify.sedonaoffice.com
SQL Setup
Insert a record into the dbo.GE_Address_Verification table of the Sedona Company Database:

sql

INSERT INTO dbo.GE_Address_Verification (
Country_Id,
Name,
Url,
User_Name,
Password
)
VALUES (
2,
'SedonaOffice AddVerify',
'https://addverify.sedonaoffice.com',
'', -- User_Name is blank based on your screenshot
'142b6e64-e3dd-40be-b870-296646500002'
);

Architecture Overview

The application queries the internal verification service via the GL_Address_Verification table.
The URL points to the internal web host or external gateway (e.g., addrverify.sedonaoffice.com).
Once the service is reachable and initialized, the “Verify” button becomes visible when "United States" is selected in the Country field.

Notes

This feature does not verify international addresses.
If the verify button is not showing, confirm:
- The correct country is selected.
- The table record exists.
- Internet access to addrverify.sedonaoffice.com is possible.

Troubleshooting

If verification fails:
- Confirm credentials and endpoint URL are correct.
- Test the URL in Internet Explorer or Edge from the client machine.
- Contact infrastructure if the endpoint is down across the board.

Was this article helpful?