What Acumatica's documentation says
- Acumatica can merge a vendor only with a duplicate record of the Business Account type, from the Duplicates tab of the Vendors (AP303000) form; vendors cannot be merged with other vendors. Source 1 (opens in a new tab)
- The Duplicates tab and the Check for Duplicates command are available only with the Duplicate Validation feature enabled on the Enable/Disable Features (CS100000) form. Source 2 (opens in a new tab)
- In Acumatica, the Raise an Error on Duplicate Vendor Reference Number check box on the Accounts Payable Preferences (AP101000) form makes the system raise an error when a document on the Bills and Adjustments (AP301000) form uses a Vendor Ref. value already used in the system. Source 3 (opens in a new tab)
- The error is not raised for a correcting document created with Reverse, or for documents generated from the Recurring Transactions (AP203500) or Generate Recurring Transactions (AP504000) forms. Require Vendor Reference makes the Vendor Ref. box required for bills. Source 4 (opens in a new tab)
Checked against the vendor's documentation on Nov 7, 2026. Products change; the vendor's current help is the final word.
Why duplicate vendors happen
Most duplicate vendor records start with a small difference. Someone types "Northwind Supply Co." and someone else types "Northwind Supply Company." Both look right on a bill, so both get saved. A new clerk searching the vendor list by a slightly different spelling finds nothing and creates a fresh record instead of asking.
Payments cause a second wave. A supplier sends a statement and the AP clerk pays it as a separate bill, even though the individual invoices were already entered. A payment run gets re-sent after a bank file fails, and the second run goes out before anyone checks whether the first one cleared. A credit note arrives and sits unapplied because the vendor record it belongs to is not the one the next invoice is posted against.
Re-keyed invoice numbers make it worse. INV-1043 and 1043 can both exist as separate bills against the same supplier, and neither system check will link them. The same thing happens with a leading zero dropped, a suffix added, or a credit memo entered as a positive bill.
None of this is a person being careless. It is what happens when vendor creation is open to everyone and the only check is whether the name looks familiar.
Finding them
Start with a name match that ignores punctuation and spacing. Pull the vendor list and sort it alphabetically, then read down the column. Duplicates cluster: two records with the same first six characters, one ending in "Ltd" and one in "Limited", one with a period after "Inc" and one without. Do this on a copy of the list so you can mark candidates.
Then match on anything that should be unique. A tax ID, a bank account number or a remit-to address belongs to exactly one supplier. Two vendor records sharing any of those are a duplicate until proven otherwise. This catches the records where the names look different but the money goes to the same place.
In Acumatica, the Duplicates tab on the Vendors (AP303000) form and the Check for Duplicates command help with this, but only when the Duplicate Validation feature is enabled on the Enable/Disable Features (CS100000) form. If that feature is off, you are working from the vendor list and your own matching.
Finally, look at the bills. Search for the same Vendor Ref. value appearing against more than one vendor. In Acumatica, the Raise an Error on Duplicate Vendor Reference Number check box on the Accounts Payable Preferences (AP101000) form makes the system raise an error when a document on the Bills and Adjustments (AP301000) form uses a Vendor Ref. value already used in the system. That error blocks the obvious re-key, though not the 1043 against INV-1043 case. The error is not raised for a correcting document created with Reverse, or for documents generated from the Recurring Transactions (AP203500) or Generate Recurring Transactions (AP504000) forms, so those need a manual look. Setting Require Vendor Reference makes the Vendor Ref. box required for bills, which at least stops blank references piling up.
Merging vendors in Acumatica
Before you merge, decide which record survives. Keep the one with the longest history, the correct remit-to address and the open credits. Note every open bill, every unapplied credit and every payment on the record you plan to retire, so you can confirm afterwards that all of it moved.
Acumatica can merge a vendor only with a duplicate record of the Business Account type, from the Duplicates tab of the Vendors (AP303000) form. Vendors cannot be merged with other vendors. If the record you want to absorb is a different account type, the merge will not run, and you need to deal with the open items another way. Check Acumatica's own help for what happens to individual documents after a merge rather than assuming.
A worked case: Northwind Supply Co. has three open bills and an unapplied credit of $840. Northwind Supply Company has one bill for $1,200 and a payment of $1,200 already issued. If you merge the first into the second, the $840 credit should now be visible against the live record. Apply it to the $1,200 bill and the cash out drops to $360. That credit was sitting there the whole time, invisible because it was attached to the wrong record.
Do the merge in a quiet period, not the day before a payment run. Reconcile the supplier statement immediately afterwards, and ask the supplier to confirm the balance in writing.
Keeping the vendor list clean
Restrict vendor creation to a small group. Most duplicate records exist because anyone could add one. If a buyer or a department head needs a new supplier, they should send a request with the W-9 or equivalent, the bank details and the remit-to address, and AP should create the record once.
Search before you create. Search on the tax ID and on the first few characters of the name, not the full name. If you find a near match, open it and check the address before deciding it is different.
Run a duplicate check on a fixed schedule, monthly is enough for most teams, and always before a payment run that includes new suppliers. Keep a short list of known name variants for your largest suppliers so new clerks can see them.
When a duplicate payment does slip through, ask the supplier for a credit or a refund the same week, and record the credit against the surviving vendor record so it does not become unapplied cash. Compare the cost of chasing it with your own cost of funds before deciding how hard to push on a small balance.
On a bill in Acumatica, the supplier's invoice number goes in the Vendor Ref. field. Any paid-bills export that includes it, the vendor, dates and amounts can be checked for duplicates.
Questions
Can I merge two vendors in Acumatica?
Yes, but only a vendor with a duplicate record of the Business Account type, from the Duplicates tab of the Vendors (AP303000) form. Vendors cannot be merged with other vendors. The Duplicates tab and the Check for Duplicates command require the Duplicate Validation feature to be enabled on the Enable/Disable Features (CS100000) form.
How do I stop the same invoice number being entered twice in Acumatica?
Turn on the Raise an Error on Duplicate Vendor Reference Number check box on the Accounts Payable Preferences (AP101000) form. Acumatica then raises an error when a document on the Bills and Adjustments (AP301000) form uses a Vendor Ref. value already used in the system. Set Require Vendor Reference as well so the Vendor Ref. box cannot be left blank.
Does the duplicate invoice number check catch every case?
No. The error is not raised for a correcting document created with Reverse, or for documents generated from the Recurring Transactions (AP203500) or Generate Recurring Transactions (AP504000) forms. It also will not catch INV-1043 entered against one vendor and 1043 against another, so match on vendor, amount and date windows as well.
What should I do with an unapplied credit on a duplicate vendor record?
Merge the duplicate into the record you are keeping, then confirm the credit is visible and apply it to the open bill. If the merge cannot run because the account types differ, check Acumatica's own help for the right handling and keep a note of the credit until it is applied or refunded.
Updated Nov 18, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.