Even geduld a.u.b...

Exact Online REST API - SalesInvoiceLines

Endpoint

SalesInvoiceLines

Good to know

Use this endpoint to create, read, update and delete sales invoice lines.

Sales invoice describe the items that you sell to your customers.
For more information about the sales invoice functionality in Exact Online, see About sales invoices.

To view an example of the business use of this endpoint, see Rest API - Business example API sales invoice.


This endpoint is available for the following packages:


This entity supports webhooks.
Subscribe to the topic SalesInvoices to get updates on the SalesInvoiceLines resource. You will also receive events on the SalesInvoiceLines resource.


This API allows to filter only on specific fields. Below you can see per field if it can be filtered on or not.
When you filter on a key field, there are two syntaxes possible which are both supported. In the example usage section you can see the two syntaxes which are supported.

Scope

Sales invoices

URI

/api/v1/{division}/salesinvoice/SalesInvoiceLines


GET POST PUT DELETE

Example usage

/api/v1/{division}/salesinvoice/SalesInvoiceLines

/api/v1/{division}/salesinvoice/SalesInvoiceLines

/api/v1/{division}/salesinvoice/SalesInvoiceLines

/api/v1/{division}/salesinvoice/SalesInvoiceLines

/api/v1/{division}/salesinvoice/SalesInvoiceLines


Properties

Name Mandatory Value Value Type Webhook Filter Description
ID False Edm.Guid Mandatory filter Primary key
AmountDC False Edm.Double Supports webhook Amount in the default currency of the company. For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC
AmountFC False Edm.Double Supports webhook For normal lines it's the amount excluding VAT
CostCenter False Edm.String Supports webhook Mandatory filter Reference to Cost center
CostCenterDescription False Edm.String Description of CostCenter
CostUnit False Edm.String Supports webhook Mandatory filter Reference to Cost unit
CostUnitDescription False Edm.String Description of CostUnit
CustomerItemCode False Edm.String Code the customer uses for this item
DeliveryDate False Edm.DateTime Supports webhook Delivery date of an item in a sales invoice. This is used for VAT on prepayments, only if sales order is not used in the license.
Description False Edm.String Supports webhook Mandatory filter Description. Can be different for header and lines
Discount False Edm.Double Supports webhook Discount given on the default price. Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item
Division False Edm.Int32 Division code
Employee False Edm.Guid Supports webhook Mandatory filter Link to Employee originating from time and cost transactions
EmployeeFullName False Edm.String Name of employee
EndTime False Edm.DateTime Supports webhook EndTime is used to store the last date of a period. EndTime is used in combination with StartTime
ExtraDutyAmountFC False Edm.Double Supports webhook Extra duty amount in the currency of the transaction. Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated.
ExtraDutyPercentage False Edm.Double Supports webhook Extra duty percentage
GLAccount True Edm.Guid Supports webhook Mandatory filter The GL Account of the sales invoice line. This field is mandatory. This field is generated based on the revenue account of the item (or the related item group). G/L Account is also used to determine whether the costcenter / costunit is mandatory
GLAccountDescription False Edm.String Description of GLAccount
InvoiceID True Edm.Guid Mandatory filter The InvoiceID identifies the sales invoice. All the lines of a sales invoice have the same InvoiceID
Item True Edm.Guid Supports webhook Mandatory filter Reference to the item that is sold in this sales invoice line
ItemCode False Edm.String Item code
ItemDescription False Edm.String Description of Item
LineNumber False Edm.Int32 Mandatory filter Indicates the sequence of the lines within one invoice
NetPrice False Edm.Double Supports webhook Net price of the sales invoice line
Notes False Edm.String Supports webhook Extra notes
Pricelist False Edm.Guid Supports webhook Mandatory filter Price list
PricelistDescription False Edm.String Description of Pricelist
Project False Edm.Guid Supports webhook Mandatory filter The project to which the sales transaction line is linked. The project can be different per line. Sometimes also the project in the header is filled although this is not really used
ProjectDescription False Edm.String Description of Project
ProjectWBS False Edm.Guid WBS linked to the sales invoice
ProjectWBSDescription False Edm.String Description of WBS
Quantity False Edm.Double Supports webhook The number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor
SalesOrder False Edm.Guid Mandatory filter Identifies the sales order this invoice line is based on
SalesOrderLine False Edm.Guid Mandatory filter Identifies the sales order line this sales invoice line is based on
SalesOrderLineNumber False Edm.Int32 Then line number of the sales order line on which this invoice line is based on
SalesOrderNumber False Edm.Int32 The order number of the sales order on which this invoice line is based on
StartTime False Edm.DateTime Supports webhook StartTime is used to store the first date of a period. StartTime is used in combination with EndTime
Subscription False Edm.Guid Mandatory filter When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines
SubscriptionDescription False Edm.String Description of subscription line
TaxSchedule False Edm.Guid Mandatory filter Obsolete
TaxScheduleCode False Edm.String Obsolete
TaxScheduleDescription False Edm.String Obsolete
UnitCode False Edm.String Supports webhook Code of Unit
UnitDescription False Edm.String Description of Unit
UnitPrice False Edm.Double Supports webhook Price per unit
VATAmountDC False Edm.Double Supports webhook VAT amount in the default currency of the company
VATAmountFC False Edm.Double Supports webhook VAT amount in the currency of the transaction
VATCode False Edm.String Supports webhook Mandatory filter The VAT code that is used when the invoice is registered
VATCodeDescription False Edm.String Description of VATCode
VATPercentage False Edm.Double Supports webhook The vat percentage of the VAT code. This is the percentage at the moment the invoice is created. It's also used for the default calculation of VAT amounts and VAT base amounts

Returns