Skip to main content
Glama

Analyze Aged Payables

analyze_aged_payables
Read-onlyIdempotent

Accounts-payable aging snapshot (AgedPayables, 79).

AP by aging bucket (Current / 1-30 / 31-60 / 61+), top GL accounts owed, and a focused list of GL accounts with 61+ day balances. Mirror image of analyze_aged_receivables. Scope to a single park or portfolio with portfolio / property_ids — the report honors PropertyIDs even though its CSV has no Property column for client-side filtering.

SLOW when UNSCOPED — a portfolio-wide first call takes 1-3 minutes, so BEFORE calling without a scope send the user a one-liner: 'This report takes 1-3 minutes to generate, I'll have results shortly.' Scoping to a park or portfolio returns in seconds. Follow-up queries within 5 minutes are cached and return instantly.

Args: portfolio: Portfolio name or 3-letter prefix. property_ids: Comma-separated property IDs. Use this OR portfolio. as_of_date: MM/DD/YYYY for the as-of snapshot. Defaults to today. top_n: Number of top GL accounts to list (default 10, max 50).

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
top_nNo
portfolioNo
as_of_dateNo
property_idsNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.9/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnly/idempotent/non-destructive, but the description adds genuinely non-derivable behavior: 1-3 minute latency when unscoped, seconds when scoped, 5-minute result caching, and the caveat that PropertyIDs are honored even though the CSV has no Property column. That last point prevents a client-side filtering mistake.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loaded with the report contents, then scope, then the performance warning, then args — a sensible priority order with no filler. The trailing Args block partially restates the inline scoping prose, a minor redundancy, but nothing is wasted overall.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

An output schema exists, so return-value explanation is unnecessary, and annotations cover the safety profile. Everything an agent needs to call this correctly — scope semantics, latency expectation, caching, all four parameter formats — is present.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description carries the full burden and does. It defines portfolio format (name or 3-letter prefix), property_ids format (comma-separated) with the OR relationship, as_of_date format (MM/DD/YYYY) and default, and top_n default plus max (50), which the schema does not state.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb+resource and enumerates the actual output (AP by aging bucket, top GL accounts owed, 61+ day GL accounts), then names the sibling it mirrors ('Mirror image of analyze_aged_receivables'). An agent can distinguish it from the other ~60 analyze_* tools without opening a schema.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicit when-to-use guidance: scope with portfolio/property_ids for fast returns, and the exact prompt to send the user before an unscoped call. Also states the mutually exclusive relationship ('Use this OR portfolio') and the caching window, which changes how an agent should sequence calls.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources