Open items
Open items (receivables and payables) come from DATEV Connect. MCP returns the synchronised balances and lines. Write tools change only Fyvel status, comments, and tags — not DATEV and not external systems (for example Stripe).Prerequisites
- DATEV Connect set up for the company
- Open items for debtors and/or creditors enabled in the DATEV company settings
- MCP user with permission Open items → View (read) or Manage (write)
list_companies: openItemsEligible, openItemsReceivablesEnabled, openItemsPayablesEnabled, openItemsConnectAvailable.
Tools
Read
list_open_items— paginated list (account or document view), filters including kind, due date, and searchget_open_item— detail for astableKey, including lines, the effective annotation, and a short activity loglist_open_item_lines— lines of a personal account, by default from the latest fiscal year (max. 500)list_open_item_statuses— valid status keys before write operations (archived keys are rejected on write)
Write (Fyvel workflow only)
upsert_open_item_document_annotation— status, comment, or tags at document levelupsert_open_item_partner_annotation— partner default for a personal accountclear_open_item_document_annotation— remove the document override (the partner default applies again)
Typical flow
list_companies— checkcompanyUuidandopenItemsEligible- Optionally
list_accounts— personal-account names for account numbers list_open_itemswithitemKind(receivable/payable) and the matchingviewMode- If needed,
get_open_itemwith thestableKeyfrom the list - After reconciling with external data, optionally set an annotation (
list_open_item_statuses→ upsert)
fiscalYearId
Optional in both list tools. For list_open_items with no value: every synchronised fiscal year. For list_open_item_lines with no value: the latest fiscal year that has lines for this personal account. The year that was actually read is in the fiscalYearId field of the response.
Notes on reconciliation
- The document reference is often in
documentField1. The open balance is inopenAmount(lists) or in the line amounts in the detail - Lists and lines return only open items by default. For cleared items, set
isClearedexplicitly - Annotations belong on the primary document key:
stableKeyfromlist_open_items(document view) orprimaryStableKeyin the detail newCommentreplaces the displayed comment and also writes an entry to the activity log- Tags suit external references (for example Stripe invoice IDs).
tagsreplaces the entire list. Withouttags, existing tags stay