Connectors

/

Rillet

/

Trace a Rillet credit memo to Contivio calls
Report
Cross-Connector

See the calls that came before a Rillet credit memo

For finance teams who want a credit memo traced to its invoice and the customer's Contivio calls in the days before it.

Try PopdockAI free
Get a live demo
Trace a Rillet credit memo to Contivio calls
Trace credit memo CM-2041 to the customer's calls in the 14 days before it was issued.
Credit memo CM-2041 for Contoso has 2 calls in the 14 days before its date, which is a timing observation only. - Credit memo: 640.00 USD, dated 2026-10-18 - Invoice: INV-1042, dated 2026-09-30, total 2,400.00 - Call 1: 2026-10-10, agent Sam Patel, Billing queue, handled - Call 2: 2026-10-15, agent Alex Morgan, Billing queue, handled Want the AI summaries of both calls?
Rillet
Sample figures. Your results come from your own account.
rillet-get-credit-memos
rillet-get-invoices
contivio-get-call

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

Connect Rillet, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Nobody can see why a credit memo was issued

To explain a credit memo, finance has to find the invoice and then search call records by hand for the same customer. Without the calls the reason is often a guess.

Without PopdockAI

  • Find the credit memo and its invoice in Rillet
  • Note the customer and the credit date
  • Search call records for that customer by hand
  • Guess which conversation led to the credit

With PopdockAI

  • The credit memo and invoice are found by number
  • Calls are matched by customer id only, never by name
  • Each call is listed with its AI summary
  • Timing is reported and cause is never claimed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** For credit memo `{credit-memo-number}` in Rillet, find calls from the same customer in Contivio within `{window-days}` days (default 14) before the credit memo date.

**Step 1: Find the credit memo**

Call `rillet-get-credit-memos` with `credit-memo-number` set to `{credit-memo-number}`. If it matches more than one, list them and stop. Note `customer-id`, `credit-memo-date`, `invoice-id`, `total`, `currency`.

**Step 2: Find the original invoice**

Call `rillet-get-invoices` and find the row whose `invoice-id` matches. Note `invoice-number`, `invoice-date` and `total`. If it is not found, say so and continue.

**Step 3: Find the calls**

Call `contivio-get-call` with `customer-id` set to the credit memo's `customer-id` and `start-time.from` set to `{window-days}` days before `credit-memo-date`, and keep calls on or before that date. Read `start-time`, `agent`, `queue`, `result`, `ai-short-summary`.

**Step 4: Report**

State the credit memo, the invoice it relates to, then each call in date order with its summary. Say whether any call falls in the window; do not state that a call caused the credit memo.
**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

Accounts receivable

Document why a credit was issued

Pair a credit memo with the invoice and the customer's calls just before it, so the file shows the context.

Trace credit memo CM-2077 to calls in the 14 days before its date.

Finance managers

Review credits with the conversation in view

Check whether the customer had contact in the run up to a credit, without anyone claiming that a call caused it.

For credit memo CM-2090 on Fabrikam, were there any calls in the 21 days before it was issued?

Auditors

Support a credit memo review

Gather the invoice and the matching calls for a sampled credit memo in one request, matched strictly by customer id.

Show the invoice and Contivio calls related to credit memo CM-2104 for Northwind Traders.

How it works

What PopdockAI does when you ask

You give a credit memo number 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 credit memo number and a window in days.

Your AI tool

Find

It finds the credit memo in Rillet and the invoice it relates to.

rillet-get-credit-memos
rillet-get-invoices
contivio-get-call

Match

It finds the customer's Contivio calls before the credit date, by customer id only.

No items found.

Report

You get the memo, the invoice and each call with its summary, and whether any fall in the window.

Your AI tool

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.

get-data

rillet-get-credit-memos

Returns customer credit memos (number, customer, invoice, totals) from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

contivio-get-call

Returns Contivio call records with durations, results, direction, queue, agent and AI call summaries, filterable by date, agent, queue and customer.
Read only.Nothing in Rillet Changes

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.

How Popdock AI secures your data

The outcome

Credit memos with their calls attached

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation