Build a payment run that fits the cash you have

**Objective:** Build a proposed payment run of payables invoices that are overdue or due within `{due-within-days}` days (default 14), grouped by vendor and checked against the cash in checkbook `{checkbook-id}` (default all active checkbooks).

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: Open payables**

Call `dynamics-gp-get-pm-payables-trx` with `document-date.to` set to today plus the window (a document cannot fall due before its document date, so nothing due in the window is lost). Keep non-voided documents with `current-trx-amount` greater than 0.

* Invoices, finance charges and miscellaneous charges with `due-date` on or before today plus the window go into the run.
* Credit memos and returns with a remaining amount are credits; hold them per vendor to net against that vendor's invoices.

**Step 2: Vendor standing**

For each distinct `vendor-id`, call `dynamics-gp-get-pm-vendor` filtered by `vendor-id`. Take out of the run any vendor whose `hold` is set or whose `vendor-status` is not active, and list them separately with what they are owed.

**Step 3: Cash available**

Call `dynamics-gp-get-gl-checkbook`, filtered by `checkbook-id` when given, keeping checkbooks that are not `inactive`. Note `current-balance`, `currency-id` and `last-reconciled-date`.

**Step 4: Report**

* Summary line: total proposed, total credits netted, cash available, and the shortfall or headroom.
* Per vendor (overdue vendors first, then by earliest due date): vendor id, name, terms, invoices in the run (document number, due date, days overdue or days until due, remaining amount), credits netted, net to pay.
* Vendors excluded for hold or status, with amounts.
* If cash does not cover the run, suggest which invoices to defer, keeping the most overdue in.

**Rules & Guidelines:**

* This is a proposal for someone to approve, not a payment. Say so at the top.
* Read-only. Do not call `dynamics-gp-pm-payables-trx-add`, `dynamics-gp-pm-vendor-update`, `dynamics-gp-gl-bank-transaction-add` or any tool whose name does not contain `get`.
* No tool returns discount dates, so do not claim a discount will be lost or gained.
* Do not mix currencies in one total; group by `currency-id` if checkbooks differ.

**Validation:**

* If nothing is due in the window, say so and give the next due date and amount.
* If a checkbook's `last-reconciled-date` is more than 45 days ago, warn that its balance may not reflect cleared items.