/
/
Find overdue NetSuite invoices that no one is chasing
For finance and collections teams who want to ask their AI assistant which overdue NetSuite receivables have no TickTick follow-up task.
On this page
Connector
Connect Oracle NetSuite, pick your AI tool and paste the prompt.
The problem
Overdue invoices with nobody chasing them
Collections staff read the NetSuite aging report, then check their TickTick list by hand to see who is chasing what. Overdue invoices slip through with no one assigned, and the balance stays unpaid longer than it should.
Without PopdockAI
- Run the NetSuite aging report
- Search TickTick for each overdue invoice
- Guess at matches by customer name
- Leave some balances with no follow-up
With PopdockAI
- Overdue receivables with a balance are read from NetSuite
- Open TickTick tasks are searched by document number, then customer
- Unchased items are listed with their total balance
- Nothing is changed in NetSuite or TickTick
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find open accounts receivable items in NetSuite that are past due as of `{as-of-date}` (default today) and report which have no open follow-up task in TickTick, limited to the customer `{customer}` when given.
**Step 1: Read overdue receivables (NetSuite)**
Call `netsuite-get-aropenitem` with `due-date.to` set to the as-of date, adding `customer` when `{customer}` is given and `max-records` of 100. Keep rows where `amount` minus `amount-applied` is greater than zero. If none, say so and stop.
**Step 2: Find follow-up tasks (TickTick)**
For each item call `ticktick-get-tasks` with `title.contains` set to the item's `document-number` and `status` open. If nothing matches, retry once with `title.contains` set to the `customer` name.
**Step 3: Report**
A table with `document-number`, `customer`, `due-date`, open balance, days overdue, and the matching task title, due date and project (or NONE). Order by days overdue, then list the NONE rows separately with a total balance.
**Rules & Guidelines:**
* `netsuite-get-aropenitem` is on the NetSuite server; `ticktick-get-tasks` is on the TickTick server.
* This prompt is read-only. Do NOT call any TickTick write tool (`ticktick-add-task`, `ticktick-update-task`, `ticktick-complete-task`, `ticktick-add-comment`, `ticktick-delete-task`, `ticktick-move-task`, `ticktick-batch-tasks`) or any NetSuite add or update tool.
**Validation:**
* If a document number matches several tasks, list them all and do not pick one.
* If TickTick returns nothing for the whole run, say the follow-up tasks may use a different naming convention.Who it's for
One answer, three teams that use it
Collections specialists
See what you are not chasing
Unchased overdue invoices are listed with their total balance, so you know where to start the day.
Which overdue NetSuite invoices have no open task in TickTick as of today?
AR managers
Check follow-up coverage
See days overdue and the matching task for each invoice, so gaps in the team's follow-up are clear.
Show overdue NetSuite receivables as of 30 September 2026 and whether each has a TickTick task.
Account managers
Check one customer before a call
Filter to a customer to see their overdue invoices and whether anyone is already following up.
Does Fabrikam have any overdue NetSuite invoices with no follow-up task in TickTick?
How it works
What PopdockAI does when you ask
You give an as-of date, and a customer if you like, and your AI assistant checks each overdue invoice for an open TickTick task. It never picks between several matching tasks and only reads.
01
Ask
You give an as-of date and, if you like, a customer.
02
Read
It lists overdue NetSuite receivables that still have a balance.
03
Match
It searches open TickTick tasks by document number, then by customer name.
04
Report
It shows days overdue and matching tasks, then lists items with no task and their total.
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-aropenitem
ticktick-get-tasks
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
Every overdue invoice has someone chasing it
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)
