Business Central can insist that every purchase invoice carries the vendor's invoice number. Whether that number is typed the same way every time is up to your team.
Business Central can make the vendor invoice number mandatory, which helps, but formatting differences, different dates and duplicate vendor records still get through. Open vendor ledger entries in Excel and test for numbers typed differently, same amount and date, repeats within 30 days and two vendor cards.
In Purchases & Payables Setup, the Ext. Doc. No. Mandatory field makes it impossible to post a purchase invoice, credit memo or vendor journal line without the vendor's own document number in the Vendor Invoice No. or External Document No. field.
That matters: a duplicate check that can compare invoice numbers needs every invoice to have one.
Open Vendor Ledger Entries, filter Document Type to Invoice and the posting date to at least the last 12 months, and open the list in Excel. Keep the vendor, external document number, document date and amount columns. Include closed (paid) entries as well as open ones.
Your system's own check compares fields exactly. Real duplicates usually differ in one small way, so test the export four ways:
The free Online Duplicate Invoice Checker runs all four on up to 1,000 lines in your browser, shows the value at risk and lists each flagged line next to the line it matches. Nothing is uploaded. If you prefer formulas, How to find duplicate invoices in Excel shows how to build the same tests yourself.
Switch on Ext. Doc. No. Mandatory if it is off, and agree that the vendor's invoice number is always typed exactly as printed. Block or merge duplicate vendor cards. Then keep the four tests as a regular check, because no setting connects two invoices that were keyed differently.
Hold every HIGH flag that is still unpaid until someone has compared the two documents. For REVIEW flags, confirm whether it is a genuine repeat charge and note why. If a duplicate has already been paid, ask the supplier for a refund or a credit note straight away and track it until the money is back: the duplicate payment audit guide covers the recovery steps.
Run the check before every payment run, not once a year. Duplicates are usually keyed weeks apart, so always include at least the previous 12 months of bills, not just the invoices in this run.
Business Central uses "vendor" in every localisation; UK teams may say supplier. The setup and the tests are the same.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste or upload your invoice list and see likely duplicates in seconds. Runs in your browser; nothing is uploaded.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
Only if Ext. Doc. No. Mandatory is selected in Purchases & Payables Setup. Then invoices, credit memos and vendor journal lines can't be posted without one.
Vendor Ledger Entries, filtered to invoices over at least 12 months, opened in Excel.
Yes. A number typed differently, a different date or a second vendor card all get past it, which is what the four tests catch.
Last updated 03 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.