Collmex MCP by usefulapi is an MCP server published by io.usefulapi, hosted at collmex.usefulapi.io. When last checked on 2026-11-21 it was working: it answers and lists its tools. It declares 15 tools, including collmex_list_customers, collmex_list_vendors, collmex_list_addresses, collmex_list_products, collmex_get_available_stock.
Review Collmex customers, products, invoices and orders; create customers and addresses.
4,135 connections through 5 shared values. Tap any node.
Squares are this server's values; dots are other servers sharing them. A shared address or publisher is a lead, not proof of a common operator.
Inferred from the host name and headers: what a server runs on, not who runs it.
Search Collmex customers (record CUSTOMER_GET): by customer number, free text (name, city, e-mail ...), postal code or country. Returns address, contact, bank (IBAN/BIC), VAT id, payment terms, agent and status fields. Inactive customers are left out unless asked for.
| Parameter | Type | Description |
|---|---|---|
| text | string | Free-text search (max 80 characters). |
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| customer_no | integer | Only this customer number. |
| address_group | integer | Only customers of this address group number. |
| follow_up_due | boolean | Only customers due for follow-up (Wiedervorlage). |
| include_inactive | boolean | Also return inactive customers. |
| postcode_country | string | Postal code or country code to search by. |
{
"name": "collmex_list_customers",
"title": "List customers",
"description": "Search Collmex customers (record CUSTOMER_GET): by customer number, free text (name, city, e-mail ...), postal code or country. Returns address, contact, bank (IBAN/BIC), VAT id, payment terms, agent and status fields. Inactive customers are left out unless asked for.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"text": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "Free-text search (max 80 characters)."
},
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"customer_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this customer number.",
"exclusiveMinimum": 0
},
"address_group": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only customers of this address group number.",
"exclusiveMinimum": 0
},
"follow_up_due": {
"type": "boolean",
"description": "Only customers due for follow-up (Wiedervorlage)."
},
"include_inactive": {
"type": "boolean",
"description": "Also return inactive customers."
},
"postcode_country": {
"type": "string",
"maxLength": 8,
"minLength": 1,
"description": "Postal code or country code to search by."
}
}
},
"annotations": {
"title": "List customers",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Search Collmex vendors/suppliers (record VENDOR_GET): by vendor number, free text, postal code or country. Returns address, contact, bank, VAT id, payment terms and expense account fields.
| Parameter | Type | Description |
|---|---|---|
| text | string | Free-text search (max 80 characters). |
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| vendor_no | integer | Only this vendor number. |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| follow_up_due | boolean | Only vendors due for follow-up (Wiedervorlage). |
| postcode_country | string | Postal code or country code to search by. |
{
"name": "collmex_list_vendors",
"title": "List vendors",
"description": "Search Collmex vendors/suppliers (record VENDOR_GET): by vendor number, free text, postal code or country. Returns address, contact, bank, VAT id, payment terms and expense account fields.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"text": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "Free-text search (max 80 characters)."
},
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"vendor_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this vendor number.",
"exclusiveMinimum": 0
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"follow_up_due": {
"type": "boolean",
"description": "Only vendors due for follow-up (Wiedervorlage)."
},
"postcode_country": {
"type": "string",
"maxLength": 8,
"minLength": 1,
"description": "Postal code or country code to search by."
}
}
},
"annotations": {
"title": "List vendors",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Search the Collmex address book (record ADDRESS_GET): customers, vendors and address-book entries in one list, optionally with their contact persons. address_type: 0 all, 1 customers, 2 vendors, 3 address-book entries.
| Parameter | Type | Description |
|---|---|---|
| text | string | Free-text search (max 80 characters). |
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| address_no | integer | Only this address number. |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| address_type | integer | 0 or empty = all, 1 = customers, 2 = vendors, 3 = address-book entries. |
| address_group | integer | Only addresses of this address group number. |
| follow_up_due | boolean | Only addresses due for follow-up (Wiedervorlage). |
| include_contacts | boolean | Also return contact persons (address_type 4 rows). |
Search Collmex products (record PRODUCT_GET): by product number, product group, free text (number, description, remark, GTIN, manufacturer) or price group. Returns description, unit, tax class, sales price, purchase data and stock settings.
| Parameter | Type | Description |
|---|---|---|
| text | string | Free-text search (max 80 characters). |
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| product_no | string | Only this product number. |
| price_group | string | Return the price of this price group (default: standard price group 0). |
| product_group | integer | Only products of this product group (and its subgroups). |
| only_with_price | boolean | Only products that have a price. |
Currently available stock per product (record STOCK_AVAILABLE_GET): on-hand stock of the available stock types minus demand due today or earlier. A service product shows (NULL). Leave product_no empty for every product.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| product_no | string | Only this product number. |
{
"name": "collmex_get_available_stock",
"title": "Get available stock",
"description": "Currently available stock per product (record STOCK_AVAILABLE_GET): on-hand stock of the available stock types minus demand due today or earlier. A service product shows (NULL). Leave product_no empty for every product.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"product_no": {
"type": "string",
"maxLength": 20,
"minLength": 1,
"description": "Only this product number."
}
}
},
"annotations": {
"title": "Get available stock",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Search Collmex customer invoices and credit notes (record INVOICE_GET): by invoice number, customer, invoice date range, customer order or product. Each invoice has its header (customer address, dates, payment terms, status code: 0 new, 10 to be posted, 20 open, 30 dunned, 40 settled, 100 deleted) and its positions with quantities, prices and values. Reads only; no PDF/XML export.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| date_to | string | Invoice date to (yyyy-mm-dd). |
| date_from | string | Invoice date from (yyyy-mm-dd). |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| invoice_no | integer | Only this invoice number. |
| product_no | string | Only invoices with this product on at least one position. |
| customer_no | integer | Only invoices of this customer number. |
| only_issued | boolean | Only invoices already printed or sent. |
Search Collmex customer orders (record SALES_ORDER_GET): by order number, customer, order date range or the customer's own order number. Each order has its header (customer address, dates, payment terms, status code: 0 new, 10 confirmed, 30 paid, 50 delivered, 90 invoiced, 100 done, 1000 cancelled) and its positions. Reads only; no PDF export.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| date_to | string | Order date to (yyyy-mm-dd). |
| order_no | integer | Only this order number. |
| date_from | string | Order date from (yyyy-mm-dd). |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| customer_no | integer | Only orders of this customer number. |
| customer_purchase_order_no | string | The customer's own order number. |
The payment terms defined in Collmex (record TERMS_OF_PAYMENT_GET): number, description, payment method and discount periods. The number is what customers, vendors and invoices refer to as payment_terms.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
{
"name": "collmex_list_payment_terms",
"title": "List payment terms",
"description": "The payment terms defined in Collmex (record TERMS_OF_PAYMENT_GET): number, description, payment method and discount periods. The number is what customers, vendors and invoices refer to as payment_terms.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
}
}
},
"annotations": {
"title": "List payment terms",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Open items (unpaid invoices) from the Collmex accounting (record OPEN_ITEMS_GET), for customers (receivables, default) or vendors (payables). Returns invoice number, document and due date, days overdue, dunning level, amount, paid and outstanding. Optionally as of a key date.
| Parameter | Type | Description |
|---|---|---|
| kind | string | customer (default) = receivables, vendor = payables. |
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| key_date | string | Key date (yyyy-mm-dd); default today. |
| vendor_no | integer | Only this vendor number. |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| customer_no | integer | Only this customer number. |
{
"name": "collmex_list_open_items",
"title": "List open items",
"description": "Open items (unpaid invoices) from the Collmex accounting (record OPEN_ITEMS_GET), for customers (receivables, default) or vendors (payables). Returns invoice number, document and due date, days overdue, dunning level, amount, paid and outstanding. Optionally as of a key date.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"kind": {
"enum": [
"customer",
"vendor"
],
"type": "string",
"description": "customer (default) = receivables, vendor = payables."
},
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"key_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Key date (yyyy-mm-dd); default today."
},
"vendor_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this vendor number.",
"exclusiveMinimum": 0
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"customer_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this customer number.",
"exclusiveMinimum": 0
}
}
},
"annotations": {
"title": "List open items",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Accounting postings (record ACCDOC_GET), one row per posting position: posting number, date, text, account, debit/credit (0 debit, 1 credit), amount, customer/vendor, invoice number. Filter by fiscal year, account, cost centre, customer, vendor, invoice or document date range. Cancelled postings are excluded unless asked for.
| Parameter | Type | Description |
|---|---|---|
| text | string | Free text in the posting text and memo (max 80 characters). |
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| date_to | string | Document date to (yyyy-mm-dd). |
| date_from | string | Document date from (yyyy-mm-dd). |
| vendor_no | integer | Only this vendor number. |
| account_no | integer | Only this account number. |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| invoice_no | integer | Only this invoice number. |
Account balances from the Collmex accounting (record ACCBAL_GET) for a fiscal year: account number, name and balance. Filter by account, account group (1 other, 2 fixed assets, 3 bank/cash, 4 income, 5 expenses, 6 output VAT, 7 input VAT, 8 receivables, 9 payables, 10 depreciation, 11 provisions, 12 inventory, 13 private, 14 non-deductible expenses), cost centre or an up-to date. With a customer or vendor given, the date is ignored.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| date_to | string | Balance up to this date (yyyy-mm-dd). |
| vendor_no | integer | Balance of this vendor. |
| account_no | integer | Only this account number. |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| cost_center | string | Only this cost centre. |
| customer_no | integer | Balance of this customer. |
| fiscal_year * | integer |
Collmex projects (record PROJECT_GET) with customer, budget, value of recorded activities, completion state and the project's rates (rate number, description, product, hourly or daily rate).
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| status | string | all (default), active or completed. |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| project_no | integer | Only this project number. |
| customer_no | integer | Only projects of this customer. |
{
"name": "collmex_list_projects",
"title": "List projects",
"description": "Collmex projects (record PROJECT_GET) with customer, budget, value of recorded activities, completion state and the project's rates (rate number, description, product, hourly or daily rate).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"status": {
"enum": [
"all",
"active",
"completed"
],
"type": "string",
"description": "all (default), active or completed."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"project_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this project number.",
"exclusiveMinimum": 0
},
"customer_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only projects of this customer.",
"exclusiveMinimum": 0
}
}
},
"annotations": {
"title": "List projects",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Recorded time-tracking activities (record ACTIVITIES_GET): project, employee, date, from/to times, breaks, description, and the invoice that billed it. Filter by project, employee (needs company), date range, only not-yet-billed or only invoice-relevant activities.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). |
| offset | integer | Records to skip (use next_offset from the previous reply). |
| date_to | string | Activity date to (yyyy-mm-dd). |
| date_from | string | Activity date from (yyyy-mm-dd). |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| not_billed | boolean | Only activities not yet invoiced. |
| project_no | integer | Only activities of this project. |
| employee_no | integer | Only activities of this employee number (company_no applies). |
| billable_only | boolean | Only activities of customer projects with an amount above zero. |
WRITE: create a NEW customer in Collmex (record CMXKND without a customer number, so Collmex assigns the next number; an existing customer is never overwritten). Each call creates another customer: check collmex_list_customers first to avoid duplicates. Nothing is sent to the customer. Give at least a company or a last name. Returns the new customer number.
| Parameter | Type | Description |
|---|---|---|
| fax | string | Fax. |
| city | string | City. |
| string | E-mail address. | |
| phone | string | Phone. |
| title | string | Title (for example Dr.). |
| remark | string | Internal remark. |
| street | string | Street and house number. |
| vat_id | string | EU VAT id. |
| company | string | Company name. |
| country | string | 2-letter ISO country code (DE, AT, CH ...). |
| currency | string | 3-letter currency code, for example EUR. |
WRITE: create a NEW entry in the Collmex address book (record CMXADR, address type 3, no address number so Collmex assigns one; existing addresses are never overwritten). Each call creates another entry: check collmex_list_addresses first to avoid duplicates. Nothing is sent to the person. Give at least a company or a last name. Returns the new address number.
| Parameter | Type | Description |
|---|---|---|
| fax | string | Fax. |
| url | string | Website. |
| city | string | City. |
| string | E-mail address. | |
| phone | string | Phone. |
| title | string | Title (for example Dr.). |
| remark | string | Internal remark. |
| street | string | Street and house number. |
| company | string | Company name. |
| country | string | 2-letter ISO country code (DE, AT, CH ...). |
| last_name | string | Last name. |
Tools for Collmex, hosted by usefulapi.io. If the user is new or asks what this server can do, suggest requests such as: "Which customer invoices are still open and how many days overdue are they?"; "Show all invoices to customer 12345 from the last quarter."; "How much stock is available for product A-100?". Read-only tools never change data; ask the user before a tool that creates, changes or deletes Collmex data. Free plan: 50 tool calls per month. Run collmex_usage_status to see the calls used this month. If the user asks for something none of these tools can do, tell the user and, with their OK, run collmex_request_feature to record the request. Paid plans: Pro (10,000 tool calls a month, $9/month or $90/year, for normal use) and Pro+ (100,000 tool calls a month, $39/month or $390/year, for automations and heavy use). A plan can be cancelled at any time and then runs to the end of the paid period, so it also suits a one-time job. When the user wants more calls or reaches the limit, run collmex_upgrade without a plan: it returns both plans, each with a payment link for the user to open. collmex_cancel_subscription cancels Pro at the end of the paid period.
Names, descriptions and schemas were written by the server and are shown as data.
Pattern matches on what the server declares. They show what it says it can do, not what it does.
None yet. Changes appear after a server's second daily check.
| include_inactive |
| boolean |
| Also return inactive addresses. |
| postcode_country | string | Postal code or country code to search by. |
{
"name": "collmex_list_addresses",
"title": "List addresses",
"description": "Search the Collmex address book (record ADDRESS_GET): customers, vendors and address-book entries in one list, optionally with their contact persons. address_type: 0 all, 1 customers, 2 vendors, 3 address-book entries.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"text": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "Free-text search (max 80 characters)."
},
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"address_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this address number.",
"exclusiveMinimum": 0
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"address_type": {
"type": "integer",
"maximum": 3,
"minimum": 0,
"description": "0 or empty = all, 1 = customers, 2 = vendors, 3 = address-book entries."
},
"address_group": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only addresses of this address group number.",
"exclusiveMinimum": 0
},
"follow_up_due": {
"type": "boolean",
"description": "Only addresses due for follow-up (Wiedervorlage)."
},
"include_contacts": {
"type": "boolean",
"description": "Also return contact persons (address_type 4 rows)."
},
"include_inactive": {
"type": "boolean",
"description": "Also return inactive addresses."
},
"postcode_country": {
"type": "string",
"maxLength": 8,
"minLength": 1,
"description": "Postal code or country code to search by."
}
}
},
"annotations": {
"title": "List addresses",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}{
"name": "collmex_list_products",
"title": "List products",
"description": "Search Collmex products (record PRODUCT_GET): by product number, product group, free text (number, description, remark, GTIN, manufacturer) or price group. Returns description, unit, tax class, sales price, purchase data and stock settings.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"text": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "Free-text search (max 80 characters)."
},
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"product_no": {
"type": "string",
"maxLength": 20,
"minLength": 1,
"description": "Only this product number."
},
"price_group": {
"type": "string",
"maxLength": 20,
"minLength": 1,
"description": "Return the price of this price group (default: standard price group 0)."
},
"product_group": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only products of this product group (and its subgroups).",
"exclusiveMinimum": 0
},
"only_with_price": {
"type": "boolean",
"description": "Only products that have a price."
}
}
},
"annotations": {
"title": "List products",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}| customer_order_no | integer | Only invoices for this customer order number. |
{
"name": "collmex_list_invoices",
"title": "List invoices",
"description": "Search Collmex customer invoices and credit notes (record INVOICE_GET): by invoice number, customer, invoice date range, customer order or product. Each invoice has its header (customer address, dates, payment terms, status code: 0 new, 10 to be posted, 20 open, 30 dunned, 40 settled, 100 deleted) and its positions with quantities, prices and values. Reads only; no PDF/XML export.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"date_to": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Invoice date to (yyyy-mm-dd)."
},
"date_from": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Invoice date from (yyyy-mm-dd)."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"invoice_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this invoice number.",
"exclusiveMinimum": 0
},
"product_no": {
"type": "string",
"maxLength": 20,
"minLength": 1,
"description": "Only invoices with this product on at least one position."
},
"customer_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only invoices of this customer number.",
"exclusiveMinimum": 0
},
"only_issued": {
"type": "boolean",
"description": "Only invoices already printed or sent."
},
"customer_order_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only invoices for this customer order number.",
"exclusiveMinimum": 0
}
}
},
"annotations": {
"title": "List invoices",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}{
"name": "collmex_list_sales_orders",
"title": "List sales orders",
"description": "Search Collmex customer orders (record SALES_ORDER_GET): by order number, customer, order date range or the customer's own order number. Each order has its header (customer address, dates, payment terms, status code: 0 new, 10 confirmed, 30 paid, 50 delivered, 90 invoiced, 100 done, 1000 cancelled) and its positions. Reads only; no PDF export.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"date_to": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Order date to (yyyy-mm-dd)."
},
"order_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this order number.",
"exclusiveMinimum": 0
},
"date_from": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Order date from (yyyy-mm-dd)."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"customer_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only orders of this customer number.",
"exclusiveMinimum": 0
},
"customer_purchase_order_no": {
"type": "string",
"maxLength": 20,
"minLength": 1,
"description": "The customer's own order number."
}
}
},
"annotations": {
"title": "List sales orders",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}| posting_no |
| integer |
| Only this posting number. |
| cost_center | integer | Only this cost centre. |
| customer_no | integer | Only this customer number. |
| fiscal_year | integer | Fiscal year (for example 2026); default all years. |
| include_reversals | boolean | Also return cancelled and cancellation postings. |
{
"name": "collmex_list_accounting_documents",
"title": "List accounting postings",
"description": "Accounting postings (record ACCDOC_GET), one row per posting position: posting number, date, text, account, debit/credit (0 debit, 1 credit), amount, customer/vendor, invoice number. Filter by fiscal year, account, cost centre, customer, vendor, invoice or document date range. Cancelled postings are excluded unless asked for.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"text": {
"type": "string",
"maxLength": 80,
"minLength": 1,
"description": "Free text in the posting text and memo (max 80 characters)."
},
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"date_to": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Document date to (yyyy-mm-dd)."
},
"date_from": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Document date from (yyyy-mm-dd)."
},
"vendor_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this vendor number.",
"exclusiveMinimum": 0
},
"account_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this account number.",
"exclusiveMinimum": 0
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"invoice_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this invoice number.",
"exclusiveMinimum": 0
},
"posting_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this posting number.",
"exclusiveMinimum": 0
},
"cost_center": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this cost centre.",
"exclusiveMinimum": 0
},
"customer_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this customer number.",
"exclusiveMinimum": 0
},
"fiscal_year": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Fiscal year (for example 2026); default all years.",
"exclusiveMinimum": 0
},
"include_reversals": {
"type": "boolean",
"description": "Also return cancelled and cancellation postings."
}
}
},
"annotations": {
"title": "List accounting postings",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}| Fiscal year, for example 2026. |
| account_group | integer | Only this account group (1-14). |
{
"name": "collmex_get_account_balances",
"title": "Get account balances",
"description": "Account balances from the Collmex accounting (record ACCBAL_GET) for a fiscal year: account number, name and balance. Filter by account, account group (1 other, 2 fixed assets, 3 bank/cash, 4 income, 5 expenses, 6 output VAT, 7 input VAT, 8 receivables, 9 payables, 10 depreciation, 11 provisions, 12 inventory, 13 private, 14 non-deductible expenses), cost centre or an up-to date. With a customer or vendor given, the date is ignored.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"fiscal_year"
],
"properties": {
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"date_to": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Balance up to this date (yyyy-mm-dd)."
},
"vendor_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Balance of this vendor.",
"exclusiveMinimum": 0
},
"account_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only this account number.",
"exclusiveMinimum": 0
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"cost_center": {
"type": "string",
"maxLength": 10,
"minLength": 1,
"description": "Only this cost centre."
},
"customer_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Balance of this customer.",
"exclusiveMinimum": 0
},
"fiscal_year": {
"type": "integer",
"maximum": 2100,
"minimum": 1990,
"description": "Fiscal year, for example 2026."
},
"account_group": {
"type": "integer",
"maximum": 14,
"minimum": 1,
"description": "Only this account group (1-14)."
}
}
},
"annotations": {
"title": "Get account balances",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}{
"name": "collmex_list_activities",
"title": "List project activities",
"description": "Recorded time-tracking activities (record ACTIVITIES_GET): project, employee, date, from/to times, breaks, description, and the invoice that billed it. Filter by project, employee (needs company), date range, only not-yet-billed or only invoice-relevant activities.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"limit": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit)."
},
"offset": {
"type": "integer",
"maximum": 1000000,
"minimum": 0,
"description": "Records to skip (use next_offset from the previous reply)."
},
"date_to": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Activity date to (yyyy-mm-dd)."
},
"date_from": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Activity date from (yyyy-mm-dd)."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"not_billed": {
"type": "boolean",
"description": "Only activities not yet invoiced."
},
"project_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only activities of this project.",
"exclusiveMinimum": 0
},
"employee_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Only activities of this employee number (company_no applies).",
"exclusiveMinimum": 0
},
"billable_only": {
"type": "boolean",
"description": "Only activities of customer projects with an amount above zero."
}
}
},
"annotations": {
"title": "List project activities",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}| last_name | string | Last name. |
| company_no | integer | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. |
| department | string | Department. |
| first_name | string | First name. |
| salutation | string | Salutation (for example Herr, Frau). |
| postal_code | string | Postal code. |
| payment_terms | integer | Payment terms number (see collmex_list_payment_terms); empty = Collmex default. |
{
"name": "collmex_create_customer",
"title": "Create customer",
"description": "WRITE: create a NEW customer in Collmex (record CMXKND without a customer number, so Collmex assigns the next number; an existing customer is never overwritten). Each call creates another customer: check collmex_list_customers first to avoid duplicates. Nothing is sent to the customer. Give at least a company or a last name. Returns the new customer number.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"fax": {
"type": "string",
"maxLength": 40,
"description": "Fax."
},
"city": {
"type": "string",
"maxLength": 40,
"description": "City."
},
"email": {
"type": "string",
"maxLength": 50,
"description": "E-mail address."
},
"phone": {
"type": "string",
"maxLength": 40,
"description": "Phone."
},
"title": {
"type": "string",
"maxLength": 10,
"description": "Title (for example Dr.)."
},
"remark": {
"type": "string",
"maxLength": 1024,
"description": "Internal remark."
},
"street": {
"type": "string",
"maxLength": 40,
"description": "Street and house number."
},
"vat_id": {
"type": "string",
"maxLength": 20,
"description": "EU VAT id."
},
"company": {
"type": "string",
"maxLength": 80,
"description": "Company name."
},
"country": {
"type": "string",
"pattern": "^[A-Za-z]{2}$",
"description": "2-letter ISO country code (DE, AT, CH ...)."
},
"currency": {
"type": "string",
"pattern": "^[A-Za-z]{3}$",
"description": "3-letter currency code, for example EUR."
},
"last_name": {
"type": "string",
"maxLength": 40,
"description": "Last name."
},
"company_no": {
"type": "integer",
"maximum": 9007199254740991,
"description": "Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1.",
"exclusiveMinimum": 0
},
"department": {
"type": "string",
"maxLength": 40,
"description": "Department."
},
"first_name": {
"type": "string",
"maxLength": 40,
"description": "First name."
},
"salutation": {
"type": "string",
"maxLength": 10,
"description": "Salutation (for example Herr, Frau)."
},
"postal_code": {
"type": "string",
"maxLength": 10,
"description": "Postal code."
},
"payment_terms": {
"type": "integer",
"maximum": 1000,
"minimum": 0,
"description": "Payment terms number (see collmex_list_payment_terms); empty = Collmex default."
}
}
},
"annotations": {
"title": "Create customer",
"readOnlyHint": false,
"openWorldHint": true,
"idempotentHint": false,
"destructiveHint": false
}
}| department | string | Department. |
| first_name | string | First name. |
| salutation | string | Salutation (for example Herr, Frau). |
| no_mailings | boolean | Mark as 'no mailings'. |
| postal_code | string | Postal code. |
{
"name": "collmex_create_address",
"title": "Create address-book entry",
"description": "WRITE: create a NEW entry in the Collmex address book (record CMXADR, address type 3, no address number so Collmex assigns one; existing addresses are never overwritten). Each call creates another entry: check collmex_list_addresses first to avoid duplicates. Nothing is sent to the person. Give at least a company or a last name. Returns the new address number.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"fax": {
"type": "string",
"maxLength": 40,
"description": "Fax."
},
"url": {
"type": "string",
"maxLength": 80,
"description": "Website."
},
"city": {
"type": "string",
"maxLength": 40,
"description": "City."
},
"email": {
"type": "string",
"maxLength": 50,
"description": "E-mail address."
},
"phone": {
"type": "string",
"maxLength": 40,
"description": "Phone."
},
"title": {
"type": "string",
"maxLength": 10,
"description": "Title (for example Dr.)."
},
"remark": {
"type": "string",
"maxLength": 1024,
"description": "Internal remark."
},
"street": {
"type": "string",
"maxLength": 40,
"description": "Street and house number."
},
"company": {
"type": "string",
"maxLength": 80,
"description": "Company name."
},
"country": {
"type": "string",
"pattern": "^[A-Za-z]{2}$",
"description": "2-letter ISO country code (DE, AT, CH ...)."
},
"last_name": {
"type": "string",
"maxLength": 40,
"description": "Last name."
},
"department": {
"type": "string",
"maxLength": 40,
"description": "Department."
},
"first_name": {
"type": "string",
"maxLength": 40,
"description": "First name."
},
"salutation": {
"type": "string",
"maxLength": 10,
"description": "Salutation (for example Herr, Frau)."
},
"no_mailings": {
"type": "boolean",
"description": "Mark as 'no mailings'."
},
"postal_code": {
"type": "string",
"maxLength": 10,
"description": "Postal code."
}
}
},
"annotations": {
"title": "Create address-book entry",
"readOnlyHint": false,
"openWorldHint": true,
"idempotentHint": false,
"destructiveHint": false
}
}