--- title: "Get sales invoices filtered and paged" slug: "preview-get-sales-invoices-filtered-and-paged" updated: 2025-11-21T20:01:51Z published: 2026-02-10T12:53:32Z --- > ## 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 Post/api/v1/invoices/salesinvoice/filter Get a paged list of existing sales invoices, optionally filtered to the given parameters. **Description** Retrieve a paged list of existing sales invoices, filtered to the given parameters. **Use Case** The user needs to identify which sales invoices are currently registered in Bloxs. For example, they may want to retrieve only overdue invoices to initiate payment reminders or debt collection procedures. Alternatively, they may wish to display a specific customer’s open invoices in a portal or during support interactions, using the customer ID as a filter. **Request****fields** The request contains the following fields: | Field | Description | | --- | --- | | pageSize | The maximum number of pages to be returned per request. The default number is 100 and the maximum is 1.000. If more results are returned than specified in the PageSize, the remaining pages are dropped based on the reference (number). | | pageNumber | This allows the requesting party to specify which of the pages they want to receive. | | columnName | The data field based on which sorting is applied. For example, if the results are sorted based on ascending name, columnName will contain the value 'name'. | | order | Based on this value, the property defined in 'columnName' is either sorted ascending (a-z) or descending (z-a). | | reference | This pertains to the reference of the specific sales invoice. This reference can be used to obtain further information regarding the invoice through the [GET operation](/v1-api/apidocs/preview-get-a-sales-invoice). | | ownerReference | This pertains to the reference of the owner of the object. | | relationReference | This is the reference of the relation associated with the reminder. It can refer to any relation type within the system and is not necessarily a tenant. For example, it may also refer to an owner who has an outstanding debt with another owner. | | invoiceDate.from | The invoice date. This defines the lower border of the range. | | invoiceDate.to | The invoice date. This defines the upper border of the range. | | paymentTermName | Description of the payment term, for example: "Payment must be made by [date]." | | dueDate.on | Due date of the invoice. This defines the lower border of the range. | | dueDate.to | Due date of the invoice. This defines the upper border of the range. | | totalAmountExcl.from | Total amount excluding VAT. The amount is expressed with two decimals. This defines the lower border of the range. | | totalAmountExcl.to | Total amount excluding VAT. The amount is expressed with two decimals. This defines the upper border of the range. | | totalAmountVAT.from | Total VAT amount. The amount is expressed with two decimals. This defines the lower border of the range. | | totalAmountVAT.to | Total VAT amount. The amount is expressed with two decimals. This defines the upper border of the range. | | totalAmountIncl.from | Total amount including VAT. The amount is expressed with two decimals. This defines the lower border of the range. | | totalAmountIncl.to | Total amount including VAT. The amount is expressed with two decimals. This defines the upper border of the range. | | outstandingAmount.from | Total outstanding amount for this month only. This reflects the amount due specifically within the current month and does not include any outstanding balances from previous months. The amount is expressed with two decimals. This defines the lower border of the range. | | outstandingAmount.to | Total outstanding amount for this month only. This reflects the amount due specifically within the current month and does not include any outstanding balances from previous months. The amount is expressed with two decimals. This defines the upper border of the range. | | totalOutstandingAmountReacalculateDate.from | The date on which the outstanding debt was last updated. This value is generated by Bloxs. This defines the lower border of the range. | | totalOutstandingAmountReacalculateDate.to | The date on which the outstanding debt was last updated. This value is generated by Bloxs. This defines the upper border of the range. | SecurityHTTPType Bearer Please enter a valid token Body parametersExpand Allobject pagingobject (PagingInfo) pageSizeinteger (int32) | null Minimum1Maximum1000 pageNumberinteger (int32) | null Minimum1Maximum9999 sortingobject (SortingInfo) columnNamestring | null orderinteger (int32) Valid values[ 0, 1 ] filterobject (SalesInvoiceSearchRequestFilter) referencestring | null ownerReferencestring | null relationReferencestring | null invoiceDateobject (CompareFilterModelDateTime) fromstring (date-time) | null tostring (date-time) | null paymentTermNamestring | null dueDateobject (CompareFilterModelDateTime) fromstring (date-time) | null tostring (date-time) | null totalAmountExclobject (CompareFilterModelDecimal) fromnumber (double) | null tonumber (double) | null totalAmountVATobject (CompareFilterModelDecimal) fromnumber (double) | null tonumber (double) | null totalAmountInclobject (CompareFilterModelDecimal) fromnumber (double) | null tonumber (double) | null outstandingAmountobject (CompareFilterModelDecimal) fromnumber (double) | null tonumber (double) | null outstandingAmountRecalculateDateobject (CompareFilterModelDateTime) fromstring (date-time) | null tostring (date-time) | null Responses200 OK Expand Allobject pagingobject (PagingInfo) pageSizeinteger (int32) | null Minimum1Maximum1000 pageNumberinteger (int32) | null Minimum1Maximum9999 sortingobject (SortingInfo) columnNamestring | null orderinteger (int32) Valid values[ 0, 1 ] salesInvoices Array of object (SalesInvoiceSearchResultFilter) | null object referencestring | null ownerReferencestring | null relationReferencestring | null invoiceDatestring (date) paymentTermNamestring | null dueDatestring (date) totalAmountExclnumber (double) totalAmountVATnumber (double) totalAmountInclnumber (double) outstandingAmountnumber (double) | null outstandingAmountRecalculateDatestring (date-time) | null