> ## Documentation Index > Fetch the complete documentation index at: https://www.bloxs.io/llms.txt > Use this file to discover all available pages before exploring further. # Get sales invoices filtered and paged > Get a paged list of existing sales invoices, optionally filtered to the given parameters. ## OpenAPI ````json POST /api/v1/invoices/salesinvoice/filter { "openapi": "3.0.4", "info": { "title": "Invoices V1", "description": "Welcome to BETA version of the new Invoices API - intended for client public testing before the launch of the final version. During this BETA phase, we'll be improving the API based on specific client's feedbacks.", "version": "v1" }, "security": [ {} ], "tags": [ { "name": "Budgets" }, { "name": "Compactions" }, { "name": "ConceptPurchaseInvoices" }, { "name": "JournalPosts" }, { "name": "Journals" }, { "name": "LedgerAccounts" }, { "name": "Metadata" }, { "name": "PaymentReminders" }, { "name": "PurchaseInvoices" }, { "name": "PurchaseOrders" }, { "name": "SalesInvoices" }, { "name": "SalesInvoiceServices" } ], "paths": { "/api/v1/invoices/salesinvoice/filter": { "post": { "tags": [ "SalesInvoices" ], "summary": "Get sales invoices filtered and paged", "description": "Get a paged list of existing sales invoices, optionally filtered to the given parameters.", "operationId": "GetSalesInvoicesFilteredPaged", "requestBody": { "content": { "application/json": { "schema": { "$ref": "#/components/schemas/SalesInvoiceSearchRequest" } } } }, "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/SalesInvoiceSearchResult" } } } } }, "x-d360-narrative-url": "

Get Sales Invoices Filtered and Paged (POST)

Retrieves a paged, optionally filtered list of existing sales invoices.

A developer calls this endpoint to search for sales invoices matching one or more criteria (for example by owner, relation, invoice date, or outstanding amount), or to retrieve the full set of sales invoices in manageable pages when no filter is needed.

Request Fields

Field

Type

Required

Description

paging.pageSize

integer, 1 to 1000, nullable

Optional

The number of sales invoices to return per page. Defaults to 100 when not given.

paging.pageNumber

integer, 1 to 9999, nullable

Optional

The page number to retrieve. Defaults to 1 when not given.

sorting.columnName

string, nullable

Optional

The name of the field to sort the results by.

sorting.order

integer (enum), nullable

Optional

The sort direction. Allowed values: 0 = Ascending, 1 = Descending.

filter.reference

string, nullable

Optional

Filters on the sales invoice's internal identifier (Reference/Code).

filter.ownerReference

string, nullable

Optional

Filters on the owner whose financial administration the invoice belongs to.

filter.relationReference

string, nullable

Optional

Filters on the relation this invoice was sent to.

filter.invoiceDate.from

string (date-time), nullable

Optional

Inclusive lower bound for filtering on invoice date, formatted as ISO 8601. If omitted, there is no lower bound.

filter.invoiceDate.to

string (date-time), nullable

Optional

Inclusive upper bound for filtering on invoice date, formatted as ISO 8601. If omitted, there is no upper bound.

filter.paymentTermName

string, nullable

Optional

Filters on the payment term applied to the invoice.

filter.dueDate.from

string (date-time), nullable

Optional

Inclusive lower bound for filtering on due date, formatted as ISO 8601. If omitted, there is no lower bound.

filter.dueDate.to

string (date-time), nullable

Optional

Inclusive upper bound for filtering on due date, formatted as ISO 8601. If omitted, there is no upper bound.

filter.totalAmountExcl.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the total amount excluding VAT. If omitted, there is no lower bound.

filter.totalAmountExcl.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the total amount excluding VAT. If omitted, there is no upper bound.

filter.totalAmountVAT.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the total VAT amount. If omitted, there is no lower bound.

filter.totalAmountVAT.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the total VAT amount. If omitted, there is no upper bound.

filter.totalAmountIncl.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the total amount including VAT. If omitted, there is no lower bound.

filter.totalAmountIncl.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the total amount including VAT. If omitted, there is no upper bound.

filter.outstandingAmount.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the outstanding (unpaid) amount. If omitted, there is no lower bound.

filter.outstandingAmount.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the outstanding (unpaid) amount. If omitted, there is no upper bound.

filter.outstandingAmountRecalculateDate.from

string (date-time), nullable

Optional

Inclusive lower bound for filtering on when the outstanding amount was last recalculated, formatted as ISO 8601. If omitted, there is no lower bound.

filter.outstandingAmountRecalculateDate.to

string (date-time), nullable

Optional

Inclusive upper bound for filtering on when the outstanding amount was last recalculated, formatted as ISO 8601. If omitted, there is no upper bound.

filter.salesContractReference

string, nullable

Optional

Filters on the sales contract the invoice is linked to, if applicable.

filter.serviceReference

string, nullable

Optional

Filters on the sales invoice service the invoice originated from, if applicable.

Response Fields

Field

Type

Required

Description

paging.pageSize

integer, 1 to 1000, nullable

Optional

The page size used to produce this result set.

paging.pageNumber

integer, 1 to 9999, nullable

Optional

The page number returned in this result set.

sorting.columnName

string, nullable

Optional

The field the results are sorted by.

sorting.order

integer (enum), nullable

Optional

The sort direction applied. Allowed values: 0 = Ascending, 1 = Descending.

salesInvoices

array of objects, nullable

Optional

The list of sales invoices matching the filter for this page. See sub-fields below.

salesInvoices.reference

