Purchasing

Run a purchasing report

purchasing_report · Reads only · Markdown

Aged payables (what is owed to each supplier by how late) or spend (what each supplier billed and was paid).

Free*

*Free up to 1,000,000 reads a month for the whole account, then $0.50 per 10,000 reads.

An example

Who do we owe money to, and how late are we?

Your agent callspurchasing_reportFree*

The example business is Hansen & Voss, a restaurant-equipment wholesaler in Hamburg with 60 staff. The reply is the one the tool really gives.

With these arguments
{
  "report": "aged_payables"
}
What comes back
{
  "report": "aged_payables",
  "as_of": "2026-10-14",
  "suppliers": [
    {
      "supplier_id": 4101,
      "name": "Nordstahl Küchentechnik GmbH",
      "currency": "EUR",
      "bills": 1,
      "current": "462.50",
      "days_1_30": "0.00",
      "days_31_60": "0.00",
      "days_61_90": "0.00",
      "days_over_90": "0.00",
      "credits": "0.00",
      "total": "462.50"
    }
  ],
  "totals": {
    "EUR": {
      "current": "462.50",
      "days_1_30": "0.00",
      "days_31_60": "0.00",
      "days_61_90": "0.00",
      "days_over_90": "0.00",
      "credits": "0.00",
      "total": "462.50"
    }
  },
  "note": "current: not due yet; days_1_30 to days_over_90: how many days past due; credits: prepayments and overpayments to suppliers not used yet, less; total: what is owed net of them."
}

Use it when

Someone asks who the business owes and how late it is, or what it spent with whom.

What it does

aged_payables: what is owed to each supplier on as_of (default today), by how long past due: current (not due yet), 1-30, 31-60, 61-90 and over 90 days, per currency. spend: what each supplier billed from-to (by issue date; default this month) and what was paid to them in it. To show a person, put it in a view (view_show).

What comes back

The report's name and date, per supplier the bills and the amounts by age (current, 1-30, 31-60, 61-90, over 90 days) or billed and paid, the totals per currency, and a note. Every reply also carries cost_usd and balance_usd.

Inputs

NameTypeWhat it is
reportRequiredstringOne of: aged_payables,spend.
as_ofstringYYYY-MM-DD. Matches ^\d{4}-\d{2}-\d{2}$.
fromstringYYYY-MM-DD. Matches ^\d{4}-\d{2}-\d{2}$.
tostringYYYY-MM-DD. Matches ^\d{4}-\d{2}-\d{2}$.

The call

Over MCP, call purchasing_report on https://api.conecto.chat/mcp/purchasing. Over REST:

Terminal
curl -X POST https://api.conecto.chat/v1/tools/purchasing_report \
  -H "Authorization: Bearer $CONECTO_KEY" \
  -H "Content-Type: application/json" \
  -d '{"report":"aged_payables"}'

When it refuses

A refused call costs nothing and says what to do next.

CodeWhenWhat to do
invalid_input400A date or currency is not valid.Send dates like 2026-11-02 and currencies like EUR.

Give this to your agent.

Set up Conecto from https://conecto.chat/SKILL.md