Get advanced general ledger totals

Add MCP server to your AI tool

Allow AI tools and LLMs to interact with the API documentation portal through MCP.

MCP server URL

https://restapi.wyzio.com/mcp

Standard setup for AI tools providing an mcp.json file

mcp.json
{
  "Wyzio MCP server": {
    "url": "https://restapi.wyzio.com/mcp"
  }
}

Close
GET /api-v1/ledger/advanced/total

Returns aggregated total values for advanced general ledger entries based on the specified filters.

Headers

  • WEAL-TOKEN Required

    API token (can be retrieved from account settings)

  • TARGET-ORGANIZATION-ID

    ID of organization, for which the operation must be performed

Query parameters

  • entryDate string(date)

    Entry date filter.Supports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • 01/01/2026..31/12/2026
    • >=01/01/2026
    • <=01/01/2026
    • <>01/01/2026

    Use <>01/01/2026 to return only records where the selected date is not equal to the filter date.

    Internally split into a start/end date range and pushed down to the underlying report function.

  • account string

    Account name filter

  • description string

    Entry description filter

  • hasWarnings boolean

    Whether the entry has warnings

  • foreignCurrencyCode string

    Foreign currency code filter

  • foreignTotal string

    Foreign total (debit + credit) filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • companyTotal string

    Company currency total (debit + credit) filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • departmentName string

    Department name filter

  • contactName string

    Contact name filter

  • articleName string

    Article name filter

  • orderName string

    Order name filter

  • vatCodeNames string

    VAT code name filter

  • departmentIds string

    Department ID filter.

    Supported values:

    • -1 — records where value is not assigned
    • ID
    • Multiple values separated by ;

    Examples:

    • -1
    • 10
    • 10;15;20
  • articleCategoryIds string

    Article category ID filter.

    Supported values:

    • -1 — records where value is not assigned
    • ID
    • Multiple values separated by ;

    Examples:

    • -1
    • 10
    • 10;15;20
  • articleIds string

    Article ID filter.

    Supported values:

    • -1 — records where value is not assigned
    • ID
    • Multiple values separated by ;

    Examples:

    • -1
    • 10
    • 10;15;20
  • contactIds string

    Contact ID filter.

    Supported values:

    • -1 — records where value is not assigned
    • ID
    • Multiple values separated by ;

    Examples:

    • -1
    • 10
    • 10;15;20
  • orderIds string

    Order ID filter.

    Supported values:

    • -1 — records where value is not assigned
    • ID
    • Multiple values separated by ;

    Examples:

    • -1
    • 10
    • 10;15;20
  • officeIds string

    Office ID filter.

    Supported values:

    • -1 — records where value is not assigned
    • ID
    • Multiple values separated by ;

    Examples:

    • -1
    • 10
    • 10;15;20
  • purchaseInvoiceNumber integer(int64)

    Purchase invoice number filter.

  • purchaseInvoiceJournalEntryType string

    Purchase invoice journal entry type filter.

    Values are EMISSION, PAYMENT, or ACCRUAL.

  • salesInvoiceNumber string

    Sales invoice number filter.

  • salesInvoiceJournalEntryType string

    Sales invoice journal entry type filter.

    Values are EMISSION, PAYMENT, or ACCRUAL.

Responses

  • 200 application/json

    OK

    Hide response attributes Show response attributes object
    • id integer(int64)
    • organizationId integer(int64)
    • entryId integer(int64)
    • entryDate string(date-time)
    • sortOrder integer(int32)
    • entryType string

      Values are OPENING, MANUAL, PURCHASE_INVOICE, SALES_INVOICE, SALARY_SLIP, STOCK, CLOSING, SYSTEM, SYSTEM_FX, SYSTEM_PFUV, or FIXED_ASSET.

    • accountId integer(int64)
    • foreignCurrencyCode string
    • foreignDebit number
    • foreignCredit number
    • foreignTotal number
    • companyDebit number
    • companyCredit number
    • companyTotal number
    • account object
      Hide account attributes Show account attributes object
      • en string
      • fr string
      • de string
      • it string
    • description string
    • warnings string
    • hasWarnings boolean
    • tenantId integer(int64)
  • 400

    400 Bad Request

  • 401

    401 Unauthorized

  • 403

    403 Access Denied

  • 404

    404 Not Found

  • 500

    500 Internal Server Error

GET /api-v1/ledger/advanced/total
curl \
 --request GET 'https://wyzio.app/api-v1/ledger/advanced/total'
Response examples (200)
{
  "id": 42,
  "organizationId": 42,
  "entryId": 42,
  "entryDate": "2026-05-04T09:42:00Z",
  "sortOrder": 42,
  "entryType": "OPENING",
  "accountId": 42,
  "foreignCurrencyCode": "string",
  "foreignDebit": 42.0,
  "foreignCredit": 42.0,
  "foreignTotal": 42.0,
  "companyDebit": 42.0,
  "companyCredit": 42.0,
  "companyTotal": 42.0,
  "account": {
    "en": "string",
    "fr": "string",
    "de": "string",
    "it": "string"
  },
  "description": "string",
  "warnings": "string",
  "hasWarnings": true,
  "tenantId": 42
}