NetSuite can warn about, or block, a repeated document number. It still has no idea that INV-00123 and 123 are the same invoice.
NetSuite's Duplicate Number Warnings preference can warn about or block a bill whose document number is already used, but it only compares the number exactly. Export your bills with a saved search and test for numbers typed differently, same amount and date, repeats within 30 days and duplicate vendors.
NetSuite has a preference called Duplicate Number Warnings under Setup > Accounting > Preferences > Accounting Preferences, on the Items/Transactions subtab. It has three settings:
Create a saved search on transactions, filtered to bills, with columns for vendor, the vendor's reference number, date and amount. Set the date range to at least the last 12 months, run it and export the results to Excel or CSV. Include bills that are already paid.
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.
If you can, set Duplicate Number Warnings to Warn and Block. Agree a single format for entering the vendor's invoice number, exactly as printed, so the check has a chance to work. Then keep the four tests as a regular check, because the preference will never catch a number typed two ways.
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.
NetSuite uses "vendor bills" in every region. UK teams may call them purchase invoices; the check is the same.
Audits the supplier master file with an on-device AI and 28 tests: lookalike duplicates written differently, bank-detail changes before payments, vendors matching employees, and a risk score for every vendor. 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 Duplicate Number Warnings is set to Warn and Block, and only when the document number matches exactly.
Users with the Accounting Preferences permission, under Setup > Accounting > Preferences > Accounting Preferences.
Bills only, with vendor, the vendor's reference number, date and amount, over at least 12 months including paid bills.
Last updated 03 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.