See where a Business Central job really stands

**Objective:** Report where the job `{job}` stands: budget against actual, billing, and time booked.

Pass `{company}` as the company argument on every call. If `{company}` is empty, leave the company argument out so the connector's default company is used.

**Step 1: Find the job**

Call `business-central-get-job` with job-number set to `{job}`. If nothing comes back, call it with description.contains set to `{job}`. If several match, list them and stop. Note status, bill-to-name, person-responsible-name, starting-date, ending-date, complete, recognized-sales-amount and recognized-costs-amount.

**Step 2: Tasks**

Call `business-central-get-job-task` with job-number. Use task-type Posting lines for totals so that heading and total lines are not double counted. For each task compare total-cost-budget with total-cost-usage and total-price-budget with total-price-usage, and compare total-price-billable with invoiced-price-billable.

**Step 3: Time**

Call `business-central-get-timesheet` with job-number. Sum quantity by resource-name and by status, and note hours that are not yet posted.

**Step 4: Report**

* Header: job, customer, manager, status, dates, and whether ending-date has passed while status is still Open
* Totals: cost budget, cost used, percent used; price budget, price used
* Tasks over budget: task, description, budget, usage, overrun
* Billable not yet invoiced: total-price-billable minus invoiced-price-billable, by task
* Hours by resource and status

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool named business-central-create-* or business-central-update-*.

**Validation:**

* If the job has no tasks, report the header and time only.