Connectors

/

Stripe

/

Stripe and Dynamics 365 Business Central customer billing overview
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Stripe and Dynamics 365 Business Central customer billing overview
Give me a billing overview for Contoso across Business Central and Stripe before my call.
Contoso owes 8,400.00 in Business Central, and 2 things need attention. - Overdue: INV-1042, 3,200.00, 18 days late - Stripe: 1 active subscription, next invoice 1,200.00 on 1 November - Failed charge: 1,200.00 declined on 2 October - Card: ending 4242, expires in 45 days Want the open invoice list as well?
Stripe
Sample figures. Your results come from your own account.
stripe-get-customer
stripe-get-subscription
stripe-get-invoice
stripe-get-charge
stripe-get-payment-method
stripe-get-upcoming-invoice

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Stripe

Stripe
Run it on your own Stripe data.

Connect Stripe, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Find

It finds the customer in Business Central, asking if several match.

No items found.

03

Read

It lists open invoices, then Stripe subscriptions, failed charges and cards.

stripe-get-customer
stripe-get-subscription
stripe-get-invoice
stripe-get-charge
stripe-get-payment-method
stripe-get-upcoming-invoice

04

Report

You get the overview and a short attention list, with nothing changed.

Your AI tool

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.

get-data

stripe-get-customer

Returns customer records (name, email, balance, delinquency, address) from Stripe.
get-data

stripe-get-subscription

Returns subscriptions (customer, status, billing period, cancellation, trial) from Stripe.
get-data

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
get-data

stripe-get-charge

Returns charges (amount, status, refunds, customer, card used) from Stripe.
get-data

stripe-get-payment-method

Returns the payment methods saved on a Stripe customer (type, card brand, last 4, expiry). Requires a customer ID.
get-data

stripe-get-upcoming-invoice

Previews the next invoice Stripe will generate for a customer (period, subtotal, tax, total, amount due). Requires a customer ID.
Read only.Nothing in Stripe Changes

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.

How Popdock AI secures your data

The outcome

The full billing picture before every money call

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation