/
/
Check Chargebee payments were applied in Dynamics GP
For finance teams who want cash applied correctly, 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
Cash settled in billing sits unapplied in GP
Payments settled in Chargebee are not always applied to invoices in Dynamics GP, leaving cash unapplied and balances wrong. Checking means listing payments, then finding each receipt and its application in GP.
Without PopdockAI
- List successful Chargebee payments
- Find each cash receipt in GP
- Check whether the receipt was applied
- Leave unapplied cash on the books
With PopdockAI
- Successful Chargebee payments are read, failed ones counted
- GP applications and receivables are read for the customer
- Payments match by amount within five days or reference
- Missing and unapplied cash is listed and nothing is written
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}` check that payments recorded in Chargebee since `{date-from}` (default: the last 60 days) were applied in Dynamics GP. Use `{gp-company}` as the GP company when given.
**Step 1: Chargebee payments**
Call `chargebee-get-transaction` (chargebee server) with `customer-id`, `date.from`, and `status` for successful payments if that filter accepts it. Keep id, date, amount, amount-unused, reference-number, payment-method and gateway. Skip failed transactions but count them.
**Step 2: GP applications**
Call `dynamics-gp-get-rm-trx-apply` (dynamics-gp server) with `customer-id` and `document-date.from`. Also call `dynamics-gp-get-rm-trx` (dynamics-gp server) with the same customer and date to see unapplied cash receipts.
**Step 3: Match**
Match each Chargebee payment to a GP cash receipt by amount-applied or document-amount equal to the payment amount within 5 days, and by reference-number appearing in `document-number`.
**Step 4: Report**
List payments applied in both systems, payments in Chargebee with no GP receipt, payments in GP with no Chargebee transaction, and payments received but still unapplied (Chargebee `amount-unused` above zero, or a GP receipt with a current-transaction-amount above zero).
**Rules & Guidelines:**
* `chargebee-get-transaction` is on the chargebee server; `dynamics-gp-get-rm-trx-apply` and `dynamics-gp-get-rm-trx` are on the dynamics-gp server.
* Read only. Do not call any write tool on either server.
**Validation:**
* If nothing is returned on one side, report the other side and say so.
* If the currencies differ, list the payments without comparing amounts.Who it's for
One answer, three teams that use it
Cash application clerks
Apply what is still open
Payments received but unapplied in GP are listed, ready to apply.
Which Chargebee payments from contoso-014 are received but unapplied in Dynamics GP?
AR accountants
Find payments with no GP receipt
Chargebee payments with no receipt in GP show where cash was never recorded.
Check Fabrikam's Chargebee payments since September against GP receipts.
Finance controllers
Keep balances right
Applied, missing and unapplied payments in one list tell you if the customer balance is reliable.
Reconcile northwind-001's Chargebee payments to Dynamics GP applications for the last 90 days.
How it works
What PopdockAI does when you ask
You give a customer id and your AI assistant matches their Chargebee payments to Dynamics GP receipts and applications. Amounts are not compared across currencies.
01
Ask
You give a customer id and optionally a start date.
02
Read
It reads the Chargebee payments and the GP applications and receipts.
03
Match
It matches by amount, date and reference number.
04
Report
You get applied, missing and unapplied payments, with failed ones counted.
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-transaction
microsoft-dynamics-gp-get-rm-trx-apply
microsoft-dynamics-gp-get-rm-trx
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 unapplied cash found quickly
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)
