/
/
Compare what a customer owes in Chargebee and Business Central
For finance teams who want one answer on a customer balance, just by asking their AI assistant.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Two balances for one customer and no one can explain the gap
To answer what a customer owes, collections staff open Chargebee and Business Central and add up open invoices by hand. The two totals never quite agree, and nobody can say which invoices explain the difference.
Without PopdockAI
- Add up open Chargebee invoices by hand
- Look up the balance and open invoices in Business Central
- Compare the two totals line by line
- Leave the gap unexplained
With PopdockAI
- Open Chargebee invoices are totalled with dunning status
- Business Central balance, credit limit and reminders are read
- Invoices on only one side are listed
- Currencies are kept apart 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:** Produce a single receivables view for `{customer-email}` combining Chargebee dues and Business Central balances, and say whether the two agree.
**Step 1: Chargebee side**
Call `chargebee-get-customer` (Chargebee server) with `email` set to `{customer-email}`; stop if there is not exactly one result. Then call `chargebee-get-invoice` (Chargebee server) with `customer-id` set to that customer's `id` and `amount-due.min` set to 0.01. Add up `amount-due` and note the oldest `due-date` and any `dunning-status`.
**Step 2: Business Central side**
Call `business-central-get-customer` (Business Central server) with `email` set to `{customer-email}` and keep `customer-number`, `balance`, `balance-due`, `credit-limit` and `blocked`. If none is found, report "not in Business Central" and give the Chargebee figures only.
Call `business-central-get-posted-sales-invoice` (Business Central server) with `sell-to-customer-number` and `remaining-amount.min` set to 0.01 to list open invoices. Call `business-central-get-reminder` (Business Central server) with `customer-number` to list reminders and their `reminder-level`.
**Step 3: Report**
Show a two-column summary (Chargebee, Business Central): total outstanding, overdue amount, oldest due date, open invoice count, dunning or reminder level, credit limit and blocked flag. State the difference between the two outstanding totals and, if it is non-zero, list the invoices that appear on one side only.
**Rules & Guidelines:**
* `chargebee-get-customer` and `chargebee-get-invoice` are on the Chargebee server; the other Business Central tools named here are on the Business Central server.
* Read-only. Do not call any Business Central create or update tool.
**Validation:**
* If the two systems use different currencies, show both and do not subtract them.
* Treat a difference under 1.00 in the same currency as rounding.Who it's for
One answer, three teams that use it
Collections specialists
Know what a customer really owes
See both balances and the invoices behind any difference before you pick up the phone.
What does ap@contoso.com owe in Chargebee and in Business Central, and why are they different?
Credit controllers
Check limits and blocks with the balance
Credit limit, blocked flag and reminder level come back with the totals, so credit decisions use current data.
Is Fabrikam over its Business Central credit limit once their open Chargebee invoices are included?
AR accountants
Find invoices on one side only
Invoices that exist in only one system are listed, so you know what to post or investigate.
Which open invoices for billing@northwindtraders.com are in Chargebee but not Business Central?
How it works
What PopdockAI does when you ask
You give a customer email and your AI assistant sets the two balances side by side. It stops unless exactly one Chargebee customer matches and writes nothing to either system.
01
Ask
You give the customer email.
02
Chargebee
It finds the customer and adds up their open invoices.
03
Business Central
It reads the balance, open invoices, credit limit and reminders.
04
Report
You get both sides together and the invoices that appear on one side only.
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-customer
chargebee-get-invoice
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
One receivables view with the gap explained
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)
