BAD_ADDRESS (Validation)

Used to indicate that an address is invalid and should not be used as mailing destination for reports. When reports are printed, a checkbox allows you to choose to include/exclude records with bad addresses.

Customers

Location	Display field	iMIS table
Manage customers (from Customers, select Manage customers, enter/edit record, and select Address tab)	Bad Address	Name_Address.BAD_ADDRESS

BAD_ADDRESS enables you to mark address that do not pass validation with codes such as “moved”, “no_such_addr”, and so on. You can specify an address as bad (invalid) and include or exclude those customer records when generating Exports, Labels, and Letters (using the Word Integration Letter System) by selecting a bad address status from the Status drop-down list on the Address tab of the Manage customers window to associate with the customer’s address.

The values listed in the Status drop-down list are defined in the BAD_ADDRESS general lookup/validation table. If the table is not defined or there are no values specified, no values display in the drop-down list.

Note: The Status field accepts up to ten characters. Code or Expansion values defined for the BAD_ADDRESS general lookup/validation table that exceed ten characters will not display in the Status drop-down list. If the Description value exceeds ten characters, the value will display in the Status field but may display truncated (shortened), assuming the Code or Expansion associated with the Description does not exceed ten characters.

Note: To generate a report that includes or excludes addresses that have been marked with a bad address status, modify the report specification to include the Include Bad Addr option on the appropriate Selection window.

About company flowdown

If automatic flowdown of company address information is enabled on the Customer Setup – Advanced window, marking a company address as invalid will mark that address as invalid for all associated individual records with the following limitations:

• Only the data that appears in the Main address tab (the tab in the first position) for the company record will flow down to the address fields for associated individual records.
• Flowdown only occurs if the address for the individual record exactly matches the address for the company record.