/
/
Check whether overdue Rillet customers have been called
For finance and collections teams who want call history next to overdue Rillet invoices, just by asking their AI assistant.
On this page
Connector
Connect Contivio, pick your AI tool and paste the prompt.
The problem
Collections chase without knowing who has been called
Overdue invoices sit in Rillet and call history sits in Contivio. Without checking both, some customers get repeat calls while others are never contacted.
Without PopdockAI
- Pull overdue invoices from Rillet and total them per customer
- Look up each customer name
- Search Contivio for calls to each one
- Compare the lists and spot who was missed
With PopdockAI
- Overdue invoices are totalled and ranked for you
- Calls are matched by customer id, never by guessing
- Calls in the window and the latest result are shown
- Uncontacted customers are listed 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 overdue invoices in Rillet and check Contivio for calls to or from each in the last `{lookback-days}` days (default 30), for up to `{max-customers}` customers (default 10).
**Step 1: Find overdue invoices**
Call `rillet-get-invoices` and keep rows where `overdue` is true and `amount-due` is above zero. Group by `customer-id` and total `amount-due`. Rank by total, largest first, and keep the top `{max-customers}`.
**Step 2: Name the customers**
Call `rillet-get-customers` and attach `name` to each kept `customer-id`.
**Step 3: Check call contact**
For each kept customer, call `contivio-get-call` with `customer-id` set to that id and `start-time.from` set to the start of the window. Count calls, and note the latest `start-time`, `direction` and `result`.
**Step 4: Report**
A table: customer, overdue total, oldest `due-date`, invoice count, calls in window, latest call date and result. Below it, list customers with overdue balances and no calls in the window as the ones nobody has contacted.
**Rules & Guidelines:**
* `rillet-*` tools are on the rillet server; `contivio-*` tools are on the contivio server. Both servers must be connected.
* Read-only. Do not call any rillet add, update, apply, unapply, record or setup tool, and do not change anything in either system.
* Rillet customer-id is passed to `contivio-get-call` as its `customer-id` filter. Contivio calls carry no customer name, so match by customer-id only, never by guessing from names or phone numbers.
* Use ISO dates (YYYY-MM-DD) for date filters.
**Validation:**
* If either server returns nothing or an error, say which one and stop; do not fill in numbers.
* If no calls come back for a customer-id, report that customer as having no recorded calls and continue; do not assume the id format differs.
* Report only values present in the returned fields.Who it's for
One answer, three teams that use it
Collections specialists
Prioritize who to call today
See the largest overdue balances with the last call next to each, so you start with customers nobody has spoken to.
Show my top 10 overdue Rillet customers and whether Contivio has calls in the last 14 days.
Finance managers
Check collection effort
Review whether calls are reaching the customers owing the most, before a cash review.
Of the Rillet customers with overdue invoices, who has no recorded Contivio call in 30 days?
Contact center supervisors
Avoid repeat calls
See which overdue customers were already phoned recently, so the team does not call the same people twice.
For the top 15 overdue Rillet customers, which already had a Contivio call this month?
How it works
What PopdockAI does when you ask
You set the size of the check. Your AI assistant reads Rillet and Contivio, matches on customer id, and reports. It only reads, and stops if either system returns nothing.
Ask
You set how many customers to check and how many days of calls to look at.
Rank
It finds overdue Rillet invoices, totals them per customer and keeps the largest balances.
Match
It checks Contivio for calls to each customer by customer id.
Report
You get a table with calls and results, and a list of customers nobody has contacted.
What PopdockAI provides
The tools behind the answer
Ready made tools for Contivio and one secure connection to your AI tool. No code, no exports.
rillet-get-invoices
rillet-get-customers
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
Chase the customers nobody has called
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)
