/
/
A customer's Rillet billing and Contivio calls on one timeline
For support agents who want a Rillet customer's invoices, payments, credit memos and recent calls in a single view.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Support sees billing or calls, rarely both
Agents flip between the finance system and the call system to see what a customer owes and who they have spoken to. One side is usually missed, so the full story never reaches one screen.
Without PopdockAI
- Find the customer and their invoices in Rillet
- Check credit memos and payments separately
- Search the call system by customer
- Merge it all by hand into a timeline
With PopdockAI
- The customer is confirmed in Rillet first
- Invoices, credit memos, payments and calls are gathered together
- Calls are matched by customer id only, never guessed
- A merged timeline and totals are reported
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a single view of customer `{customer-id}` combining billing in Rillet and call activity in Contivio, looking back `{lookback-days}` days (default 90).
**Step 1: Establish the customer in Rillet**
Call `rillet-get-customers` and find the row whose `customer-id` equals `{customer-id}`. If none matches, report that and stop. Note `name` and `payment-terms`.
**Step 2: Pull billing**
Call `rillet-get-invoices` and keep rows whose `customer-id` matches, with `invoice-date` inside the window. Call `rillet-get-credit-memos` with `customer-id` set to `{customer-id}`. For invoices, read `invoice-id`, `invoice-number`, `status`, `total`, `amount-due`, `overdue`. Optionally call `rillet-get-invoice-payments` and keep payments whose `invoice-id` is one of those invoices.
**Step 3: Pull calls**
Take `customer-id` and call `contivio-get-call` with `customer-id` set to it and `start-time.from` set to the start of the window. Read `start-time`, `direction`, `queue`, `agent`, `result`, `disposition`, `talk-duration-seconds`, `ai-short-summary`.
**Step 4: Report**
Give: customer name and terms; invoice count, total billed, total amount due, number overdue; credit memo count and total; call count, inbound vs outbound, and the most common `result`. Then a short timeline merging invoice dates, credit memo dates and calls in date order.
**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
Support agents
Handle a call knowing the account
See what the customer owes, what was credited and how often they have called, before you respond.
Summarize customer CUST-2210 for the last 60 days, billing and calls.
Finance operations
Review a customer's billing and contact
Check overdue counts, credit memos and calls in one view when preparing for a customer conversation.
For CUST-3307, how many invoices are overdue and how many calls did they make in 90 days?
Account managers
Prepare for a renewal conversation
Get a timeline of invoices, credits and calls for a customer, so you walk into the meeting knowing the history.
Build a billing and calls timeline for customer CUST-4120 over the last 90 days.
How it works
What PopdockAI does when you ask
You give a customer id and your AI assistant reads Rillet and Contivio. It calls no Rillet write action and stops if either system returns nothing.
Ask
You give a customer id and how many days to look back.
Confirm
It confirms the customer in Rillet and stops if the id does not match.
Gather
It collects invoices, credit memos and payments, then the customer's Contivio calls.
Report
You get totals for billing and calls and a merged timeline in date order.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
rillet-get-customers
rillet-get-invoices
rillet-get-credit-memos
rillet-get-invoice-payments
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
The customer story in one timeline
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)
