Even geduld a.u.b...

Exact Online REST API - SalesOrderLines

Endpoint

SalesOrderLines

Good to know

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

Sales order lines support trade-in lines. For more details, please refer description under properties Quantity

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

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


This endpoint is available for the following packages:


This entity supports webhooks.
Subscribe to the topic SalesOrders to get updates on the SalesOrderLines resource. You will also receive events on the SalesOrderLines 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 orders

URI

/api/v1/{division}/salesorder/SalesOrderLines


GET POST PUT DELETE

Example usage

/api/v1/{division}/salesorder/SalesOrderLines

/api/v1/{division}/salesorder/SalesOrderLines

/api/v1/{division}/salesorder/SalesOrderLines

/api/v1/{division}/salesorder/SalesOrderLines

/api/v1/{division}/salesorder/SalesOrderLines


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
AmountFC False Edm.Double Supports webhook Amount in the currency of the transaction
CostCenter False Edm.String Supports webhook Mandatory filter Reference to Cost center
CostCenterDescription False Edm.String Description of CostCenter
CostPriceFC False Edm.Double Item cost price
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
CustomField False Edm.String Custom field endpoint. Provided only for the Exact Online Premium users.
DeliveryDate False Edm.DateTime Supports webhook Mandatory filter Delivery date of this line
DeliveryStatus False Edm.Int16 Mandatory filter Shipping status of the sales order line. 12=Open, 20=Partial, 21=Complete, 45=Cancelled
Description False Edm.String Supports webhook Mandatory filter Description
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
InvoiceStatus False Edm.Int16 Mandatory filter Invoice status of the sales order line. 12=Open, 20=Partial, 21=Complete, 45=Cancelled
Item True Edm.Guid Supports webhook Mandatory filter Reference to the item that is sold in this sales order line
ItemCode False Edm.String Code of Item
ItemDescription False Edm.String Description of Item
ItemVersion False Edm.Guid Supports webhook Mandatory filter Item Version
ItemVersionDescription False Edm.String Description of Item Version
LineNumber False Edm.Int32 Mandatory filter Line number
Margin False Edm.Double Supports webhook Sales margin of the sales order line
NetPrice False Edm.Double Supports webhook Net price of the sales order line
Notes False Edm.String Supports webhook Extra notes
OrderID True Edm.Guid Mandatory filter The OrderID identifies the sales order. All the lines of a sales order have the same OrderID
OrderNumber False Edm.Int32 Mandatory filter Number of sales order
OrderStatus False Edm.Int16 Mandatory filter The status of the sales order line. 12=Open, 20=Partial, 21=Complete, 45=Cancelled
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 order 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
PurchaseOrder False Edm.Guid Supports webhook Purchase order that is linked to the sales order
PurchaseOrderLine False Edm.Guid Supports webhook Purchase order line of the purchase order that is linked to the sales order
PurchaseOrderLineNumber False Edm.Int32 Number of the purchase order line
PurchaseOrderNumber False Edm.Int32 Number of the purchase order
Quantity False Edm.Double Supports webhook The number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor.
Positive quantity = Sales order lines, Negative quantity = Trade-in lines.
QuantityDelivered False Edm.Double Supports webhook The number of items delivered
QuantityInvoiced False Edm.Double Supports webhook The number of items invoiced
ShopOrder False Edm.Guid Supports webhook Mandatory filter Reference to ShopOrder
TaxSchedule False Edm.Guid Obsolete
TaxScheduleCode False Edm.String Obsolete
TaxScheduleDescription False Edm.String Obsolete
UnitCode False Edm.String Supports webhook Code of item unit
UnitDescription False Edm.String Description of Unit
UnitPrice False Edm.Double Supports webhook Price per unit in the currency of the transaction
UseDropShipment False Edm.Byte Supports webhook Mandatory filter Indicates if drop shipment is used (delivery directly to customer, invoice to wholesaler)
VATAmount False Edm.Double Supports webhook VAT amount in the currency of the transaction
VATCode False Edm.String Supports webhook Mandatory filter VAT code
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 sales order is created. It's also used for the default calculation of VAT amounts and VAT base amounts

Returns