/
/
See which overdue customers nobody has called
For collectors and finance teams who want to compare overdue Intacct balances with Contivio calls, just by asking their AI assistant.
On this page
Connector
Connect Sage Intacct, pick your AI tool and paste the prompt.
The problem
Overdue customers get missed between systems
The overdue report lives in Intacct and the call history in Contivio. Collectors compare them by hand, customer by customer, so some overdue customers are never chased.
Without PopdockAI
- Run the overdue invoice report in Intacct
- Total each customer's balance
- Search the call log customer by customer
- Miss customers nobody has called
With PopdockAI
- Overdue invoices are totalled by customer
- The ten largest balances are checked for calls
- Last call, agent and result are shown
- It warns if calls carry no customer id and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find customers with invoices overdue by at least `{days-overdue}` days (default 30) and check in Contivio whether they have had any call in the last `{lookback-days}` days (default 30).
**Step 1: Find overdue invoices in Intacct**
Call `intacct-get-invoice` (Intacct server) with `due-date.to` set to today minus `{days-overdue}` days and `total-due.min` set to 0.01. Group the rows by `customer-id` and add up `total-due` per customer. Keep the ten customers with the largest totals.
**Step 2: Check each customer for calls in Contivio**
For each of those customers, call `contivio-get-call` (Contivio server) with `customer-id` set to the customer's `customer-id` and `start-time.from` set to the start of the lookback window. Count the calls and note the latest `start-time`, the `agent` and the `result`.
**Step 3: Report**
One table, largest balance first: customer name, customer id, overdue total, oldest due date, number of calls, last call date, last agent, last result. Then split the customers into two lists: no calls in the window (needs outreach) and called in the window.
**Rules & Guidelines:**
* `intacct-get-invoice` is on the Intacct server; `contivio-get-call` is on the Contivio server.
* Read-only. Do not call any `intacct-create-*` or `intacct-update-*` tool.
* Do not guess a customer's call history; zero calls means the Contivio call lookup returned nothing.
**Validation:**
* If Intacct returns no overdue invoices, say so and stop.
* If every customer shows zero calls, warn that the customer id may not be recorded on Contivio calls, and name one example id you searched with.Who it's for
One answer, three teams that use it
Collectors
Start with customers nobody has called
See the largest overdue customers with no recent calls so your first calls go where they matter most.
Which of our top overdue Intacct customers have had no Contivio calls in the last 14 days?
Credit managers
Check outreach on big balances
Review overdue customers and the date, agent and result of the last call, to judge whether chasing is on track.
Show customers over 60 days overdue in Intacct with their last Contivio call, largest balance first.
Finance controllers
Review collections effort
See how many of the biggest overdue balances have had phone contact in a period.
Of the 10 largest overdue Intacct balances over 30 days, how many were called in the last 30 days?
How it works
What PopdockAI does when you ask
You set how overdue and how recent, and your AI assistant combines Intacct invoices with Contivio calls. It only reads and will not assume zero calls when the data cannot support that.
Ask
You give how many days overdue and how many days of calls to check, both defaulting to 30.
Total
It adds up overdue Intacct invoices by customer and keeps the ten largest balances.
Check
It looks up each customer's Contivio calls in the period, with the latest agent and result.
Report
You get one table split into customers who need outreach and customers already called.
What PopdockAI provides
The tools behind the answer
Ready made tools for Sage Intacct and one secure connection to your AI tool. No code, no exports.
sage-intacct-get-invoice
contivio-get-call
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
Know who to call about overdue balances
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)
