Connectors

/

DonorPerfect

/

Set up a DonorPerfect donor as a Dynamics 365 Business Central customer
Write
Cross-Connector

Make a donor an invoiceable customer without duplicates

For finance teams who need a DonorPerfect donor set up as a Business Central customer, linked both ways, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Set up a DonorPerfect donor as a Dynamics 365 Business Central customer
Set up DonorPerfect donor 20517 as a customer in Business Central so we can invoice them.
No Business Central customer matches donor 20517, Fabrikam Inc, by email or name. - Name: Fabrikam Inc - Address: 120 Main Street, Portland, OR 97201 - Country: US - Email: billing@fabrikam.com Shall I create this customer?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-donor
donorperfect-get-address
donorperfect-save-other-info

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

DonorPerfect

DonorPerfect
Run it on your own DonorPerfect data.

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

Try PopdockAI free

The problem

Retyping a donor into Business Central creates duplicates

When a donor needs invoicing, someone retypes their name and address into Business Central and checks they are not already a customer. Without a note back on the donor, the next person has no idea a customer record exists.

Without PopdockAI

  • Copy name and address from DonorPerfect
  • Search Business Central for an existing customer
  • Create the customer by hand
  • Forget to note the number on the donor

With PopdockAI

  • The donor and billing address are read
  • Business Central is searched by email and name first
  • You see the exact customer before it is created
  • The new number is noted back on the donor

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 DonorPerfect donor `{donor-id}` a customer in Business Central so it can be invoiced, without creating a duplicate, and record the new customer number back on the donor in DonorPerfect. If `{company}` is given, pass it as `company` on every Business Central call.

**Step 1: Read the donor in DonorPerfect**

Call `donorperfect-get-donor` with `donor-id` = `{donor-id}`. If nothing comes back, say so and stop.

Call `donorperfect-get-address` with `donor-id` = `{donor-id}` for the full street address, country and phone. If there are several addresses, use the one whose `address-type` marks it as the main or billing address, and otherwise ask the user which one.

The customer name is `organization-name`, or first name and last name for an individual.

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

* Call `business-central-get-customer` with `email` = the donor's `email`, if it has one.
* Call `business-central-get-customer` with `name.contains` = the customer name with legal suffixes (Inc, LLC, Ltd, Foundation) removed.

If either returns a customer, show it (`customer-number`, `name`, `city`, `email`, `balance`) and stop. Do not create a second one. Tell the user that if this is the same organisation, the number can be noted on the donor by running this prompt again after they confirm.

**Step 3: Confirm with the user**

Show the customer you are about to create: `display-name`, `email`, `phone-number`, `address-line-1`, `city`, `state`, `postal-code`, `country`, and `type` Company (or Person for an individual). Ask the user to confirm. Do not continue without an explicit yes.

**Step 4: Create the customer**

Call `business-central-create-customer` with the confirmed values. Leave `number` blank so Business Central assigns one. Take `id` and `number` from the result.

Then call `business-central-get-customer` with `customer-number` = the new number to confirm it reads back.

**Step 5: Note it on the donor**

Call `donorperfect-save-other-info` with `donor-id` = `{donor-id}`, `date` = today, and `comments` = "Business Central customer <number> created <today> in company <company or default>".

**Step 6: Report**

The DonorPerfect `donor-id` and name, the new Business Central customer `number` and `id`, the fields it was created with, and the `other-id` of the DonorPerfect note.

**Rules & Guidelines:**

* `donorperfect-get-donor`, `donorperfect-get-address` and `donorperfect-save-other-info` are on the donorperfect server. `business-central-get-customer` and `business-central-create-customer` are on the business-central server.
* The only tools that may write are `business-central-create-customer` (once, after the user confirms in Step 3) and `donorperfect-save-other-info` (once, after the customer is created).
* Do not call `donorperfect-save-donor`, `business-central-update-customer` or `business-central-create-contact`.

**Validation:**

* If `{donor-id}` is missing, ask for it.
* If `business-central-create-customer` fails, report the error and do not write the DonorPerfect note.
* If `donorperfect-save-other-info` fails after the customer was created, report the customer number clearly so the user can add the note by hand.
* Business Central expects a two-letter `country` code. Convert a full country name from DonorPerfect, and ask if it is unclear.

Who it's for

One answer, three teams that use it

Accounts receivable

Invoice a donor without retyping

The customer is set up from the donor record in one request.

Set up DonorPerfect donor 31455 as a Business Central customer.

Finance operations

Avoid duplicate customers

An existing customer stops the process and is shown to you.

Is DonorPerfect donor 22780 already a customer in Business Central? If not, create one.

Development operations

Keep the link visible

The customer number is noted on the donor for the next person.

Create a Business Central customer for the Contoso Foundation donor and note the number in DonorPerfect.

How it works

What PopdockAI does when you ask

You give a donor id and your AI assistant checks Business Central for an existing customer. A new one is created only after you confirm, and its number is recorded on the donor.

01

Ask

You give a DonorPerfect donor id.

Your AI tool

02

Check

It reads the donor and address, then searches Business Central by email and name.

donorperfect-get-donor
donorperfect-get-address

03

Confirm

You see the exact customer to be created and say yes.

No items found.

04

Create

It creates the customer, reads it back and notes the number on the donor.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

donorperfect-get-donor

Returns donor records from DonorPerfect: names, salutations, contact details, donor type and status, and the codes used to segment them. The starting point for almost any DonorPerfect question.
get-data

donorperfect-get-address

Returns the additional address records held against donors in DonorPerfect, including address type, seasonal date ranges and which address is currently in use.
run-action

donorperfect-save-other-info

Records a dated other-info note against a donor in DonorPerfect, or updates an existing one when an other-info id is supplied.
Read only.Nothing in DonorPerfect 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

Donors invoiceable once, linked in both systems

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