Connectors

/

Bloomerang

/

Find Bloomerang gifts missing from Dynamics 365 Business Central
Report
Cross-Connector

Find Bloomerang gifts that never reached Business Central

For nonprofit finance teams who need to know which gifts still need posting before they close the period, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Bloomerang gifts missing from Dynamics 365 Business Central
Which Bloomerang gifts from September are missing from Business Central?
Of 184 September gifts, 171 are posted, 8 are in a journal and 5 are missing. - In journal: 8 gifts in batch BLM0930, still unposted - Missing: BLM10452, Jordan Lee, 500, check - Refunded: 1 of the missing gifts was refunded and may not need posting Want the full list of missing gifts?
Bloomerang
Sample figures. Your results come from your own account.
bloomerang-get-transaction
bloomerang-get-constituent

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

Gifts stuck in unposted journals, or never arriving

Gifts recorded in Bloomerang need to reach Business Central, but some sit in an unposted journal and others never arrive. Finding which means checking each gift against the ledger and the journals, which nobody has time for at month end.

Without PopdockAI

  • Export gifts for the period from Bloomerang
  • Search ledger entries for each one
  • Check unposted journals for the rest
  • Run out of time before close

With PopdockAI

  • Gifts in the range are read
  • Each is looked up by its BLM number in ledger entries, then journal lines
  • Gifts are counted posted, in journal with batch, or missing
  • Missing gifts are listed with donor and amount, 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:** List the Bloomerang gifts dated `{date-from}` to `{date-to}` that have not reached Business Central company `{company}` (blank means the connector's default company), neither as an unposted journal line nor as a posted ledger entry.

**Step 1: Read the gifts (Bloomerang)**

Call `bloomerang-get-transaction` with `date.from` = `{date-from}` and `date.to` = `{date-to}`. Keep `id`, `transaction-number`, `account-id`, `date`, `amount`, `method` and `refunded`. If more than 200 come back, report the count and ask for a shorter period.

**Step 2: Look for each gift in Business Central**

The gift's Business Central document number is `BLM` followed by its `transaction-number` (for example `BLM10452`). For each transaction:

1. Call `business-central-get-general-ledger-entry` with `document-number` set to that value. A hit means Posted.
2. If nothing comes back, call `business-central-get-general-journal-line` with `document-number` set to that value. A hit means In journal, with the batch name from `journal-batch-name`.
3. If neither returns anything, the gift is Missing.

Pass `{company}` as `company` on every Business Central call; omit it when blank.

**Step 3: Name the donors (Bloomerang)**

For the Missing gifts only, call `bloomerang-get-constituent` with `id` set to each distinct `account-id` and keep `full-name`.

**Step 4: Report**

Counts of Posted, In journal and Missing, then a table of the Missing gifts: transaction number, date, donor, amount, method, refunded. List In journal gifts separately with their batch name, since they still need posting in Business Central.

**Rules & Guidelines:**

* `bloomerang-get-transaction` and `bloomerang-get-constituent` are on the bloomerang server. `business-central-get-general-ledger-entry` and `business-central-get-general-journal-line` are on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-journal`, `business-central-create-journal-line` or any other create, update or add tool. To post the missing gifts, point the user at the post-gifts-to-journal prompt.

**Validation:**

* If Bloomerang returns no transactions, say so and stop.
* If no gift in the period is found in Business Central, say that gifts may have been posted as daily totals without the `BLM` document number, and suggest the reconcile-gifts-to-gl prompt instead of treating all of them as missing.
* Refunded gifts that are Missing are listed but flagged, since they may never need posting.

Who it's for

One answer, three teams that use it

Nonprofit accountants

Close with every gift posted

Missing gifts are listed with donor, amount and method, ready to post.

Which Bloomerang gifts from October are missing from Business Central?

Gift processors

Find gifts sitting in journals

Gifts in an unposted journal are shown with the batch name, so they can be posted.

Which Bloomerang gifts this month are in an unposted Business Central journal?

Finance directors

Check refunded gifts are handled

Refunded gifts are flagged among the missing ones, so they are treated correctly.

Check Bloomerang gifts from Q3 against Business Central company CRONUS and flag refunds.

How it works

What PopdockAI does when you ask

You give a date range and your AI assistant checks each Bloomerang gift in Business Central. If nothing is found at all, it suggests the gifts may have been posted as daily totals.

01

Ask

You give a date range, and optionally a company.

Your AI tool

02

Read

It reads the Bloomerang gifts in the period.

bloomerang-get-transaction
bloomerang-get-constituent

03

Look up

It finds each by its BLM number in ledger entries, then journal lines.

No items found.

04

Report

You get posted, in journal and missing counts, with nothing 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-transaction

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

Exactly which gifts still need posting before close

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