string, nullable

Optional

The internal identifier (Reference/Code) of the sales invoice.

salesInvoices.ownerReference

string, nullable

Optional

The internal identifier of the owner whose financial administration this invoice belongs to.

salesInvoices.relationReference

string, nullable

Optional

The internal identifier of the relation this invoice was sent to.

salesInvoices.invoiceDate

string (date)

Optional

The date on the invoice, formatted as ISO 8601 (YYYY-MM-DD).

salesInvoices.paymentTermName

string, nullable

Optional

The payment term applied to this invoice.

salesInvoices.dueDate

string (date)

Optional

The date by which the invoice is due for payment, formatted as ISO 8601 (YYYY-MM-DD).

salesInvoices.totalAmountExcl

number (double)

Optional

The total invoice amount excluding VAT, in the administration's base currency (major units).

salesInvoices.totalAmountVAT

number (double)

Optional

The total VAT amount on the invoice, in the administration's base currency (major units).

salesInvoices.totalAmountIncl

number (double)

Optional

The total invoice amount including VAT, in the administration's base currency (major units).

salesInvoices.outstandingAmount

number (double), nullable

Optional

The amount still outstanding (unpaid) on this invoice, in the administration's base currency (major units).

salesInvoices.outstandingAmountRecalculateDate

string (date-time), nullable

Optional

The date and time outstandingAmount was last recalculated, formatted as ISO 8601.

salesInvoices.salesContractReference

string, nullable

Optional

The internal identifier of the sales contract this invoice is linked to, if applicable.

salesInvoices.serviceReference

string, nullable

Optional

The internal identifier of the sales invoice service this invoice originated from, if applicable.

" } } }, "components": { "schemas": { "SalesInvoiceSearchRequest": { "type": "object", "properties": { "paging": { "$ref": "#/components/schemas/PagingInfo" }, "sorting": { "$ref": "#/components/schemas/SortingInfo" }, "filter": { "$ref": "#/components/schemas/SalesInvoiceSearchRequestFilter" } }, "additionalProperties": false }, "SalesInvoiceSearchResult": { "type": "object", "properties": { "paging": { "$ref": "#/components/schemas/PagingInfo" }, "sorting": { "$ref": "#/components/schemas/SortingInfo" }, "salesInvoices": { "type": "array", "items": { "$ref": "#/components/schemas/SalesInvoiceSearchResultFilter" }, "nullable": true } }, "additionalProperties": false }, "PagingInfo": { "type": "object", "properties": { "pageSize": { "maximum": 1000, "minimum": 1, "type": "integer", "format": "int32", "nullable": true }, "pageNumber": { "maximum": 9999, "minimum": 1, "type": "integer", "format": "int32", "nullable": true } }, "additionalProperties": false }, "SortingInfo": { "type": "object", "properties": { "columnName": { "type": "string", "nullable": true }, "order": { "type": "integer", "description": "Ascending = 0\nDescending = 1", "format": "int32", "x-enumNames": [ "Ascending", "Descending" ] } }, "additionalProperties": false }, "SalesInvoiceSearchRequestFilter": { "type": "object", "properties": { "reference": { "type": "string", "nullable": true }, "ownerReference": { "type": "string", "nullable": true }, "relationReference": { "type": "string", "nullable": true }, "invoiceDate": { "$ref": "#/components/schemas/CompareFilterModelDateTime" }, "paymentTermName": { "type": "string", "nullable": true }, "dueDate": { "$ref": "#/components/schemas/CompareFilterModelDateTime" }, "totalAmountExcl": { "$ref": "#/components/schemas/CompareFilterModelDecimal" }, "totalAmountVAT": { "$ref": "#/components/schemas/CompareFilterModelDecimal" }, "totalAmountIncl": { "$ref": "#/components/schemas/CompareFilterModelDecimal" }, "outstandingAmount": { "$ref": "#/components/schemas/CompareFilterModelDecimal" }, "outstandingAmountRecalculateDate": { "$ref": "#/components/schemas/CompareFilterModelDateTime" }, "salesContractReference": { "type": "string", "nullable": true }, "serviceReference": { "type": "string", "nullable": true } }, "additionalProperties": false }, "SalesInvoiceSearchResultFilter": { "type": "object", "properties": { "reference": { "type": "string", "nullable": true }, "ownerReference": { "type": "string", "nullable": true }, "relationReference": { "type": "string", "nullable": true }, "invoiceDate": { "type": "string", "format": "date" }, "paymentTermName": { "type": "string", "nullable": true }, "dueDate": { "type": "string", "format": "date" }, "totalAmountExcl": { "type": "number", "format": "double" }, "totalAmountVAT": { "type": "number", "format": "double" }, "totalAmountIncl": { "type": "number", "format": "double" }, "outstandingAmount": { "type": "number", "format": "double", "nullable": true }, "outstandingAmountRecalculateDate": { "type": "string", "format": "date-time", "nullable": true }, "salesContractReference": { "type": "string", "nullable": true }, "serviceReference": { "type": "string", "nullable": true } }, "additionalProperties": false }, "CompareFilterModelDateTime": { "type": "object", "properties": { "from": { "type": "string", "format": "date-time", "nullable": true }, "to": { "type": "string", "format": "date-time", "nullable": true } }, "additionalProperties": false }, "CompareFilterModelDecimal": { "type": "object", "properties": { "from": { "type": "number", "format": "double", "nullable": true }, "to": { "type": "number", "format": "double", "nullable": true } }, "additionalProperties": false } } } } ````