Skip to main content
Glama
1c-odata-mcp

1c-odata-mcp

by foxnaim

ОСВ по счёту

read.accounting.get_account_turnover
Read-only

Retrieves account turnover for a date range, returning opening and closing debit/credit balances, debit/credit turnovers, subaccount details, and optional organization filtering.

Instructions

Оборотно-сальдовая ведомость по бухгалтерскому счёту (регистр бухгалтерии Хозрасчетный, виртуальная таблица «Остатки и обороты») за период: сальдо на начало Дт/Кт, обороты Дт/Кт, сальдо на конец Дт/Кт — итогом и по субсчетам. account — код счёта или префикс («51», «60», «62», «90.01»): берутся все субсчета, код которых начинается с него. Сальдо развёрнутое по аналитике (измерения и субконто), как в стандартной ОСВ по счёту. Можно ограничить организацией. Период — даты YYYY-MM-DD включительно.

Input Schema

NameRequiredDescriptionDefault
toYesДата конца периода (YYYY-MM-DD)
fromYesДата начала периода (YYYY-MM-DD)
accountYesКод счёта или префикс субсчетов, напр. 51, 60, 62, 90.01
databaseNoИмя базы 1С из list_databases. Без указания — база по умолчанию.
organizationNoОрганизация (юрлицо) для фильтра: часть названия, ИНН или Ref_Key из list_organizations. Без указания — все организации базы.

Output Schema

NameRequiredDescriptionDefault
noteNo
scanYes
periodYes
accountYes
accountsYes
databaseYes
closingNetNo
consistentYes
openingNetNo
closingDebitYes
openingDebitYes
organizationNo
closingCreditYes
debitTurnoverYes
openingCreditYes
creditTurnoverYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.12.0

TDQS

A4.3/5.0
Behavior5/5

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

Beyond readOnlyHint and openWorldHint, it discloses the underlying 1C register and virtual table, prefix expansion to every matching subaccount, total-plus-subaccount granularity, expanded balance analytics, and inclusive period boundaries. These are concrete, invocation-visible behaviors rather than repetitions of the safety annotations.

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

Conciseness5/5

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

The purpose is front-loaded, followed by precise account, balance-granularity, filtering, and date semantics in a compact block. The accounting and 1C terminology is dense but functional, with no filler or redundant discussion of read-only safety.

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

Completeness4/5

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

Together with the fully described input schema, output schema, and annotations, the description supplies enough detail to construct a correctly scoped call. Its remaining gap is selection guidance: it does not explain how this aggregate report differs from get_account_card or get_balance_origin when an agent is choosing among accounting reads.

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

Parameters4/5

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

With 100% schema description coverage, the baseline is 3. The description adds value by clarifying that account acts as a code prefix selecting all matching subaccounts and that the from/to dates are inclusive, although its examples, organization filter, and YYYY-MM-DD wording largely overlap with the schema.

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

Purpose4/5

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

The description precisely identifies the artifact and scope: a turnover-balance report for an accounting account over a period, including opening and closing debit/credit balances and debit/credit movements, totaled and broken down by subaccount. This is much more specific than the title, but it does not explicitly distinguish the report from siblings such as get_account_card or get_balance_origin.

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

Usage Guidelines4/5

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

The references to a standard ОСВ по счёту, subaccount totals, and expanded analytics establish a clear use case for obtaining period-level account balances and movements. There is no explicit when-not guidance or explanation of when another accounting read tool would be preferable.

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

Deploy Server

Other Tools