The Supplier Merge Program is a utility you can use to maintain your supplier records. You can use it to merge duplicate suppliers into a single, consolidated supplier. You can use it to merge transactions within the same supplier from one supplier site to a different suppler site. You can choose to merge all transactions for a suppler into a new supplier, or you can just choose to merge unpaid invoices. This option is useful in the case of an acquisition. In that case you may want to leave all of the transaction history with the original supplier and only merge unpaid invoices to the new supplier who now wants to receive the payments.
The report lists the new (correct) suppliers and the old (duplicate) suppliers. The report also lists invoice information for invoices updated for each set of new and old suppliers. Payables prints the total number and total amount of invoices that have been updated for each set of merged suppliers.
Payables also prints the total number of duplicate invoices. You can use this report to identify any duplicate invoices, update the invoice number on one of the invoices, and then resubmit Supplier Merge.
Payables automatically prints this report when you initiate a Supplier Merge. See: Supplier Merge Program.