Updating addresses in bulk

If you need to make the same change to multiple address records, you can use the lookup to update the addresses in bulk.

Note: Before you update addresses, it is important to understand that Infor Public Sector has four different types of address records, each of which uses a different set of fields to identify an address. For example, a standard address has a single street number, and a range address has two, indicating the beginning and end of the range. When you update addresses, Infor Public Sector shows all possible fields for all address types, so you should ensure that you're only editing the fields that apply to the type of addresses you're updating.

See Address bulk update fields.

  1. Select Resources > Property > Lookup Addresses.
  2. Look up the addresses that you want to update.
  3. Select the addresses you want to update in the Address Lookup Results grid.
  4. Click Action and select Update Selected Items.
    Infor Public Sector shows the Address Bulk Update dialog box. The Statistics check box in the upper left corner shows the number of addresses selected, the number changed, and the number expired. The Options group box in the upper right corner is used to clean up duplicate addresses. The Change Selected Addresses To group box at the bottom of the dialog box shows the address fields you can update.
  5. Under Change Selected Addresses To, select the check box for each piece of information you want to update.
    Any fields whose check boxes you don't select won't be affected by the update. If you select a check box but don't enter anything in the corresponding field, Infor Public Sector will delete the information in that field from all selected addresses.
  6. Specify the new values in the selected fields.
  7. Click Save to save your changes, or click Save & Close to save your changes and close the dialog box.