See a Dynamics GP customer's account and Mailchimp engagement together

**Objective:** Give a combined view of the customer `{customer}` (a GP customer ID, a customer name or an email address), covering Dynamics GP receivables and sales for the last `{lookback-days}` days (default 90) and Mailchimp marketing activity.

**Step 1: Identify the customer in Dynamics GP**

If `{customer}` contains @, call `dynamics-gp-get-rm-customer` with max-records 500 and find the customer whose lower-cased `main-email-address` matches. Otherwise call `dynamics-gp-get-rm-customer` with customer-id `{customer}`, and if nothing comes back, with customer-name.contains `{customer}`. If more than one customer matches, list them with customer-id and stop. If none matches and `{customer}` is an email, continue with Mailchimp only and say the person is not a GP customer.

**Step 2: Dynamics GP detail**

Call `dynamics-gp-get-rm-trx` with the customer-id and void-status false and report items with a non-zero `current-transaction-amount` (open items), flagging any whose due-date is past. Call `dynamics-gp-get-rm-sales-trx` with the customer-id and document-date.from today minus `{lookback-days}` days.

**Step 3: Carry the email to Mailchimp**

Use `main-email-address` (or `{customer}` if it was the email). Call `mailchimp-get-list-member` with email, `mailchimp-get-customer` with email, `mailchimp-get-order` with customer-email-address, and `mailchimp-get-campaign-email-activity` with email-address and activity-date.from today minus `{lookback-days}` days.

**Step 4: Report**

1. Customer header: GP customer-id, name, class, salesperson, hold, credit limit, customer-balance.
2. Receivables: open items with document-number, document-type, due-date, current-transaction-amount, and the total past due.
3. Recent GP sales documents: sop-number, sop-type, document-date, document-amount.
4. Mailchimp: each audience with status, tags and average open and click rate; store orders count and total spent; recent opens and clicks by campaign.
5. Anything worth acting on, such as a customer on hold who is still clicking campaigns, or a subscriber who has unsubscribed with an open balance.

**Rules & Guidelines:**

* `dynamics-gp-get-rm-customer`, `dynamics-gp-get-rm-trx` and `dynamics-gp-get-rm-sales-trx` are on the dynamics-gp server. `mailchimp-get-list-member`, `mailchimp-get-customer`, `mailchimp-get-order` and `mailchimp-get-campaign-email-activity` are on the mailchimp server.
* This prompt is read-only. Do NOT call `dynamics-gp-rm-customer-update`, `dynamics-gp-rm-customer-note`, `mailchimp-update-list-member`, `mailchimp-update-customer` or any other write tool.

**Validation:**

* If the GP customer has no email address, report the GP side and say Mailchimp could not be checked.
* If Mailchimp returns nothing for the email, say the customer is not in any audience or store.