Spot overdue customers who keep ordering in BigCommerce

**Objective:** Build a combined sales and receivables profile for the customer with email `{email}`, looking at orders from the last `{lookback-days}` days (default 365).

**Step 1: Find the customer in BigCommerce**

Call `bigcommerce-get-customer` (bigcommerce server) with `email` set to `{email}`. If nothing matches, report that the customer is not in BigCommerce and stop. If several match, list them and stop. Keep `id`, `name`, `company` and `customer-group-id`.

**Step 2: Get their orders**

Call `bigcommerce-get-order` (bigcommerce server) with `customer-id` set to the customer id and `date-created.from` set to the start of the lookback window. Total the order count and `total-including-tax`, count orders by `status`, and note the latest `date-created` and the total `refunded-amount`.

**Step 3: Find the customer in Intacct**

Call `intacct-get-customer` (intacct server) with `customer-name.contains` set to the BigCommerce `company` if present, otherwise to the customer's full `name`. If more than one customer comes back, list them with `customer-id` and `city` and pick the one whose `email` equals `{email}`; if none does, stop and report the candidates. If nothing comes back, report the customer as present in BigCommerce and absent from Intacct and skip to Step 5. Keep `customer-id`, `customer-name`, `status`, `term`, `credit-limit`, `total-due` and `last-invoice-date`.

**Step 4: Get their open invoices**

Call `intacct-get-invoice` (intacct server) with `customer-id` set to the Intacct customer id and `total-due.min` set to 0.01. List each `invoice-number`, `invoice-date`, `due-date`, `total-due` and `state`, oldest first.

**Step 5: Report**

Show three short blocks: BigCommerce (customer id, group, order count, total spend, refunds, last order date), Intacct (customer id, status, terms, credit limit, total due, open invoices) and Observations. In Observations flag: balance due above credit limit, overdue invoices while new orders keep arriving, and an Intacct status other than active.

**Rules & Guidelines:**

* `bigcommerce-get-customer` and `bigcommerce-get-order` are on the bigcommerce server. `intacct-get-customer` and `intacct-get-invoice` are on the intacct server.
* This prompt only reads. Never call any `bigcommerce-customer-add`, `bigcommerce-customer-update`, `bigcommerce-customer-delete`, `bigcommerce-product-add`, `bigcommerce-product-update` or other bigcommerce add, update or delete tool, and never call `intacct-create-customer`, `intacct-update-customer`, `intacct-create-vendor`, `intacct-create-order-entry-document`, `intacct-update-order-entry-document` or any other Intacct create or update tool.
* Match people across the two systems on email address first, then on company or customer name compared case-insensitively. BigCommerce `id` and Intacct `customer-id` are unrelated numbering and must not be compared.
* Amounts may be in different currencies; state the currency each side reports and do not add them together.

**Validation:**

* If there are no orders in the window, say so and still report the Intacct side.
* If Intacct returns no open invoices, say the customer has nothing outstanding.