NetSuite Admin Tip | List Customers with the Most Invoices Using SuiteQL

Ever wondered which customers in your NetSuite account have the most Invoices? With SuiteQL, you can easily find out by running a simple SQL query that counts all Invoices per Customer and ranks them from highest to lowest.

This quick tip helps administrators and finance teams identify top invoiced customers, monitor billing activity, and gain valuable insights into customer engagement trends.

SQL Query:

SELECT
  c.entityid,
  COUNT(t.id) AS number_of_invoices
FROM
  customer c
JOIN
  transaction t ON t.entity = c.id
WHERE
  t.type = 'CustInvc'
GROUP BY
  c.entityid
ORDER BY
  number_of_invoices DESC

• customer c