Renew service contracts on time and at the right price

**Objective:** Find service contracts for `{customer-name}` (default all customers) whose end date falls in the next `{days-ahead}` days (default 60), and give the account manager what they need to renew each one.

Pass `{company}` as `company` on every call (if it is empty, omit `company` and the default company is used). Pass a generous `max-records` (1000). If a result comes back with exactly that many rows, say the result may be truncated.

**Step 1: Contracts ending soon**

Call `dynamics-gp-get-srv-contract`, with `customer-name.contains` when given. There is no end-date filter, so filter the rows yourself: keep contracts whose `end-date` is between today and today plus the window, and also list separately any whose `end-date` has already passed but whose `status` still looks active.

**Step 2: What each contract covers**

For each kept contract call `dynamics-gp-get-srv-contract-line` filtered by `contract-number`. Count lines, list `item-number` and `serial-number` per line, and total `total` and `total-billed`.

**Step 3: How much service it consumed**

For each distinct `customer-id`, call `dynamics-gp-get-srv-service-call` filtered by `customer-id` with `entry-date.from` set to one year ago. Count calls and sum `total`. Compare that service value with the contract `total` to show whether the contract is priced above or below what it cost to serve.

**Step 4: Report**

A table sorted by `end-date`: contract number, customer, contract type, end date, days left, contract total, billed to date, lines covered, calls in the last year, service value in the last year, and a one-word renewal note (renew, reprice, review). Then the list of lapsed-but-active contracts.

**Rules & Guidelines:**

* Read-only. Do not call `dynamics-gp-srv-equipment-update`, `dynamics-gp-srv-service-call-update`, `dynamics-gp-pa-contract-add` or any tool whose name does not contain `get`.
* Reprice means service value exceeded the contract total. Say that in the report so the note is not read as an opinion.

**Validation:**

* If nothing ends in the window, say so and give the next contract end date after it.