See one supplier's Ramp spend next to its Dynamics GP payments

**Objective:** For merchant or vendor `{merchant-name}` between `{from-date}` and `{to-date}`, compare spend recorded in Ramp with payments recorded in Dynamics GP company `{gp-company}`.

**Step 1: Ramp card spend**

Call `ramp-get-transaction` (ramp) with `merchant-name.contains` set to `{merchant-name}`, `transaction-time.from` set to `{from-date}` and `transaction-time.to` set to `{to-date}`. Keep `amount`, `currency-code`, `state`, `sync-status`, `transaction-time`. Total the cleared amounts and count the ones not yet synced.

**Step 2: Ramp reimbursements**

Call `ramp-get-reimbursement` (ramp) with `transaction-date.from` and `transaction-date.to` set to the same dates, and keep rows whose `merchant` contains `{merchant-name}`. Total `entity-amount`.

**Step 3: GP payments**

Call `powergp-online-get-vendors` (powergp-online-ai) with `vendor-name.contains` set to `{merchant-name}` and `company` set to `{gp-company}`. If exactly one matches, call `powergp-online-get-payablesapply` (powergp-online-ai) with its `vendor-id`, `company`, `applied-date.from` and `applied-date.to` set to the dates, and total `applied-amount`. If none match, state that the merchant has no GP vendor. If several match, list them and stop.

**Step 4: Report**

Side-by-side totals: Ramp card, Ramp reimbursements, GP applied payments. Note unsynced Ramp card spend and the case where there is Ramp spend but no GP vendor. Do not state any total as the sum of the three, since a payment can appear in more than one system.

**Rules & Guidelines:**

* Tools whose names start with ramp-get are on the ramp server; tools whose names start with powergp-online-get are on the powergp-online-ai server. Both servers must be connected.
* This prompt is read-only. Never call any Ramp tool that adds, updates, deletes, archives, suspends or terminates anything (any `-add`, `-update`, `-delete`, `-archive`, `-suspend` or `-terminate` tool on the ramp server). The powergp-online-ai server has no write tools.
* Pass `company` to every GP tool; if `{gp-company}` is empty, ask which GP company to use before calling.
* Report amounts with their currency. Do not net amounts across different currencies.

**Validation:**

* If dates are missing or reversed, ask for them before any call.
* Refunds and declined transactions are excluded from totals; say how many you excluded.