/
/
Match Chargebee invoices to PowerGP Online sales documents
For sales operations and billing teams who want subscription invoices tied to GP documents by asking their AI assistant.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
PO numbers are the only link, and they live on two screens
Chargebee invoices should tie back to the GP sales documents that billed the same work, and the only link is the purchase order number. Matching by hand means reading PO numbers off two screens, so differences and orphans slip through.
Without PopdockAI
- Read PO numbers off Chargebee invoices
- Search GP sales documents for each PO
- Compare amounts by hand
- Miss invoices with no PO and POs with no document
With PopdockAI
- Chargebee invoices with a PO number are read
- Each is matched to a PowerGP Online sales document by customer PO
- Amount differences are shown, with shared POs summed
- Orphans on both sides 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:** Match Chargebee invoices from the last {lookback-days} days (default 60) with the PowerGP sales documents that billed the same work, using the purchase order number, for {customer} if given.
**Step 1: Chargebee invoices**
Call `chargebee-get-invoice` (chargebee) with `date.from` set to the lookback start and `customer-id` if the customer was resolved with `chargebee-get-customer` (`company.contains`). Keep invoices that have `po-number`. Record `id`, `po-number`, `total`, `date`, `status`.
**Step 2: PowerGP documents**
Call `powergp-online-get-salesdocuments` (powergp-online-ai) with `document-date.from` set to the lookback start, and `customer-name.contains` if a customer was given. Match each invoice to a document whose `customer-po` equals `po-number` (ignore case and spaces). If you need the lines, call `powergp-online-get-salestransactions` with the matched `document-number`.
**Step 3: Report**
Table of invoice id, po-number, Chargebee total, PowerGP document-number and document-amount, and the difference. List invoices with no PO number, and PO numbers with no PowerGP document.
**Rules & Guidelines:**
* Tools prefixed powergp-online- belong to the powergp-online-ai server; tools prefixed chargebee- belong to the chargebee server. Both servers must be connected.
* Read-only: call only the get tools named above. Never create, change or delete anything in either system.
* Never print card or bank details; report ids, names and amounts only.
**Validation:**
* If no invoice has a PO number, say so and stop.
* If several PowerGP documents share a PO, show them all and compare the sum.Who it's for
One answer, three teams that use it
Sales operations
Tie every invoice to its order
Each Chargebee invoice is set against the GP sales document with the same PO, with any difference shown.
Match Chargebee invoices from the last 30 days to PowerGP sales documents by PO number.
Billing specialists
Find invoices with no PO
Invoices that carry no PO number are listed, so you can chase the missing reference.
Which Chargebee invoices for Contoso this quarter have no PO number?
AR accountants
Explain amount differences
Invoice total, GP amount and the difference sit together, ready for review before close.
Show Chargebee invoices where the PowerGP sales document amount differs, for the last 90 days.
How it works
What PopdockAI does when you ask
You give a look-back window and your AI assistant matches Chargebee invoices to PowerGP Online sales documents by PO. It stops if no invoice has a PO number.
01
Ask
You give a look back window and, optionally, a customer.
02
Read
It reads Chargebee invoices that carry a PO number.
03
Match
It finds the PowerGP Online sales document with the same customer PO.
04
Report
You get totals, differences, invoices without a PO and POs without a document.
What PopdockAI provides
The tools behind the answer
Ready made tools for Chargebee and one secure connection to your AI tool. No code, no exports.
chargebee-get-invoice
chargebee-get-customer
powergp-online-get-salesdocuments
powergp-online-get-salestransactions
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
Invoice and sales document mismatches in one pass
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)
