Connectors

/

Microsoft Dynamics 365 Business Central

/

Create a Dynamics 365 Business Central customer for a Bloomerang sponsor
Write
Cross-Connector

Set up a Bloomerang sponsor as a Business Central customer once

For finance teams who need to invoice a sponsor without rekeying details or creating a duplicate customer, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Create a Dynamics 365 Business Central customer for a Bloomerang sponsor
Create a Business Central customer for our sponsor Northwind Traders from their Bloomerang record.
Northwind Traders has no matching customer in Business Central. - Name: Northwind Traders - Email: giving@northwindtraders.com, phone 555 0142 - Address: 12 Harbor Road, Portland, OR - Link: a note with the new customer number goes on the Bloomerang record Shall I create the customer?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
bloomerang-get-constituent
bloomerang-get-address
bloomerang-get-phone
bloomerang-add-note

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

Invoicing a sponsor starts with retyping their donor record

When a sponsor needs an invoice, someone has to set them up as a Business Central customer using details already in Bloomerang. Rekeying invites typos, and it is easy to create a second customer for an organization that already exists.

Without PopdockAI

  • Copy the name, email, phone and address from Bloomerang
  • Search Business Central and hope the spelling matches
  • Create a second customer for the same sponsor
  • Leave no link between the two records

With PopdockAI

  • The organization is read with its primary address and phone
  • Business Central is searched by email and by name
  • No customer is created when a likely match exists
  • After you confirm, a note with the customer number goes on the Bloomerang record

The prompt

Use this prompt

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

Prompt
**Objective:** Make sure the Bloomerang organization `{organization}` has a Business Central customer in company `{company}` (blank means the connector's default company), creating one from its Bloomerang details if it is missing, and record the link on the Bloomerang record.

**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 and stop. If none match, say so and stop.

Then call `bloomerang-get-address` with `account-id` = the constituent `id` and `primary` = true, and `bloomerang-get-phone` with the same filters.

**Step 2: Check for an existing customer (Business Central)**

Call `business-central-get-customer` with `email` = the constituent's `primary-email`, and again with `name.contains` = `{organization}`. Pass `{company}` as `company` on every Business Central call; omit it when blank. If either returns a customer, report its number and name, skip Steps 3 and 4, and go straight to Step 5 only if the user asks for the link to be recorded.

**Step 3: Show the plan and wait**

Show the customer that would be created: display name (the constituent's `full-name`), type Company, email, phone, address line 1, city, state, postal code and country. Ask the user to confirm and to give a customer number if they do not want Business Central to assign one. Do not write anything until they confirm in their next message.

**Step 4: Create the customer (Business Central)**

After confirmation, call `business-central-create-customer` once with those values, plus `number` only if the user gave one. Keep the returned `number`.

**Step 5: Record the link (Bloomerang)**

Call `bloomerang-add-note` with `account-id` = the constituent `id`, today's date as `date`, and `note` = `Business Central customer <number> (company {company})`.

**Step 6: Confirm**

Call `business-central-get-customer` with `customer-number` = the new number and report it next to the Bloomerang constituent.

**Rules & Guidelines:**

* `bloomerang-get-constituent`, `bloomerang-get-address`, `bloomerang-get-phone` and `bloomerang-add-note` are on the bloomerang server. `business-central-get-customer` and `business-central-create-customer` are on the business-central server.
* The only write tools this prompt may call are `business-central-create-customer` (once, after confirmation) and `bloomerang-add-note` (once).
* Do NOT call `business-central-update-customer`, `business-central-create-contact`, `bloomerang-update-constituent` or any other write tool.

**Validation:**

* Never create a customer when Step 2 found a likely match. Ask the user instead.
* If the constituent has no address or email, create the customer with what exists and list the missing fields.
* If `business-central-create-customer` fails, report the error and do not add the Bloomerang note.

Who it's for

One answer, three teams that use it

Nonprofit finance

Invoice sponsors without rekeying

Create the customer from the details already in Bloomerang, so the first sponsorship invoice is not delayed by setup.

Set up our sponsor Fabrikam Foundation as a Business Central customer from Bloomerang.

Development officers

See the finance link on the donor record

A note with the customer number is added in Bloomerang, so you can tell the sponsor is set up for invoicing.

Create a Business Central customer for Contoso Bank from their Bloomerang record and note the number there.

Accounting managers

Keep duplicate sponsors out of the ledger

Likely matches by email or name stop the create, so one organization does not end up as two customers.

Check whether Northwind Traders already exists in Business Central before creating it from Bloomerang.

How it works

What PopdockAI does when you ask

You name the Bloomerang organization and your AI assistant checks Business Central for an existing customer. Nothing is written until you confirm, and the note is added only if the customer is created.

01

Ask

You name the Bloomerang organization, and optionally a company.

Your AI tool

02

Check

It reads its address and phone and searches Business Central by email and name.

bloomerang-get-constituent
bloomerang-get-address
bloomerang-get-phone

03

Confirm

You see the customer it would create and say yes.

No items found.

04

Create

It creates the customer, notes the number in Bloomerang and reads it back.

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

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-address

Returns constituent postal addresses from Bloomerang. Filter by city, state, postal code or address type, or return only primary addresses.
get-data

bloomerang-get-phone

Returns constituent phone numbers from Bloomerang. Filter by number, phone type, primary flag or the constituent account.
run-action

bloomerang-add-note

Adds a note against a Bloomerang constituent, with its date.
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

Sponsors set up once, linked back to their donor record

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