Even geduld a.u.b...

Exact Online REST API - ItemWarehouses

Endpoint

ItemWarehouses

Good to know

Use this endpoint to :
 • Create a link between an item and a warehouse.
 • Retrieve an existing linked item warehouse record.
 • Update item information such as MaximumStock, ReorderPoint, SafetyStock, and more in a warehouse.
 • Delete the link between an item and a warehouse.
This endpoint gives an insight on the current stock levels and look ahead to the projected stock level with planned movements of stock.

An item can be linked to a warehouse to keep inventory organised. An item can be linked to multiple warehouses. Storage locations can also be specified if the warehouse supports storage locations.
For more information about the items by warehouses functionality in Exact Online, see Overview: Items by warehouses.


This endpoint is available for the following packages:

Scope

Logistics inventory

URI

/api/v1/{division}/inventory/ItemWarehouses


GET POST PUT DELETE

Example usage

/api/v1/{division}/inventory/ItemWarehouses

/api/v1/{division}/inventory/ItemWarehouses

/api/v1/{division}/inventory/ItemWarehouses

/api/v1/{division}/inventory/ItemWarehouses


Properties

Name Mandatory Value Value Type Description
ID False Edm.Guid A guid that is the unique identifier of the linkage between item and warehouse
CountingCycle False Edm.Int16 Indicates the number of days for next cycle count.
Created False Edm.DateTime Creation date
Creator False Edm.Guid User ID of creator
CreatorFullName False Edm.String Name of creator
CurrentStock False Edm.Double Quantity that is currently in stock, included the stock committed to sales order
DefaultStorageLocation False Edm.Guid This is a default storage location
DefaultStorageLocationCode False Edm.String Default storage location's code
DefaultStorageLocationDescription False Edm.String Default storage location's description
Division False Edm.Int32 Division code
Item True Edm.Guid Item ID
ItemBarcode False Edm.String Barcode of item
ItemCode False Edm.String Code of item
ItemDescription False Edm.String Description of item
ItemEndDate False Edm.DateTime Together with ItemStartDate this determines if the item is active
ItemIsFractionAllowedItem False Edm.Boolean Indicates if fractions (for example 0.35) are allowed for quantities of this item
ItemIsStockItem False Edm.Boolean Indicates if this is a stock item
ItemStartDate False Edm.DateTime Together with ItemEndDate this determines if the item is active
ItemUnit False Edm.String The standard unit code of this item
ItemUnitDescription False Edm.String Description of item's unit
MaximumStock False Edm.Double Maximum quantity of items that you want in warehouse
Modified False Edm.DateTime Last modified date
Modifier False Edm.Guid User ID of modifier
ModifierFullName False Edm.String Name of modifier
NextCountingCycle False Edm.DateTime Indicates the date for next cycle count
OrderPolicy False Edm.Int16 Order Policy options: 1-Lot for lot, 2-Fixed order quantity, 3-Min / Max, 4-Order
Period False Edm.Int16 Period that work together with replenishment in MRP
PlannedStockIn False Edm.Double The quantity still open to be received based on i.e. purchase orders and assembly orders.
PlannedStockOut False Edm.Double The quantity still open to be delivered based on i.e. sales orders and assembly orders.
PlanningDetailsUrl False Edm.String URL of the stock planning details of this record
ProjectedStock False Edm.Double The quantity of stock projected given all planned future stock changes
ReorderPoint False Edm.Double Quantity of items as an indication of when you need to reorder more stock for the warehouse
ReorderQuantity False Edm.Double Reorder quantity that work together with replenishment in MRP
ReplenishmentType False Edm.Int16 Replenishment options: 1-Purchase, 2-Assemble, 3-Make, 4-Transfer, 5-No replenishment advice
ReservedStock False Edm.Double The quantity in a back to back order process which is already received from the purchase order, but not yet delivered for the sales order.
SafetyStock False Edm.Double Minimum quantity of items you must have in stock
StorageLocationUrl False Edm.String URL pointing to details of which storage locations this ItemWarehouse's stock is located
Warehouse True Edm.Guid Warehouse ID
WarehouseCode False Edm.String Code of warehouse
WarehouseDescription False Edm.String Description of warehouse

Returns