Returns aggregated purchase invoices totals based on the specified advanced filters.
Headers
-
API token (can be retrieved from account settings)
-
ID of organization, for which the operation must be performed
Query parameters
-
Purchase invoice ID filter.
Multi-value supported. Example: value1;value2 -
Supplier contact ID filter.
Multi-value supported. Example: value1;value2 -
Supplier invoice reference filter
-
Currency code filter
-
Net amount filter.Supports 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
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Total amount filter.Supports 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
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Invoice status filter
Values are
UNPAID,OVERDUE,PAID,PARTIALLY_PAID,WIRED, orDRAFT. -
Whether the invoice is validated
-
Whether the invoice has warnings
-
Whether the invoice has comments
-
Whether the invoice is currently part of an active workflow
-
Invoice 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.
- Range (
-
Free-text description filter
-
VAT amount filter.Supports 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
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Chart of accounts (expense category) ID filter.
Multi-value supported. Example: value1;value2 -
Invoice line department ID filter.
Supported values:-1— records where value is not assigned- ID
- Multiple values separated by
;
Examples:
- -1
- 10
- 10;15;20
-
Order ID filter
Multi-value supported. Example: value1;value2 -
Invoice line office ID filter.
Multi-value supported. Example: value1;value2 -
Whether the attribution should be rebilled to the client
-
Whether the attribution has already been rebilled
-
ReBilled 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.
- Range (
-
Article ID filter.
Multi-value supported. Example: value1;value2 -
Quantity filter.Supports 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
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Allocation rule name
-
Paid amount filter.Supports 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
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Bank charges filter.Supports 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
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Payable-by chart of accounts ID filter.
Multi-value supported. Example: value1;value2 -
Payment type filter
Values are
BANK_TRANSFER,BVR, orQR_BILL. -
Payment chart of accounts ID filter.
Multi-value supported. Example: value1;value2 -
VAT type filter
Values are
NO_VAT,NATIVE, orIMPORT_OF_SERVICE. -
Whether documents (attachments) exist for the invoice
-
Requested payment 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.
- Range (
-
Planned payment 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.
- Range (
-
Sent payment 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.
- Range (
-
Payment value 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.
- Range (
-
Payable amount filter.Supports 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
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Show open invoices.
Requires 'openDate' when set to true. -
Open date filter.
Used only when 'showOpenInvoices' is set to true.
curl \
--request GET 'https://wyzio.app/api-v1/purchase-invoice/advanced/total'
{
"id": 42,
"organizationId": 42,
"journalEntryId": 42,
"date": "2026-05-04T09:42:00Z",
"supplier": "string",
"supplierId": 42,
"reference": "string",
"currency": "string",
"netAmount": 42.0,
"totalAmount": 42.0,
"payable": 42.0,
"status": "UNPAID",
"validated": true,
"comment": "string",
"warnings": "string",
"fileId": 42,
"fileExtension": "string",
"hasWarnings": true,
"shipmentsCount": 42,
"creatorContactId": 42,
"workflowPermissions": "string",
"hasComments": true,
"isInWorkflow": true,
"flagsAmount": 42,
"systemValidated": true,
"description": "string",
"vatAmount": 42.0,
"attributionId": 42,
"chartOfAccountsId": 42,
"attributionAccountNumber": 42,
"invoiceLineDepartmentId": 42,
"departmentName": "string",
"orderId": 42,
"orderIdToDisplay": "string",
"invoiceLineOfficeId": 42,
"invoiceLineOfficeName": "string",
"reBill": true,
"reBilled": true,
"reBilledDate": "2026-05-04T09:42:00Z",
"articleId": 42,
"articleIdToDisplay": "string",
"quantity": 42.0,
"ruleName": "string",
"dateFrom": "2026-05-04T09:42:00Z",
"dateTo": "2026-05-04T09:42:00Z",
"attributionNet": 42.0,
"percent": 42.0,
"paymentId": 42,
"requestedDate": "2026-05-04T09:42:00Z",
"plannedDate": "2026-05-04T09:42:00Z",
"sentDate": "2026-05-04T09:42:00Z",
"valueDate": "2026-05-04T09:42:00Z",
"paidAmount": 42.0,
"bankCharges": 42.0,
"payableByAccount": 42,
"payableByAccountNumber": 42,
"paymentType": "BANK_TRANSFER",
"requestedCurrency": "string",
"paidCurrency": "string",
"requestedAmount": 42.0,
"paymentAccountId": 42,
"vatType": "NO_VAT",
"documentsExist": true
}