Spot Shopify B2B buyers on hold or over limit in Dynamics GP

**Objective:** Review credit exposure for the Shopify B2B company `{company-name}` (default: every company, up to 100), using the Dynamics GP customer each one is linked to, and flag companies that are over their limit, on hold, or not linked at all.

**Step 1: Read the Shopify companies**

Call `shopify-get-company` (Shopify server) with `name.contains` = `{company-name}` when it is given, otherwise with `max-records` = 100. The company's `external-id` holds the Dynamics GP `customer-id`. Put companies with an empty `external-id` aside as unlinked.

**Step 2: Read the Dynamics GP customer**

For each linked company call `dynamics-gp-get-rm-customer` (Dynamics GP server) with `customer-id` = the `external-id`, passing `company` = `{gp-company}` when it is given. Read `customer-balance`, `credit-limit-amount`, `hold`, `inactive` and `payment-terms-id`. Then call `dynamics-gp-get-rm-trx` (Dynamics GP server) with the same `customer-id` to find open documents, and note any invoice whose `due-date` has passed while `current-transaction-amount` is above zero.

If GP returns no customer, report the company as linked to a GP customer that does not exist, and continue.

**Step 3: Report**

A table: Shopify company, GP customer ID, GP balance, credit limit, available credit (limit minus balance), overdue amount, hold, inactive, Shopify `total-spent`. Flag a row when it is on hold, inactive, over its limit, or has overdue invoices. Then list the unlinked companies and those linked to a missing GP customer.

**Rules & Guidelines:**

* `shopify-get-company` is on the Shopify server; `dynamics-gp-get-rm-customer` and `dynamics-gp-get-rm-trx` are on the Dynamics GP server.
* This is read-only. Do NOT call `shopify-update-company`, `dynamics-gp-rm-customer-update` or `dynamics-gp-rm-customer-add`. To link a company, the user can run the link-b2b-company-to-gp prompt.

**Validation:**

* A credit limit of zero in GP usually means no limit is set; show it as none rather than flagging every such customer as over the limit.
* If `{company-name}` matches no Shopify company, say so and stop.