/
/
Rank your top NetSuite customers by net revenue
For leaders who ask their AI assistant who the biggest customers were over a period, after cash sales and credits.
On this page
Connector
Connect Oracle NetSuite, pick your AI tool and paste the prompt.
The problem
Top customer lists built from three exports
Building a top customer view means exporting NetSuite invoices, cash sales and credit memos, then netting them per customer in a spreadsheet. It is slow, and one missed export quietly changes who looks like the biggest customer.
Without PopdockAI
- Export invoices, cash sales and credit memos
- Net them per customer in a spreadsheet
- Work out each customer's share of the total
- Miss one export and rank the wrong customer first
With PopdockAI
- Invoices, cash sales and credit memos are read for the period
- They are netted per customer, valuing credits where possible
- Customers are ranked with shares and the top three share
- A row limit warning when totals may be understated, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Rank customers by net revenue between {date-from} and {date-to} (default the last 90 days), listing the top {top-n} (default 10).
**Step 1: Collect**
Call `netsuite-get-invoice`, `netsuite-get-cashsale` and `netsuite-get-creditmemo` with `date.from` and `date.to`. Use `total` for invoices and cash sales. For credit memos, use the amount if the tool returns one and otherwise report that credits could not be valued.
**Step 2: Net**
Add per customer: invoice totals plus cash sales, less credits where valued.
**Step 3: Report**
A ranked table of customer, invoiced, cash sales, credits, net, and share of total. Give the grand total and the share held by the top three. Mention any result that hit the row limit, since totals then understate revenue.
**Rules & Guidelines:**
* This is a read-only job. Do not call any tool whose name starts with netsuite-add- or netsuite-update-, and never change, create or delete a record.
* Report only what the tools return. Do not estimate or invent figures; if a total is needed, add up the rows you actually retrieved and say so.
* If a read returns the maximum number of rows, say the result may be truncated and suggest narrowing the filters.
* Dates are YYYY-MM-DD. Where an input is blank, use the default stated in the Objective.
**Validation:**
* If a read returns nothing, say so and stop rather than guessing.
* If an input is ambiguous, list the candidates and ask which one is meant.Who it's for
One answer, three teams that use it
Executives
Know your biggest customers
See the top customers by net revenue for any period, with their share of the total.
Who were our top 10 customers by net revenue in NetSuite this year?
Sales directors
Check account concentration
The top three share shows how dependent revenue is on a few customers.
What share of NetSuite net revenue came from our top three customers last quarter?
Finance analysts
Net out credits per customer
Invoices and cash sales are netted against credit memos, so the ranking reflects real revenue.
Rank NetSuite customers by net revenue from 1 July to 30 September, after credit memos.
How it works
What PopdockAI does when you ask
You give a date range and how many customers to list, and your AI assistant nets NetSuite revenue per customer. It says when a credit could not be valued or a result hit the row limit.
01
Ask
You give a date range and how many customers to list.
02
Collect
It reads invoices, cash sales and credit memos for the period.
03
Net
It adds invoices and cash sales per customer and subtracts credits where they could be valued.
04
Report
You get a ranked table with shares, and a note if any result hit the row limit.
What PopdockAI provides
The tools behind the answer
Ready made tools for Oracle NetSuite and one secure connection to your AI tool. No code, no exports.
netsuite-get-invoice
netsuite-get-cashsale
netsuite-get-creditmemo
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
A ranked top customer view without the spreadsheet
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
