Catch under-billing and overruns on project contracts

**Objective:** Show the billing position of project contracts (customer `{customer-name}`, contract `{contract-number}`; defaults all open contracts): how much is contracted, billed and spent, and what change orders and invoices are pending.

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**

Call `dynamics-gp-get-pa-contract` with `contract-number` or `customer-name.contains` when given; otherwise keep contracts whose `status` is open or active. Per contract: `contract-amount`, `actual-billings`, `actual-total-cost`, `accounting-method`, `project-type`.

**Step 2: Change orders**

Call `dynamics-gp-get-pa-change-order` by `contract-number` for each. List change orders not yet approved (by `change-order-status`) with `total-amount` and `total-cost`.

**Step 3: Open project invoices**

Per customer, call `dynamics-gp-get-pa-billing` by `customer-id` and list documents not yet posted (by `status`) with `billing-amount` and `due-date`.

**Step 4: Assess**

* Percent billed = actual billings divided by contract amount; percent spent = actual cost divided by contract amount.
* Flag contracts where spent runs ahead of billed by more than 10 points (under-billing), billings exceed the contract amount (check for approved change orders), or cost exceeds the contract amount.

**Step 5: Report**

A table per contract: number, name, customer, contract amount, billed, cost, percent billed, percent spent, margin, pending change orders, unposted invoices, and a flag column. Then the flagged contracts explained in one line each.

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool whose name does not contain `get` (no add, update, note or email tools).

**Validation:**

* If no contracts match, say so and stop.