Check a customer's account and marketing status together

**Objective:** Build one profile for the person with email `{email}`, combining their Drip marketing record with their Business Central customer or contact record. Use Business Central company `{bc-company}` if given, otherwise the default company.

**Step 1: Find them in Business Central**

Call `business-central-get-customer` with `email` set to `{email}`. If nothing comes back, call `business-central-get-contact` with `email` set to `{email}`. If either returns more than one record, list them (number, name, email) and use all of them in the report rather than guessing.

**Step 2: Find them in Drip**

Call `drip-get-subscriber` with `email` set to `{email}`. Then call `drip-get-campaign-subscriber` with `email` set to `{email}` to get every campaign they are in.

**Step 3: Pull their account activity**

If Step 1 found a customer, take its `customer-number` and call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to it (`max-records` 10), and `business-central-get-sales-transaction` with `sell-to-customer-number` set to it to see open quotes and orders.

**Step 4: Report**

* Identity: name, email, Business Central customer or contact number, Drip `person-id`
* Marketing: Drip `status`, `lead-score`, `lifetime-value`, `tags`, and each campaign with its `campaign-status`
* Account: `balance-due`, `credit-limit`, `blocked`, `salesperson-code`, the latest invoices with `remaining-amount`, and open sales documents
* Flags: unsubscribed in Drip but an active customer; a balance due while still in active campaigns; a blocked customer still being marketed to

**Rules & Guidelines:**

* Tools whose names start with drip are on the drip server; tools whose names start with business-central are on the business-central server.
* The `company` parameter means a Drip account on drip tools and a Business Central company on business-central tools. Pass `{bc-company}` only to business-central tools.
* This prompt is read-only. Do NOT call `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-unsubscribe-subscriber`, `drip-remove-subscriber-from-all-campaigns`, `business-central-update-customer` or `business-central-create-contact`.

**Validation:**

* If neither system knows the email, say so and stop.
* If only one system knows it, report that side fully and state plainly that the person is absent from the other.
* Compare emails case-insensitively and ignoring surrounding spaces.