/
/
Rank overdue Chargebee balances with their Dynamics GP position
For finance teams who want collections prioritised across both systems, just by asking their AI assistant.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Every overdue customer looked up twice
Collectors cross check overdue Chargebee invoices against Dynamics GP balances and holds, looking up every customer twice. Customers on hold in GP can still have active subscriptions, and nobody sees it.
Without PopdockAI
- Group overdue Chargebee invoices by customer
- Look up each customer in Dynamics GP
- Check balance, credit limit and hold flags
- Miss a hold that clashes with a live subscription
With PopdockAI
- Overdue invoices are grouped with oldest due date and dunning
- The top 15 customers are looked up in Dynamics GP
- Over limit, on hold with active subscription and missing are flagged
- Ranked by overdue amount, with nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List customers whose Chargebee invoices are overdue by more than `{min-amount}` (default 1) and show their Dynamics GP balance, credit limit and hold status, to prioritise collections. Use `{gp-company}` as the GP company when given.
**Step 1: Overdue invoices in Chargebee**
Call `chargebee-get-invoice` (chargebee server) with `amount-due.min` set to the minimum, and `due-date.to` set to today. Group by `customer-id`; sum amount-due per customer, and note the oldest due-date and dunning-status.
**Step 2: Dynamics GP position**
For each of the top 15 customers by amount due, call `dynamics-gp-get-rm-customer` (dynamics-gp server) with `customer-id`, falling back to `customer-name.contains` using the Chargebee company from `chargebee-get-customer`. Keep customer-balance, credit-limit-amount, hold and inactive.
**Step 3: Report**
A table ranked by Chargebee overdue amount: customer, overdue amount, oldest due date, dunning status, GP balance, credit limit, GP hold flag. Flag customers over their credit limit, customers on hold in GP who still have active Chargebee subscriptions, and customers with no GP record.
**Rules & Guidelines:**
* `chargebee-get-invoice` and `chargebee-get-customer` are on the chargebee server; `dynamics-gp-get-rm-customer` is on the dynamics-gp server.
* Read only. Do not call `dynamics-gp-rm-customer-update`, `dynamics-gp-rm-customer-note` or any other write tool.
**Validation:**
* If no overdue invoices exist, say so and stop.
* Show amounts with their currency; do not total across currencies.Who it's for
One answer, three teams that use it
Collections specialists
Start with the biggest balances
Customers are ranked by Chargebee overdue amount with their GP position alongside.
Rank overdue Chargebee customers owing more than 500 and show their Dynamics GP balance.
Credit controllers
Find holds that are not working
Customers on hold in GP with active subscriptions are flagged, so you can decide what to stop.
Which customers on hold in Dynamics GP still have active Chargebee subscriptions?
AR managers
Catch customers missing from GP
Overdue customers with no GP record are flagged for setup.
Do any overdue Chargebee customers have no record in the Contoso GP company?
How it works
What PopdockAI does when you ask
You give a minimum overdue amount and your AI assistant ranks overdue Chargebee customers with their Dynamics GP position. It does not total across currencies.
01
Ask
You give a minimum overdue amount, or use 1.
02
Read
It groups the overdue Chargebee invoices by customer.
03
Look up
It finds the top customers in Dynamics GP and reads balance, limit and holds.
04
Report
You get a ranked table with the risky customers flagged.
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-customer
chargebee-get-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
A ranked list that shows where holds and subscriptions clash
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)
