Connectors

/

2Checkout

/

Review 2Checkout subscriptions against Dynamics 365 Business Central balances
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Review 2Checkout subscriptions against Dynamics 365 Business Central balances
Show me what dana@northwindtraders.com subscribes to in 2Checkout and what they owe in Business Central over the last 60 days.
Northwind Traders has 2 active subscriptions and a balance due in Business Central, which is a risk. - 2Checkout: Cloud Backup and Pro Support, both active - Business Central: balance due 1,850.00, credit limit 5,000.00, not blocked - Ledger, last 60 days: 4 entries - Currencies match, so no conversion needed Want the expiry dates for each subscription?
2Checkout
Sample figures. Your results come from your own account.
2checkout-get-subscription
2checkout-get-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

2Checkout

2Checkout
Run it on your own 2Checkout data.

Connect 2Checkout, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Subscriptions

It reads the customer's 2Checkout subscriptions and credit.

2checkout-get-subscription
2checkout-get-customer

03

Account

It reads the Business Central balance, credit limit, blocked status and ledger.

No items found.

04

Report

You get both positions and a risk note on active subscriptions against money owed.

Your AI tool

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.

get-data

2checkout-get-subscription

Returns subscriptions records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
get-data

2checkout-get-customer

Returns customers records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
Read only.Nothing in 2Checkout 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

One view of what a customer uses and owes

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