Vendor Merge (AP115)
Run Vendor Merge (AP115) to transfer a vendor's open invoices to another vendor. You can also transfer 1099 historical invoices from one vendor to another. This form creates an audit trail for the vendor merge.
AP115 gives you the option to create comments about the vendor merge for both to vendor and from vendor. The comment will include the system date of the vendor merge.
AP115 creates three reports:
Report 1 lists the invoices that were transferred.
Listing includes:
- A detail listing of invoices transferred
- Summary listing of invoices transferred
- Lists invoices moved
Report 2 lists invoices where the location code was removed.
Listing includes:
- Listing of invoices not transferred and the reason/error
Report 3 lists invoices that cannot be transferred.
Processing Effect
If a duplicate invoice is encountered, the invoice is given an extension to the invoice number. This extension is "-1". The form then checks to see if the new invoice number is a duplicate. The form uses the company, vendor, invoice number, and invoice suffix. If this invoice number is still a duplicate invoice, the invoice will not be transferred and the invoice will be listed on the duplicate invoice report.
If an invoice is a duplicate it will not be transferred, and it will be listed on the Duplicate Invoice Report. You will have to manually resolve the invoice.
If an invoice with an extension number is not a duplicate it will be listed on the Invoice Number Change Audit Report. This provides audit trail for changed invoice numbers.
If the original invoice number is greater than 20 characters, the form cannot add an extension to the invoice number and the invoice will not be transferred. It will be listed on the Duplicate Invoice Report, and must be resolved manually.
If an invoice has a remit to location code that is not defined for the vendor the invoice is being transferred to, the location code will be removed from the invoice when it is transferred. This has an impact on the location code balance and vendor balances.
If an invoice with a remit to code that does not exist on the to vendor is transferred, the remit to code will not be transferred. AP115 will list invoices where the remit to code was removed.
Cash codes and bank codes will be updated on invoices that are transferred between vendors.
Partially paid invoices will not be transferred. Partially paid invoices will be listed by AP115.
The current balances (vendor group, company, vendor, location code, and balance currency) and highest balance are updated as invoices are transferred between vendors.
If an invoice has a location code that is not defined for the vendor the invoice is being transferred to, the location code will be removed from the invoice. In this case the location code balance of the original vendor will decrease by the invoice amount, and the vendor balance (not the location code balance) of the new vendor will increase by the invoice amount.
Note 1: AP115 does not update the vendor hash totals on the batch records.
Note 2: AP115 will not transfer unreleased invoices that have applications by an unreleased payment or check.
Note 3: AP115 will not transfer prepayment credit memos and employee advance credit memos between vendors.
Note 4: AP115 does not update the invoice description on the distribution records. These descriptions will be inaccurate if you have set the vendor number and vendor name to default as the invoice description.
Note 5: AP115 does not allow merge of a vendor (From Vendor) that has open match invoices. These invoices need to be closed or canceled prior to merge processing.