Merging Duplicate Vendors


  1. Run the “Merge Vendor Query” located in the System Workspace in the Accounts Payable section.
  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. Select the vendors that will be merged together by clicking on the boxes to the left of the Vendor names. 
  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.