Connectors

/

Microsoft Dynamics 365 Business Central

/

Find overdue Dynamics 365 Business Central customers still in Drip campaigns
Report
Cross-Connector

Stop sending promotions to customers collections is chasing

For finance and marketing teams who want to see overdue Business Central customers still in Drip campaigns, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find overdue Dynamics 365 Business Central customers still in Drip campaigns
Which Business Central customers owing over 1,000 are still getting Drip campaigns?
52 customers owe over 1,000; 19 are still marketed to in Drip. - Top: Fabrikam, 38,400 due, in Spring Promo and VIP Offers - Unsubscribed: 8 in Drip - Not in Drip: 21 - No email: 4 in Business Central Nothing was paused or changed. Want the full table?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
drip-get-subscriber
drip-get-campaign-subscriber

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Collections is chasing customers marketing is still promoting to

Collections may be chasing a customer in Business Central while Drip keeps sending them cheerful promotions. Spotting the overlap means checking each overdue customer's status and email series in Drip, which nobody has time to do every week.

Without PopdockAI

  • List customers over the balance threshold
  • Search each email in Drip
  • Check subscriber status and active series
  • Find out when an annoyed customer complains

With PopdockAI

  • Customers over your balance threshold are read
  • Each email is checked for status, lead score and active series
  • A table by balance with counts per group
  • Read only, so collections and marketing decide what to change

The prompt

Use this prompt

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

Prompt
**Objective:** Find Business Central customers with a balance due of at least `{min-balance-due}` (default 1000) who are still active subscribers in Drip campaigns, so collections and marketing can agree what they receive. Use Business Central company `{bc-company}` if given.

**Step 1: Find customers with a balance due**

Call `business-central-get-customer` with `balance-due.min` set to `{min-balance-due}` (1000 if blank). Keep `customer-number`, `name`, `email`, `balance-due`, `blocked` and `salesperson-code`. Set aside customers with no email; you cannot match them.

**Step 2: Check each one in Drip**

For each customer with an email, call `drip-get-subscriber` with `email` set to that email, then `drip-get-campaign-subscriber` with the same `email`. A customer counts as still marketed to when the Drip `status` is active and at least one campaign subscription has an active `campaign-status`.

**Step 3: Report**

A table sorted by `balance-due` descending: customer number, name, email, balance due, blocked, salesperson, Drip status, lead score, active campaigns by name. Below it, give counts for: still marketed to, in Drip but unsubscribed, not in Drip, and no email in Business Central.

**Rules & Guidelines:**

* Tools whose names start with drip are on the drip server; tools whose names start with business-central are on the business-central server. Pass `{bc-company}` only to business-central tools.
* This prompt is read-only. Do NOT call `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns`, `drip-pause-campaign`, `drip-add-subscriber-tag` or `business-central-update-customer`. If the user wants to act, point them to the `sync-overdue-tag-to-drip` prompt.

**Validation:**

* If no customer meets the threshold, say so and stop.
* If Step 1 returns more than 100 customers, work through the 100 with the largest balance due and say how many were left out.
* Compare emails case-insensitively and ignoring surrounding spaces.

Who it's for

One answer, three teams that use it

Collections managers

Avoid mixed messages to customers who owe

See which customers you are chasing are still receiving promotions, before the next reminder goes out.

Which Business Central customers owing more than 2,500 are still in active Drip campaigns?

Lifecycle marketers

Know which subscribers are overdue

Lead score and active series beside the balance help you decide whether to pause someone.

Show me overdue Business Central customers who are active Drip subscribers, sorted by balance.

Finance managers

Coordinate collections and marketing

Counts per group give both teams the same picture for a weekly check in.

How many overdue Business Central customers in our Contoso company are still being emailed by Drip?

How it works

What PopdockAI does when you ask

You set a minimum balance and your AI assistant checks overdue Business Central customers in Drip. It changes nothing, so the two teams decide together what to pause.

01

Ask

You set a minimum balance due and optionally a company.

Your AI tool

02

Read

It reads Business Central customers over that balance.

No items found.

03

Check

Each email is checked in Drip for status, lead score and active campaigns.

drip-get-subscriber
drip-get-campaign-subscriber

04

Report

You get a table by balance and counts per group.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.

get-data

drip-get-subscriber

Returns Drip people (subscribers) with name, email, location, tags, status, GDPR consent, lead score and lifetime value. Filter by exact email, email domain, tag, status, country, minimum lead score, minimum lifetime value or date added.
get-data

drip-get-campaign-subscriber

Returns the people subscribed to each Drip email series campaign, with the campaign's status and the person's tags and lead score. Filter by campaign id or name, a person's email, subscriber status or minimum lead score.
Read only.Nothing in Microsoft Dynamics 365 Business Central 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 who is still being marketed to while overdue

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