/
/
See a customer's billing in Stripe and Business Central at once
For finance and account teams who want a customer's Dynamics 365 Business Central receivables and Stripe billing in one answer from their AI assistant.
On this page
Connector
Connect Stripe, pick your AI tool and paste the prompt.
The problem
A customer's billing story split across two logins
A customer's billing story is split between Dynamics 365 Business Central, where invoices and balance sit, and Stripe, where subscriptions, failed charges and saved cards live. Before a call about money, pulling both together takes several logins and searches.
Without PopdockAI
- Find the customer and open invoices in Business Central
- Find them again in Stripe
- Check subscriptions, failed charges and cards
- Piece together what needs fixing
With PopdockAI
- The customer is found in Business Central, asking if several match
- Open invoices are listed with overdue ones marked
- Stripe subscriptions, failed charges, expiring cards and next invoice are added
- A short attention list names what needs action, read-only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a billing overview of the customer `{customer}` (a Business Central customer number, an email address or a name) from Business Central company `{company}` (default: the default company) and from Stripe.
**Step 1: Find the customer in Business Central**
Call `business-central-get-customer` with `company` set to `{company}`. If `{customer}` contains `@`, filter by `email`. Otherwise try `customer-number` first, then `name.contains`. If more than one customer matches, list them and stop, asking the user which one they mean.
**Step 2: Open receivables in Business Central**
Call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to the customer's number and `remaining-amount.min` set to 0.01. Note which are past their `due-date`.
**Step 3: Find the same customer in Stripe**
Call `stripe-get-customer` with `email` set to the Business Central customer's email. If the email is empty or finds nothing, try `name` with the Business Central name. If Stripe still finds nothing, report the Stripe sections as "not found in Stripe" and go straight to Step 5.
**Step 4: Stripe billing detail**
With the Stripe `customer-id`:
* `stripe-get-subscription` for its subscriptions (status, current-period-end, cancel-at-period-end).
* `stripe-get-invoice` with `status` set to open, for unpaid Stripe invoices.
* `stripe-get-charge` with `status` set to failed, for failed payments.
* `stripe-get-payment-method` for saved cards; flag any card whose expiry is within 60 days of today or already past.
* `stripe-get-upcoming-invoice` for the next amount Stripe will bill.
**Step 5: Report**
A short header (Business Central customer number and name, Stripe customer-id, email), then:
1. Business Central: balance-due, credit-limit, blocked, and a table of open invoices (invoice-number, due-date, remaining-amount, overdue yes/no).
2. Stripe: delinquent flag, subscriptions, open invoices, failed charges in the list returned, cards and their expiry, next invoice amount and date.
3. Attention: a bullet list of anything that needs action, such as an overdue Business Central invoice, a delinquent Stripe customer, an expired card or a subscription set to cancel.
**Rules & Guidelines:**
* Tools whose names start with business-central are on the business-central server; tools whose names start with stripe are on the stripe server.
* This prompt is read-only. Do NOT call any Business Central create or update tool, including `business-central-update-customer`.
* Stripe amounts are in major currency units, the same as Business Central. Show each amount with its currency.
**Validation:**
* If the customer is not in Business Central at all, try Stripe directly with `{customer}` as an email or name, report what Stripe holds, and say it has no Business Central record.
* If the Business Central and Stripe names differ for the same email, show both names in the header.Who it's for
One answer, three teams that use it
Accounts receivable
Prepare for a payment call
Overdue invoices and failed charges are in one view before you call.
Give me a billing overview for Fabrikam across Business Central and Stripe.
Customer success managers
Spot cards about to expire
Cards expiring within 60 days are flagged, so you can ask for new details before a charge fails.
Does Northwind Traders have a Stripe card expiring soon or overdue invoices in Business Central?
Billing specialists
Know what to fix first
The attention list puts the most pressing issues at the top.
What needs attention on customer C10045 across Business Central and Stripe?
How it works
What PopdockAI does when you ask
You give a customer number, email or name, and your AI assistant builds a billing overview across Business Central and Stripe. It only reads and shows both names when they differ.
01
Ask
You give a customer number, email or name.
02
Find
It finds the customer in Business Central, asking if several match.
03
Read
It lists open invoices, then Stripe subscriptions, failed charges and cards.
04
Report
You get the overview and a short attention list, with nothing changed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Stripe and one secure connection to your AI tool. No code, no exports.
stripe-get-customer
stripe-get-subscription
stripe-get-invoice
stripe-get-charge
stripe-get-payment-method
stripe-get-upcoming-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
The full billing picture before every money call
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)
