Merging Duplicate Vendors

Step-by-Step

  1. Run the “Merge Vendor Query”.
  2. In the Query Design, click on the Query tab.
  3. Notice that “Merge Duplicate Records” is highlighted.  In the right panel, choose ‘Vendor Name’ in the description drop down menu.
  4. Click Run Query.
  5. On the Surviving Vendor, verify that the “Surviving Organization” field is blank.  If not, delete information in the field.
  6. Highlight the Vendors that will be merged together.
  7. Click on the Action button and choose “Merge Duplicate Records”.
  8. Select the record that you want to keep (the oldest vendor record will default as the record to keep).
  9. Select the “Merge Duplicate Records” button to process the merge.
  10. Re-run the “Find a Vendor” query, and you’ll see that the old vendor no longer exists as a separate vendor. Open the detail display for the original vendor and click on the “AP Invoices” and the “Disbursements” reports to confirm that the invoices and payments from the duplicate vendor were indeed merged to the original vendor.