Know what you owe a vendor before the next conversation

**Objective:** Produce an account review for the vendor `{vendor-name}`: what the company owes them, what is on order, and anything that needs attention.

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: Identify the vendor**

Call `business-central-get-vendor` with name.contains set to `{vendor-name}`. If more than one vendor matches, list them (number, name, city, balance) and stop. Keep the vendor-number.

**Step 2: Balance and terms**

Note balance, balance-due, blocked, payment-terms-code, payment-method-code, currency-code and purchaser-code. Flag the vendor if blocked is not blank while balance is not zero.

**Step 3: Open payables**

Call `business-central-get-posted-purchase-invoice` with buy-from-vendor-number set and closed set to false. Compute days until or past due-date for each. Call `business-central-get-posted-purchase-credit-memo` with buy-from-vendor-number set and paid set to false for credits still to be applied.

**Step 4: Open purchase documents**

Call `business-central-get-purchase-transaction` with buy-from-vendor-number set for orders, invoices and credit memos not yet posted. For open orders call `business-central-get-purchase-transaction-line` with document-number set and report outstanding-quantity and expected-receipt-date; flag lines whose expected-receipt-date has passed.

**Step 5: History and notes**

Call `business-central-get-detailed-vendor-ledger` with vendor-number set and posting-date.from 180 days ago to find the last payments. Call `business-central-get-vendor-comment` with vendor-number set. Call `business-central-get-vendor-item` with vendor-number set to show which items this vendor supplies.

**Step 6: Report**

* Header: number, name, terms, payment method, currency, blocked
* Balance and balance due
* Open invoices: number, vendor invoice number, due date, remaining amount, days to due (negative when overdue)
* Unapplied credit memos
* Open purchase documents and late receipts
* Last three payments
* Items supplied (count, and up to ten)
* Notes, newest first
* Attention list, three bullets at most

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool named business-central-create-* or business-central-update-*, in particular not `business-central-update-vendor`.
* Keep amounts in the document currency and say which currency.

**Validation:**

* If no vendor matches, say so and suggest a shorter name fragment.
* Write "none" for any empty section.