Inventory endpoints

Items, categories, attributes, locations and units of measure, plus the item ledger and value entries behind inventory quantities and costing.

All URLs on this page are relative to the company URL, https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environment}/api/datawareness/endpoints/v1.0/companies({companyId})/. See Construction of the URL.

Master data

Endpoint	Description	Business key	Source table	Tier
genProductPostingGroups	General product posting group definitions.	code	Gen. Product Posting Group	Premium
inventoryPostingGroups	Inventory posting group definitions.	code	Inventory Posting Group	Premium
itemAttributes	Item attribute definitions (color, size, etc.).	id	Item Attribute	Premium
itemAttributeValueMappings	Assignment of item attribute values to items.	tableId&&no&&itemAttributeId&&itemAttributeValueId	Item Attribute Value Mapping	Premium
itemAttributeValues	Allowed values for each item attribute.	attributeId&&id	Item Attribute Value	Premium
itemCategories	Item category definitions.	code	Item Category	Premium
itemDimensions	Default dimensions assigned to items.	itemNo&&dimensionCode	Default Dimension	Premium
items	Item master data.	no	Item	Free
locations	Location master data.	code	Location	Premium
unitsOfMeasure	Unit of measure definitions.	code	Unit of Measure	Premium

Transactional data

Endpoint	Description	Business key	Source table	Tier
itemApplicationEntries	Item application entries for cost tracking.	entryNo	Item Application Entry	Premium
itemLedgerEntries	Item ledger entries.	entryNo	Item Ledger Entry	Premium
valueEntries	Value entries for inventory costing.	entryNo	Value Entry	Premium

Example queries

Item movements for a month

GET .../itemLedgerEntries?$filter=postingDate ge 2026-01-01 and postingDate lt 2026-02-01
  &$select=entryNo,itemNo,postingDate,entryType,documentNo,locationCode,quantity

Stock on hand by item and location

GET .../itemLedgerEntries?$filter=open eq true
  &$select=itemNo,locationCode,remainingQuantity

Sum remainingQuantity per itemNo and locationCode.

Inventory cost

GET .../valueEntries?$filter=postingDate le 2026-12-31
  &$select=entryNo,itemNo,postingDate,itemLedgerEntryType,costAmountActual,costPostedToGL

Tips

• Free tier: items is available without a Premium subscription.
• Attributes: itemAttributeValueMappings links items to itemAttributeValues, which belong to itemAttributes.
• Fields: every endpoint's fields, with types, are listed by properties — see Metadata discovery. The same list is on the endpoint's page under BI Endpoints in Business Central.