Connectors

/

Bloomerang

/

Review a Bloomerang sponsor's Dynamics 365 Business Central account
Report
Cross-Connector

See a sponsor's giving and Business Central balance in one view

For finance and fundraising teams who want a sponsor's Bloomerang giving beside what they owe in Dynamics 365 Business Central.

Try PopdockAI free
Get a live demo
Review a Bloomerang sponsor's Dynamics 365 Business Central account
Show Contoso Foundation's Bloomerang giving and Business Central account for the last year.
Contoso Foundation matched customer C-1042 by email. - Giving: 6 gifts totaling 30,000, latest on August 14 - Balance: 8,400, credit limit 10,000, not blocked - Open invoices: 3, with 5,200 overdue - Stands out: a generous sponsor with overdue invoices Want the open invoice list?
Bloomerang
Sample figures. Your results come from your own account.
bloomerang-get-constituent
bloomerang-get-transaction

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Bloomerang

Bloomerang
Run it on your own Bloomerang data.

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

Try PopdockAI free

The problem

A generous sponsor with overdue invoices

An organization can be a generous Bloomerang sponsor and carry overdue invoices in Business Central at the same time. Seeing both means looking it up in each system, and matching by name alone can merge two different companies.

Without PopdockAI

  • Look up the organization's gifts in Bloomerang
  • Search Business Central for the customer
  • Guess between similar company names
  • Read balance and overdue invoices separately

With PopdockAI

  • The Bloomerang organization is found
  • The Business Central customer is matched by email, then name, asking if several match
  • Giving sits beside balance, credit limit and overdue invoices
  • The match basis is stated, and nothing is changed

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 one view of the organization `{organization}` that shows its Bloomerang giving and its Business Central customer account in company `{company}` (blank means the connector's default company), looking back `{lookback-days}` days (default 365).

**Step 1: Find the organization (Bloomerang)**

Call `bloomerang-get-constituent` with `full-name.contains` = `{organization}` and `type` = Organization. If more than one matches, list them (full name, account number, city, primary email) and stop. If none match, say so and stop. Keep `id`, `full-name`, `primary-email` and `primary-address-city`.

**Step 2: Find the customer (Business Central)**

Call `business-central-get-customer` with `email` set to the constituent's `primary-email`. If that returns nothing, call it again with `name.contains` = `{organization}`. Pass `{company}` as `company` on every Business Central call; omit it when blank. If several customers match by name, list them and ask which one is meant.

**Step 3: Pull both histories**

* Bloomerang: call `bloomerang-get-transaction` with `account-id` = the constituent `id` and `date.from` = today minus the lookback. Total the amounts.
* Business Central: call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` = the customer number and `posting-date.from` = the same date, and keep the invoices with `remaining-amount` above zero.

**Step 4: Report**

* Header: organization name, Bloomerang account number, Business Central customer number and name, and how they were matched (email or name).
* Bloomerang: gift count, total, largest gift, last gift date.
* Business Central: balance, balance due, credit limit, blocked, open invoices (number, date, due date, remaining amount), overdue total.
* One line on what stands out, such as a sponsor that gives but has overdue invoices.

**Rules & Guidelines:**

* `bloomerang-get-constituent` and `bloomerang-get-transaction` are on the bloomerang server. `business-central-get-customer` and `business-central-get-posted-sales-invoice` are on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-customer`, `business-central-update-customer`, `bloomerang-add-note` or any other create, update or add tool.

**Validation:**

* If there is no Business Central customer, report the Bloomerang side alone and say the organization is not a customer. Suggest the link-sponsor-to-customer prompt.
* A name match is weaker than an email match. Say which was used, and never merge two different organizations that only share a word in their names.

Who it's for

One answer, three teams that use it

Corporate partnerships managers

Know the full relationship before you ask

See giving and any overdue balance before the next sponsorship conversation.

Show Fabrikam's Bloomerang giving and Business Central balance for the last 2 years.

Finance directors

Spot sponsors with overdue invoices

Overdue totals next to gifts help you handle the conversation carefully.

Does Contoso Foundation have overdue invoices in Business Central while giving in Bloomerang?

Executive directors

Prepare for a sponsor meeting

A line on what stands out gives you the talking point in one glance.

Review Northwind Traders as a sponsor across Bloomerang and Business Central company CRONUS.

How it works

What PopdockAI does when you ask

You name the organization and your AI assistant puts its Bloomerang giving beside its Business Central account. If no customer exists, it reports the giving alone.

01

Ask

You name the organization, a look-back period and optionally a company.

Your AI tool

02

Find

It finds the organization, then the customer by email, then by name.

bloomerang-get-constituent

03

Read

It reads gifts and open posted sales invoices.

bloomerang-get-transaction

04

Report

You get both sides and what stands out, and nothing is changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Bloomerang and one secure connection to your AI tool. No code, no exports.

get-data

bloomerang-get-constituent

Returns constituents from Bloomerang: the donors, prospects and contacts in your database. Filter by full name, last name, account number, primary email, city, type or status, or fetch one by id.
get-data

bloomerang-get-transaction

Returns gift transactions from Bloomerang. Filter by date range, amount range, payment method, transaction number, or whether the gift has been refunded.
Read only.Nothing in Bloomerang 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

A sponsor's giving and balance in one view

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