3 Resolving Multiple EULs Having the Same Address

This chapter demonstrates how to use the Address Correction utility to resolve multiple end user locations (EULs) that have the same address.

Scenario Overview

In this scenario, multiple end user locations with IDs L1, L2, and L3 have the same address with ID A1. You can select one end user location (for example, with ID L1) as the primary. After you resolve, only the primary end user location with ID L1 is retained and all the remaining end user locations (with IDs L2 and L3) are replaced with the primary end user location with ID L1 that has the address with ID A1.

The following preferences govern this scenario:

Resolving Multiple EULs Having Same Address

To resolve multiple end user locations having the same address:

  1. Run the Address Correction utility. See "Running the Address Correction Utility" for more information.

  2. Click the Criteria tab.

  3. Under the I want to find area, select the Multiple EULs having same address option.

  4. From the Country list, select a country.

  5. From the Format list, select an address structured format.

  6. Specify your search criteria in the Network Loc Name, End User Loc Name, or any of the address fields and click the fields where you want to specify the partial names using wild cards and click Set Criteria. See "Setting the Search Criteria" for more information.

  7. In the Limit Number Found To field, enter the maximum number of records to be retrieved for the search. See "Setting the Maximum Number of Records to Be Retrieved" for more information.

  8. Click Search.

    The Address Correction utility searches for all the groups of end user locations that have the same address based on the specified search criteria. The Results tab displays multiple end user locations grouped by address ID in the Available Groups area.

    Consider an example where the end user locations and addresses exist with IDs as shown in Table 3-1.

    Table 3-1 End User Locations and Addresses

    End User Location Name Location ID Address ID

    EUL1

    L1

    A1

    EUL2

    L2

    A1

    EUL3

    L3

    A1

    EUL4

    L4

    A2


    If you specify EUL1 in the End User Loc Name field, the Address Correction utility first searches for the address to which L1 belongs, and then it retrieves all the duplicate end user locations that belong to that address.

    In this example, EUL1 belongs to the location with ID L1 and to the address with ID A1; therefore, the Address Correction utility retrieves the following end user locations that belong to A1 and displays them in the Available Groups area on the Results tab:

    • L1

    • L2

    • L3

    In this example, EUL4 belonging to the location with ID L4 is not retrieved in the search results because it belongs to the address with ID A2.

  9. (Optional) On the secondary toolbar, click Export to export the data displayed in the Available Groups area. See "Exporting Available Groups Data" for more information.

  10. Do one of the following:

    • Select the end user locations/groups of end user locations you want to resolve and click the single arrow button, which moves the selected end user locations/groups of end user locations from the Available Groups area to the Selected Groups area.

    • Click the double arrow button to move all the end user locations from the Available Groups area to the Selected Groups area.

  11. In the Resolution Options area, select one of the following options depending on how you want to resolve multiple end user locations that have the same address:

  12. Click Resolve.

    Note:

    The amount of time taken by the Address Correction utility to complete the resolution process depends on the number of rows in the Selected Groups area.

    A confirmation message is displayed that lists the total count of all the entities that will be impacted by the resolve action.

  13. Click Yes.

    You cannot undo this action.

    A unique identifier (Job ID) is generated for the group of data in the Selected Groups area whose data inconsistencies are being resolved. This identifier is used to compile log information in the View Log window. See "Viewing Log Information" for more information.

    The references of all the end user locations are moved to the primary end user location.