Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 9, 2026
Question

Why searching by Num (Number) in the filter, and entering numbers separated by a comma does not work?

  • February 9, 2026
  • 1 reply
  • 4 views
Invoice list. Why searching by Num (Number) in the filter, and entering numbers separated by a comma does not work?

1 reply

Morgan_B
QuickBooks Team
February 9, 2026

Thanks for posting your question here in the Community, Fuad2.

 

You've come to the right place for assistance. I'm happy to provide some info about searching for invoices in your QuickBooks Online account.

 

Searching by invoice number in QuickBooks Online (QBO) International, and most other QBO versions, by entering multiple numbers separated by a comma in a single filter field often fails because the search function treats the entire string as a single, exact alphanumeric identifier rather than a list of individual numbers. 

 

Here are a few reasons why this function isn't operating as your may expect:

 

  • Exact Match Requirements: The "Invoice no." filter expects an exact match for one invoice number, including any prefixes, suffixes, or alphanumeric characters. Including a comma (e.g., 1001,1002) causes the system to search for an invoice literally named "1001,1002".
  • Delimiter Conflicts: In many international settings, commas are used as thousands separators or decimal points rather than list separators. QBO may misinterpret the comma.
  • Search Limitations: The basic search bar at the top right is designed for quick access to a single transaction. Advanced search functionalities are usually required for complex filtering. 

 

Alternatively, you can use these methods to find multiple invoices:

 

  1. Use the "Contains" Filter: In the Advanced Search window, change the filter from "Equals" to "Contains". This may work for numerical sequences if you only search for a partial string.
  2. Export to Excel/Spreadsheet: Go to the Sales or Invoices tab, export the full list of invoices, and filter the invoice number column within Excel or Google Sheets to find your specific list.
  3. Use the Advanced Search Report:
    • Click the Magnifying Glass (search icon).
    • Select Advanced Search.
    • Set the filter to Invoice.
    • Add multiple filters for Invoice Number using the "Equals" function for each, or use Transaction Date filters to narrow down a range. 

 

The following article provides additional info about adding custom transaction numbers to sales forms in QuickBooks Online.

 

Please don't hesitate to drop a comment below if you have any other questions. I'll be here to help in any way that I can.