Connectors

/

Chargebee

/

Review Chargebee dunning risk in Dynamics 365 Business Central
Report
Cross-Connector

See which Chargebee dunning customers Business Central still serves

For finance teams who want billing dunning and ERP credit holds to line up, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review Chargebee dunning risk in Dynamics 365 Business Central
Which Chargebee customers are in dunning, and does Business Central know about the risk?
8 customers have Chargebee invoices in dunning, owing USD 31,200 in total. - Northwind Traders: USD 12,400 due, over credit limit in Business Central - Contoso Ltd: USD 9,800 due, no reminder raised in Business Central - Litware: USD 2,100 due, not in Business Central Want the full ranked table?
Chargebee
Sample figures. Your results come from your own account.
chargebee-get-invoice
chargebee-get-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Chargebee

Chargebee
Run it on your own Chargebee data.

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

Try PopdockAI free

The problem

Customers in dunning that the ERP still serves

Credit controllers cross check Chargebee dunning lists against Business Central credit holds by hand. Customers in dunning keep getting served because the ERP never heard about it, and each one has to be looked up twice.

Without PopdockAI

  • List invoices in dunning in Chargebee
  • Look each customer up in Business Central
  • Check balance, credit limit, block and reminders
  • Keep serving customers who should be on hold

With PopdockAI

  • Invoices in dunning are grouped by customer with amount due
  • Each customer's Business Central position is read
  • A risk note flags blocked, over limit or no reminder
  • A block is recommended but never applied

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** List Chargebee invoices in dunning that are due before `{due-before}` and, for each customer, show whether Business Central already treats them as a credit risk.

**Step 1: Chargebee dunning invoices**

Call `chargebee-get-invoice` (Chargebee server) with `status` set to payment_due, `due-date.to` set to `{due-before}` and `max-records` 50. Keep rows whose `dunning-status` is not empty. Group by `customer-id` and add up `amount-due`. If nothing is in dunning, report that and stop.

**Step 2: Customer details**

For each customer, call `chargebee-get-customer` (Chargebee server) with `id` and keep `email`, `company` and `auto-collection`.

**Step 3: Business Central position**

Call `business-central-get-customer` (Business Central server) with `email`. Keep `customer-number`, `balance-due`, `credit-limit`, `blocked`. Call `business-central-get-reminder` (Business Central server) with `customer-number` and keep the highest `reminder-level`. If the customer is not found, flag "not in Business Central".

**Step 4: Report**

Rank customers by Chargebee amount due. For each show: Chargebee amount due, oldest due date, dunning status, Business Central balance due, credit limit, blocked flag, highest reminder level, and a risk note: "Already blocked", "Over credit limit", "No reminder raised in Business Central" or "Not in Business Central".

**Rules & Guidelines:**

* `chargebee-get-invoice` and `chargebee-get-customer` are on the Chargebee server; `business-central-get-customer` and `business-central-get-reminder` are on the Business Central server.
* Read-only. Do not call `business-central-update-customer` to block anyone; recommend it instead.

**Validation:**

* If `{due-before}` is empty, use today's date.
* Do not compare balances across different currencies.

Who it's for

One answer, three teams that use it

Credit controllers

Apply holds where they matter

Customers in dunning who are not blocked in Business Central are flagged first.

Which Chargebee customers in dunning are not blocked in Business Central?

Collections managers

Rank dunning by amount

Customers are ranked by Chargebee amount due with a risk note, so the team works the biggest first.

Rank Chargebee dunning customers by amount due and show their Business Central credit limit.

Sales operations

Check before shipping more

Before new orders go out, see whether a customer is in dunning and over their limit.

Is Contoso in Chargebee dunning, and are they over their Business Central credit limit?

How it works

What PopdockAI does when you ask

You give a due before date and your AI assistant ranks Chargebee dunning customers with their Business Central position. It recommends but never changes anything.

01

Ask

You give a due before date, or use today.

Your AI tool

02

Read

It lists the Chargebee invoices in dunning and the customers behind them.

chargebee-get-invoice
chargebee-get-customer

03

Look up

It finds each customer in Business Central and reads their position.

No items found.

04

Report

You get a ranked table with a risk note and a recommendation.

Your AI tool

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.

get-data

chargebee-get-invoice

Returns Chargebee invoices with status, amounts, amount due and due date, filterable by customer and status. Read-only.
get-data

chargebee-get-customer

Returns Chargebee customer records with contact, billing and balance details, filterable by id, email and other fields. Read-only.
Read only.Nothing in Chargebee 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

See which dunning customers the ERP still treats as safe

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