/
/
Find 2Checkout orders that were never invoiced in Rillet
For finance teams who ask their AI assistant which 2Checkout orders have no matching invoice in Rillet.
On this page
Connector
Connect 2Checkout, pick your AI tool and paste the prompt.
The problem
Sales that never become recognised revenue
Finance checks each 2Checkout order against Rillet by hand. A sale never invoiced in Rillet is not recognised as revenue, and the only link is an order reference typed into an invoice number or memo.
Without PopdockAI
- Export orders from 2Checkout
- Search Rillet invoices for each reference
- Check number, purchase order and memo fields
- Miss the order that was never invoiced
With PopdockAI
- Orders read from 2Checkout, test orders excluded
- Rillet invoices matched on reference in three fields
- Orders with no invoice and amount mismatches listed
- Several possible invoices listed, never picked
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find 2Checkout orders (optionally for billing last name `{billing-last-name}`, up to `{max-records}` orders, default 25) that have no invoice in Rillet.
**Step 1: Read orders from 2Checkout**
Call `2checkout-get-order` with `billing-last-name` set to `{billing-last-name}` if given and `max-records` set to `{max-records}` (25 if empty). Keep `reference-number`, `order-date`, `status`, `currency`, `gross-discounted-price`, `external-reference`, `billing-first-name`, `billing-last-name` and `test-order`. Exclude orders where `test-order` is true and count them.
**Step 2: Read invoices from Rillet**
Call `rillet-get-invoices` (no filters, read all rows). Keep `invoice-id`, `invoice-number`, `purchase-order-number`, `memo`, `customer-id`, `total`, `currency` and `status`.
**Step 3: Match**
An order is invoiced when its `reference-number` or `external-reference` appears in a Rillet `invoice-number`, `purchase-order-number` or `memo`. For matches, compare `gross-discounted-price` with `total` and flag any difference or currency mismatch.
**Step 4: Report**
Give three lists: orders with no Rillet invoice (reference, date, buyer, amount), matched orders with an amount or currency mismatch, and matched orders in agreement (count only). Note that invoices created outside this link will show up as missing.
**Rules & Guidelines:**
* Tools whose names start with 2checkout belong to the 2checkout server and tools whose names start with rillet belong to the Rillet server. Both servers must be connected.
* The join is the order reference carried in the Rillet invoice number, purchase order number or memo. It is a text match, not a key, so say how many matches were made on each field.
* This is read-only: never call any 2checkout action tool (any 2checkout tool that adds, updates, cancels, refunds, enables, disables or renews) and never call any Rillet tool that adds, updates, applies, unapplies, records or sets, such as `rillet-add-customer`, `rillet-add-invoice-ar-only`, `rillet-add-invoice-revenue-only`, `rillet-add-invoice-payment`, `rillet-add-credit-memo`, `rillet-update-customer`, `rillet-update-invoice` and `rillet-set-invoice-sent-status`.
**Validation:**
* If `2checkout-get-order` returns nothing, say so and stop.
* If `rillet-get-invoices` returns nothing, report every order as missing and say Rillet has no invoices.
* If a reference appears on more than one invoice, list them and do not pick one.Who it's for
One answer, three teams that use it
Revenue accountants
Recognise every sale you made
Find orders with no Rillet invoice before revenue is understated.
Which of the last 50 2Checkout orders have no invoice in Rillet?
Billing specialists
Fix invoices that disagree with the order
Matched orders with an amount or currency mismatch are listed for correction.
Show 2Checkout orders for the customer Nguyen whose Rillet invoice amount differs.
Controllers
Check order coverage before close
A count of orders in agreement tells you how complete invoicing is.
How many recent 2Checkout orders are matched to a Rillet invoice, and which are not?
How it works
What PopdockAI does when you ask
You ask for the check and your AI assistant matches each 2Checkout order reference to Rillet invoices. It says how each match was made and changes nothing.
01
Ask
You ask for the check, optionally for one billing last name and a maximum number of orders.
02
Read orders
It reads 2Checkout orders and excludes test orders.
03
Match
It reads Rillet invoices and matches the order reference in the number, purchase order or memo.
04
Report
It lists orders with no invoice and matched orders with amount or currency differences.
What PopdockAI provides
The tools behind the answer
Ready made tools for 2Checkout and one secure connection to your AI tool. No code, no exports.
2checkout-get-order
rillet-get-invoices
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 order invoiced, or flagged
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)
