/
/
See which Chargebee dunning customers Business Central still serves
For finance teams who want billing dunning and ERP credit holds to line up, just by asking their AI assistant.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Customers in dunning that the ERP still serves
Credit controllers cross check Chargebee dunning lists against Business Central credit holds by hand. Customers in dunning keep getting served because the ERP never heard about it, and each one has to be looked up twice.
Without PopdockAI
- List invoices in dunning in Chargebee
- Look each customer up in Business Central
- Check balance, credit limit, block and reminders
- Keep serving customers who should be on hold
With PopdockAI
- Invoices in dunning are grouped by customer with amount due
- Each customer's Business Central position is read
- A risk note flags blocked, over limit or no reminder
- A block is recommended but never applied
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List Chargebee invoices in dunning that are due before `{due-before}` and, for each customer, show whether Business Central already treats them as a credit risk.
**Step 1: Chargebee dunning invoices**
Call `chargebee-get-invoice` (Chargebee server) with `status` set to payment_due, `due-date.to` set to `{due-before}` and `max-records` 50. Keep rows whose `dunning-status` is not empty. Group by `customer-id` and add up `amount-due`. If nothing is in dunning, report that and stop.
**Step 2: Customer details**
For each customer, call `chargebee-get-customer` (Chargebee server) with `id` and keep `email`, `company` and `auto-collection`.
**Step 3: Business Central position**
Call `business-central-get-customer` (Business Central server) with `email`. Keep `customer-number`, `balance-due`, `credit-limit`, `blocked`. Call `business-central-get-reminder` (Business Central server) with `customer-number` and keep the highest `reminder-level`. If the customer is not found, flag "not in Business Central".
**Step 4: Report**
Rank customers by Chargebee amount due. For each show: Chargebee amount due, oldest due date, dunning status, Business Central balance due, credit limit, blocked flag, highest reminder level, and a risk note: "Already blocked", "Over credit limit", "No reminder raised in Business Central" or "Not in Business Central".
**Rules & Guidelines:**
* `chargebee-get-invoice` and `chargebee-get-customer` are on the Chargebee server; `business-central-get-customer` and `business-central-get-reminder` are on the Business Central server.
* Read-only. Do not call `business-central-update-customer` to block anyone; recommend it instead.
**Validation:**
* If `{due-before}` is empty, use today's date.
* Do not compare balances across different currencies.Who it's for
One answer, three teams that use it
Credit controllers
Apply holds where they matter
Customers in dunning who are not blocked in Business Central are flagged first.
Which Chargebee customers in dunning are not blocked in Business Central?
Collections managers
Rank dunning by amount
Customers are ranked by Chargebee amount due with a risk note, so the team works the biggest first.
Rank Chargebee dunning customers by amount due and show their Business Central credit limit.
Sales operations
Check before shipping more
Before new orders go out, see whether a customer is in dunning and over their limit.
Is Contoso in Chargebee dunning, and are they over their Business Central credit limit?
How it works
What PopdockAI does when you ask
You give a due before date and your AI assistant ranks Chargebee dunning customers with their Business Central position. It recommends but never changes anything.
01
Ask
You give a due before date, or use today.
02
Read
It lists the Chargebee invoices in dunning and the customers behind them.
03
Look up
It finds each customer in Business Central and reads their position.
04
Report
You get a ranked table with a risk note and a recommendation.
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
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
See which dunning customers the ERP still treats as safe
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)
