Spot donors who are also your vendors

**Objective:** Find DonorPerfect donors that are also vendors in Business Central, and show for each what they gave and what they were paid between `{from-date}` and today (default: the first day of the current year). If `{company}` is given, pass it as `company` on every Business Central call.

**Step 1: List the vendors in Business Central**

Call `business-central-get-vendor` with `blocked` = false. Keep `vendor-number`, `name`, `email`, `city` and `state`. Raise `max-records` until the result stops growing.

**Step 2: Look for each vendor in DonorPerfect**

For each vendor:

1. If it has an `email`, call `donorperfect-get-donor` with `email` = that address.
2. Otherwise, call `donorperfect-get-donor` with `last-name.contains` = the vendor `name` with legal suffixes (Inc, LLC, Ltd, Co) removed. DonorPerfect keeps an organisation's name in `last-name`.

A name-only match counts as confirmed when city or state also agree; label anything else "name only". If a search returns several donors, list them all against that vendor.

**Step 3: Measure both sides for each match**

* DonorPerfect: `donorperfect-get-gift` with `donor-id` and `gift-date.from` = `{from-date}`. Total cash gifts (record type G) and note any `gift-type` that marks an in-kind gift.
* Business Central: `business-central-get-posted-purchase-invoice` with `buy-from-vendor-number` = the vendor number and `posting-date.from` = `{from-date}`. Total `amount-including-tax`.

**Step 4: Report**

A table: `vendor-number`, vendor name, `donor-id`, match basis, gifts received (count and total), purchases invoiced (count and total), any in-kind gifts. Sort by purchases, largest first.

Flag for review:

* a vendor whose gifts rose in the same period as its purchases;
* an in-kind gift from a vendor that also invoiced for similar goods or services;
* a vendor paid more than 10 times what it gave, when it also gave in the period.

These are prompts for a human to look at, not findings of wrongdoing. Say so in one line at the end.

**Rules & Guidelines:**

* `business-central-get-vendor` and `business-central-get-posted-purchase-invoice` are on the business-central server. `donorperfect-get-donor` and `donorperfect-get-gift` are on the donorperfect server.
* This prompt is read-only. Do not call `donorperfect-set-flag`, `donorperfect-save-donor`, `business-central-update-vendor` or any other save, set, create or update tool on either server.

**Validation:**

* If Business Central returns no vendors, say so and stop.
* If no vendor matches a donor, say how many vendors were checked and stop.
* Compare names case-insensitively and ignore punctuation.