Using address validation in Stops grids

First available in TMW Operations, V.2022.1

Your company may not create company profiles for all of the locations where you do pickups and deliveries. The system lets you enter a street address for a stop location. You can do this in the Trip Folder’s Stops grid and on the Order Maintenance All Stops tab. To be sure the address entered for a stop is good, you can have the system validate it. This validation works for stops that have a Company ID field value of UNKNOWN. If a stop has a valid company ID, it is not validated.

Setting up street address validation

To use this feature, you must:

  • Use PC*Miler as your mileage system.

  • Have [PCMilerMap]EnableStopLevelAddressValidation=Y in your TTS50.

    When the setting is in place, the Address Validation field is available for you to add to the Trip Folder’s Stops grid and on the Order Maintenance All Stops tab.

The Address Validation field does two things:

  1. It acts as a button to let you trigger the validation process for the stop.

  2. It shows color indicators that tell you whether the stop’s address has been processed and if it is valid.

    • Green means the address has been validated and is valid.

    • Red means the address has been validated and is not valid. Red also shows when you have canceled the validation.

    • Yellow means the address has not been validated yet.

    • Gray means the address cannot be validated. Addresses cannot be validated if the stop has a valid company ID, or if you did not make entries in the Address1, City, State, and Zipcode fields.

Because the validation process provides latitude/longitude data for the address, you will also want to add the GFC Latitude (stp_gfc_lat) and GFC Longitude (stp_gfc_long) fields to the grids.

Use Field Chooser to add the fields to the stops grids in each window and save the grid layout.

The GFC Latitude (stp_gfc_lat) and GFC Longitude (stp_gfc_long) fields are available in Field Chooser after you apply the TmwOperationsDBMods.sql file to your database. The file is supplied with the TMW Operations 2022.1 installation files you download from ClientCenter.

Making sure an address is valid

The system will validate a stop address as you enter it. You must make entries in the Address1, City, State, and Zipcode fields. When you tab out of the Zipcode field, the validation starts.

  • If the process finds a match, the indicator in the Address Validation field shows as green. The stop’s lat/long data is shown in the GFC Latitude (stp_gfc_lat) and GFC Longitude (stp_gfc_long) fields.

  • If an exact match is not found, the Matches pop-up window opens. It shows possible matches. Select the one you want to use. The stop’s address and ZIP Code are updated to match your selection. The Address Validation field indicator shows as green. The GFC Latitude (stp_gfc_lat) and GFC Longitude (stp_gfc_long) fields show the lat/long data.

  • If the process does not find an exact match or an address that is a possible match, the Address Validation field shows as red. No lat/long data is shown in the GFC Latitude (stp_gfc_lat) and GFC Longitude (stp_gfc_long) fields.

  • If the stop cannot be validated, the Address Validation field shows as gray.

To check an address that is already entered for a stop, click the Address Validation field in its row.

When using this feature, orders must have a valid company ID in the Order By and Bill To fields.