How do you merge duplicate A/P vendors?

Question

We have the same vendor set up in the A/P module twice. How do I go about merging them so the history is there? It will not allow me to make the vendor inactive as there is activity on the account. 
 
 Thanks, 
 Amy

alabounty · Answer

Sage Knowledgebase article link: 
 
 support.na.sage.com/.../viewdocument.do 
 
Description 
How to merge vendors using the Delete and Change Vendors utility 
 
Disclaimer 
Backup Warning 
Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst. 
 
Resolution 
To change or merge vendor numbers 
 
Open Accounts Payable Utilities menu > Delete and Change Vendors. 
Select the Change tab (the default is to the Delete tab) 
Enter the starting vendor number and ending vendor number to select a range of vendor numbers to change. You can also enter the wildcard character (*) to select all matching vendor numbers. For more information, see Delete and Change Vendors – Fields. 
In the New Vendor No. field, perform one of the following: 
Enter the new vendor number for the selected vendors to be Merged into. 
Enter an existing vendor number to merge vendor information with the selected vendor. 
Click the Resolve Wildcards button to list each vendor number, either in the selected range or selected by wildcards, on a separate line. 
Click the Print button. 
In the Delete and Change Vendors Listing window, click Print. 
You must print and clear the listing before you can complete another change or merge. 
Perform one of the following: 
Click Proceed to begin vendor change or merge. 
Click Delayed to begin vendor change or merge at a later time. In the Delayed Execution window, in the Will Begin at Approximately field, type the time to begin and click OK. For more information, see Delayed Execution - Fields. 
The vendor number is changed or merged. 
 
Note If the Inventory Management and/or Purchase Order module is integrated with Accounts Payable, rebuild the Purchase Order and Inventory Management sort files along with the sort files for any other affected modules after vendor numbers are deleted or changed. For more information, see Rebuild Sort Files.

Sage 100

How do you merge duplicate A/P vendors?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING