/
/
See 2Checkout subscriptions next to Business Central balances
For support and credit teams who give their AI assistant a customer email and ask what that customer subscribes to and owes.
On this page
Connector
Connect 2Checkout, pick your AI tool and paste the prompt.
The problem
Blocked in finance, still served in billing
Support and credit control open two systems to see whether a customer who owes money in Business Central still has live 2Checkout subscriptions. The views disagree, and a blocked customer can keep being served.
Without PopdockAI
- Look up subscriptions in 2Checkout
- Open the customer in Business Central
- Check balance, credit limit and blocked status
- Add amounts across currencies
With PopdockAI
- Subscriptions and credit read from 2Checkout
- Balance, credit limit and blocked status read from Business Central
- Active subscriptions with money owed flagged
- Currencies shown side by side, both systems 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:** For the customer with email `{email}`, show what they subscribe to in 2Checkout next to what they owe in Business Central, looking back `{lookback-days}` days of ledger activity (default 90).
**Step 1: Subscriptions in 2Checkout**
Call `2checkout-get-subscription` with `end-user-email` set to `{email}`. Note `subscription-reference`, `product-name`, `status`, `expiration-date` and `billing-currency`. Call `2checkout-get-customer` with `email` set to `{email}` to get `customer-reference` and `credit-remaining`. If no subscription and no customer is found, say so and stop.
**Step 2: Account in Business Central**
Call `business-central-get-customer` with `email` set to `{email}`. If several match, list them and stop. Take `customer-number`, `balance`, `balance-due`, `credit-limit` and `blocked`. Then call `business-central-get-detailed-customer-ledger` with `customer-number` and `posting-date.from` set to today minus the look-back days. If there is no Business Central customer, report that and continue to Step 3 with 2Checkout data only.
**Step 3: Report**
Give three parts: the subscription list (reference, product, status, expiry); the Business Central position (balance, balance due, credit limit, blocked, count and total of ledger entries in the window); and a short risk note. Raise a flag when active subscriptions exist while Business Central shows `blocked` or a `balance-due` above zero, or when a subscription is expired but the customer was invoiced in the window.
**Rules & Guidelines:**
* Tools named the 2checkout prefix are on the 2checkout server and tools named the business-central prefix are on the business-central server. Both servers must be connected.
* This is a read-only job. Never call any 2checkout or business-central create, update, add, order or subscription action tool.
* Business Central tools take an optional company parameter; only use it if the user named a company.
**Validation:**
* If the currencies differ between `billing-currency` and `currency-code`, show both and do not add the amounts together.
* If the email matches in one system only, say which one and do not search by name.
Who it's for
One answer, three teams that use it
Credit controllers
Spot blocked customers still subscribed
Active subscriptions on a blocked account are flagged as a risk.
Is accounts@fabrikam.com blocked in Business Central while still subscribed in 2Checkout?
Support agents
Know the balance before you help
See what a customer owes before agreeing to an upgrade or extension.
Does sam@contoso.com owe anything in Business Central, and what does he have in 2Checkout?
Accounts receivable
See recent ledger activity with subscriptions
Recent ledger entries sit next to the subscription list.
Show 2Checkout subscriptions and the last 90 days of Business Central ledger entries for lena@northwindtraders.com.
How it works
What PopdockAI does when you ask
You give an email and a look back period, and your AI assistant puts both positions side by side. It matches on email only and changes nothing.
01
Ask
You give a customer email and optionally a look-back in days.
02
Subscriptions
It reads the customer's 2Checkout subscriptions and credit.
03
Account
It reads the Business Central balance, credit limit, blocked status and ledger.
04
Report
You get both positions and a risk note on active subscriptions against money owed.
What PopdockAI provides
The tools behind the answer
Ready made tools for 2Checkout and one secure connection to your AI tool. No code, no exports.
2checkout-get-subscription
2checkout-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
One view of what a customer uses and owes
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)
