Spot unbilled Teamwork.com time before it is written off

**Objective:** For client `{customer-name}`, compare the billable time logged in Teamwork from `{from-date}` to `{to-date}` (default: today) with the sales invoices Business Central posted to them in the same period, and show any unbilled work.

**Step 1: Find the client in Teamwork**

Call `teamwork-get-companies` (Teamwork server) with `name.contains` set to `{customer-name}`. If more than one company matches, list them and ask which one is meant. Then call `teamwork-get-projects` with that `company-id` to get every project for the client.

**Step 2: Read the billable time**

For each project, call `teamwork-get-time` with `project-id`, `is-billable` set to true, `time-logged.from` set to `{from-date}` and `time-logged.to` set to `{to-date}` (today when blank). Use dates in YYYY-MM-DD form. Sum `minutes` and `billable-total` per project, and note whether each entry is `verified`.

**Step 3: Find the customer in Business Central**

Call `business-central-get-customer` (Business Central server) with `name.contains` set to `{customer-name}`, matching on name while ignoring case, punctuation and legal suffixes. If there is no customer, report the time as work with no customer to bill and stop after Step 5.

**Step 4: Read the invoices**

Call `business-central-get-posted-sales-invoice` with `sell-to-customer-number` set to the customer-number, and `posting-date.from` and `posting-date.to` set to the same period. Then call `business-central-get-posted-sales-invoice-line` with each `invoice-number` to see what was billed. Treat lines with line-type Resource, or a description that names a project, as time billing.

**Step 5: Report**

* A table per project: hours logged, billable-total from Teamwork, and whether the hours are verified.
* A table of invoices: invoice-number, posting-date, total-amount, and the amount of time-billing lines.
* **Gap:** total billable-total from Teamwork minus the time billed in Business Central. Say whether the client looks under-billed, over-billed or square. Treat a difference within 2 percent as square.
* List the projects with billable time in the period and no invoice line that mentions them.

**Rules & Guidelines:**

* `teamwork-get-companies`, `teamwork-get-projects` and `teamwork-get-time` are on the Teamwork server. `business-central-get-customer`, `business-central-get-posted-sales-invoice` and `business-central-get-posted-sales-invoice-line` are on the Business Central server.
* This prompt is read-only. Do NOT call `business-central-create-sales-invoice`, `business-central-create-sales-invoice-line` or `teamwork-update-time-entry`. To raise the invoice, use the invoice-billable-time prompt.
* Invoices are often posted after the month they bill. Say so when the gap could be timing rather than missed billing.

**Validation:**

* If there is no billable time in the period, say so and stop.
* Teamwork totals are in the site currency and Business Central totals are in the customer's currency. If they differ, report both totals and do not work out a gap.