/
/
Reconcile Chargebee invoices to Dynamics GP receivables
For finance teams who want billing and GP receivables to agree, just by asking their AI assistant about a customer.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Missing invoices in GP are found only at month end
Billing staff tick Chargebee invoices against Dynamics GP receivables line by line, relying on PO numbers, document numbers and amounts. Missing or mismatched invoices are found only at month end.
Without PopdockAI
- List the customer's Chargebee invoices
- List their receivables transactions in GP
- Match by PO, document number or amount by hand
- Find the gaps at month end
With PopdockAI
- Chargebee invoices and GP receivables are read for the period
- Matches use PO number, document reference, then amount
- One GP transaction is never matched to two invoices
- Totals per system and the net difference are shown, nothing added
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the customer `{customer-id}` compare Chargebee invoices with Dynamics GP receivables between `{date-from}` and `{date-to}` (default: the last 90 days). Use `{gp-company}` as the GP company when given.
**Step 1: Chargebee invoices**
Call `chargebee-get-invoice` (chargebee server) with `customer-id`, `date.from` and `date.to`. Keep id, date, total, amount-paid, amount-due, status, po-number and currency-code.
**Step 2: GP receivables**
Call `dynamics-gp-get-rm-trx` (dynamics-gp server) with `customer-id` (the same value; if nothing is returned, resolve the GP customer number with `dynamics-gp-get-rm-customer` using the customer name), `document-date.from` and `document-date.to`.
**Step 3: Match**
Match each Chargebee invoice to a GP transaction by `po-number` equal to `customer-po-number`, then by the Chargebee invoice id appearing in `document-number` or `document-description`, then by equal total against `document-amount` on a nearby date. Never match one GP transaction to two invoices.
**Step 4: Report**
Three lists: matched invoices with any amount difference, Chargebee invoices missing from GP, and GP invoice-type transactions with no Chargebee invoice. End with totals for each system and the net difference.
**Rules & Guidelines:**
* `chargebee-get-invoice` is on the chargebee server; `dynamics-gp-get-rm-trx` and `dynamics-gp-get-rm-customer` are on the dynamics-gp server.
* Read only. Do not call `dynamics-gp-rm-trx-add` or any other write tool.
* Ignore GP transactions whose void-status marks them voided, but count them separately.
**Validation:**
* If either side returns nothing, say which and stop after reporting the other side.
* If currencies differ, do not compare amounts; list the invoices unmatched by amount.Who it's for
One answer, three teams that use it
Billing specialists
Catch missing invoices early
Chargebee invoices missing from GP show up during the month, not at close.
Reconcile Chargebee invoices for contoso-014 to Dynamics GP for the last 30 days.
AR accountants
Find GP invoices with no source
GP invoices with no Chargebee invoice are listed for investigation.
Does Fabrikam have GP receivables with no matching Chargebee invoice since July?
Finance controllers
See the net difference per system
Totals per system and the net difference tell you if a customer is clean.
Give me totals in Chargebee and GP for northwind-002 this quarter and the net difference.
How it works
What PopdockAI does when you ask
You give a customer id and your AI assistant reconciles their Chargebee invoices to Dynamics GP receivables. Voided GP rows are counted separately.
01
Ask
You give a customer id and optionally a date range.
02
Read
It reads the Chargebee invoices and the GP receivables transactions.
03
Match
It matches by purchase order, document reference and then amount.
04
Report
You get matches, gaps on each side and totals per system.
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
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-customer
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
Missing and mismatched GP invoices found during the month
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)
