Acumatica · Duplicate payments

Duplicate payments in Acumatica: what it checks and what gets through

Acumatica can flag a re-used vendor reference number, but it won't catch a duplicate entered under a different reference or a statement paid twice.

What Acumatica's documentation says

  1. 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 1 (opens in a new tab)
  2. 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 2 (opens in a new tab)
  3. The AP Register (AP621500) report lists released AP documents by vendor and period, and the AP Payment Register (AP622500) shows released AP payments. Source 3 (opens in a new tab)
  4. The Vendor Details (AP402000) form shows a vendor's bills, debit adjustments, credit adjustments and payments, open by default, with Show All Documents and Include Unreleased Documents to widen the list. 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.

What Acumatica checks for you

Acumatica has one specific check for duplicate vendor references. On the Accounts Payable Preferences (AP101000) form, the Raise an Error on Duplicate Vendor Reference Number check box 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 is the supplier invoice number field on the bill. If a clerk types INV-1043 on a second bill for the same vendor, Acumatica stops the save.

The check has exceptions you should know. 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 a reversal, or a recurring bill template, can carry a Vendor Ref. that already exists without the error firing. If you want the Vendor Ref. box to be required on every bill, turn on Require Vendor Reference in the same preferences area.

For review, the AP Register (AP621500) report lists released AP documents by vendor and period, and the AP Payment Register (AP622500) shows released AP payments. The Vendor Details (AP402000) form shows a vendor's bills, debit adjustments, credit adjustments and payments, open by default, with Show All Documents and Include Unreleased Documents to widen the list. Those are the places to look when you suspect a duplicate has already been released.

That is the full extent of the built-in duplicate control. It is a reference-number check, not a duplicate-payment detector. It compares the Vendor Ref. value, not the amount, the date, the invoice line or the payment. Everything else depends on how your team enters and reviews bills.

What gets through

The most common miss is a re-keyed invoice number. A supplier sends INV-1043. One clerk enters it as INV-1043 and another enters 1043, or adds a suffix like INV-1043-A after a credit note. Acumatica sees two different Vendor Ref. values and raises no error. The same thing happens with leading zeros, spaces and punctuation. The bill is paid twice and the check never had a chance.

A second miss is the same supplier set up twice in the vendor record. If the supplier exists under two vendor IDs, the Vendor Ref. check runs per vendor, so the same invoice number can be used once under each ID. A payment run then picks up both bills. Look for near-identical vendor names, the same remit-to address and the same tax ID when you review new vendor requests.

Statements are another route. A supplier statement lists invoices you have already entered and paid. If someone treats the statement as a bill and enters it, or pays the statement total as well as the individual invoices, you have an overpayment. Acumatica has no check that compares a statement to open bills. That is a manual reconciliation step.

Re-sent payment runs and unapplied credits cause their own duplicates. If a payment file is generated twice and both are released, the supplier is paid twice. If a credit note arrives and is never applied to a bill, the next payment goes out at the full amount. Neither shows up as a duplicate reference, because the reference is fine. The money is simply wrong. Check Acumatica's own help for what happens to a bill after a void, and for how voided payments appear on the registers, rather than assuming.

Finding duplicates already paid

Start with a match on vendor, amount and a date window. Pull the AP Register (AP621500) for the period and sort by vendor and amount. Two released bills with the same vendor and the same amount within a few weeks of each other are worth a look, even when the Vendor Ref. values differ. Do the same on the AP Payment Register (AP622500) to catch two payments of the same amount to the same vendor.

Then open Vendor Details (AP402000) for the suspects. The form shows bills, debit adjustments, credit adjustments and payments, open by default. Turn on Show All Documents and Include Unreleased Documents to widen the list so a paid bill and a still-open copy both appear. Read the Vendor Ref. values side by side. INV-1043 and 1043 will sit there as two separate documents, and you can see which payments cleared.

Reconcile the supplier statement next. Ask the supplier for a statement covering the period and tick each invoice against your bill list. Anything on the statement that you have paid but cannot match to a single bill is a candidate. Anything you paid twice shows as a duplicate on their side too, and most suppliers will confirm it.

When you find a duplicate, ask the supplier for a credit or a refund in writing. Record the credit in Acumatica and apply it to the next bill, or hold it until the refund arrives. Keep a simple log of what was found, the amount, the supplier and the recovery status, so the controller can see the total. General rule on the cash side: compare any recovery cost with your own cost of funds before deciding how hard to chase small amounts.

Preventing the next one

Turn on both settings in Accounts Payable Preferences (AP101000): Raise an Error on Duplicate Vendor Reference Number and Require Vendor Reference. That closes the easiest gap, the blank or missing Vendor Ref. It does not close the re-keyed number, so add a rule for your team: enter the supplier invoice number exactly as printed, with no suffixes, and put any internal note in a different field. Agree on how to handle leading zeros and punctuation, and write it down.

Control vendor master changes. One person requests a new vendor, another approves it, and someone checks for an existing record with the same name, address or tax ID before it is created. A duplicate supplier record defeats the Vendor Ref. check entirely, so this step matters more than any single setting.

Separate bill entry from payment release, and review the payment run before it goes out. Open the AP Payment Register (AP622500) for the proposed run and scan for the same vendor and amount appearing twice. If a payment file is re-sent, confirm the first file was not released before generating the second. On the credit side, review open credit adjustments weekly and apply them to the next bill rather than letting them sit.

Finally, reconcile supplier statements on a schedule, not only when a supplier calls. A monthly statement check catches the statement-paid-as-a-bill case and the unapplied credit before they age. None of this removes the need to look. It gives you a short list to look at.

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

How does Acumatica detect duplicate vendor reference numbers?

On the Accounts Payable Preferences (AP101000) form, the Raise an Error on Duplicate Vendor Reference Number check box makes Acumatica raise an error when a document on Bills and Adjustments (AP301000) uses a Vendor Ref. value already used in the system. 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.

Why did Acumatica allow a duplicate bill with a different invoice number?

The check compares the Vendor Ref. value only. If the first bill was entered as INV-1043 and the second as 1043, Acumatica sees two different values and raises no error. Matching on vendor, amount and a date window in the AP Register (AP621500) is how you catch that case.

Where can I see a vendor's bills and payments in Acumatica?

The Vendor Details (AP402000) form shows a vendor's bills, debit adjustments, credit adjustments and payments, open by default. Use Show All Documents and Include Unreleased Documents to widen the list. The AP Register (AP621500) lists released AP documents by vendor and period, and the AP Payment Register (AP622500) shows released AP payments.

Does Acumatica stop a supplier statement being paid as well as the invoices?

No. There is no built-in check that compares a supplier statement to open bills, so paying a statement total on top of the individual invoices gets through. Reconcile statements manually each month and ask the supplier for a credit or refund when you find a double payment.

Updated Nov 17, 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.