Business Central OData endpoints

Our integration takes place via Business Central's built-in OData web services. For this reason, Lagersystem supports versions from NAV 2013 (7.0) up to the present day, including all versions of Business Central.

Business Central is referred to below, but everything also applies to on-prem Navision.

Access to the web service

Ideally, we would like a user that we can use to view the solution. It helps our support if questions arise about the setup, since we can then see the actual orders, items, etc. in Business Central. This user must have a Web Service Access Key created on the user account page, which must be provided to us. Remember to copy the entire string — it is long.

For some older on-prem installations, Use NTLM Authentication must be enabled, and regular login is used.

For on-prem installations, we recommend that you lock down access to our outgoing IP address yourself in the relevant firewall and setup. All our server communication takes place via the external IP: 185.149.228.1

Some of the standard pages mentioned do not exist in older versions of Navision (e.g. 2007-2015); by contacting your point of contact, we can provide an FOB file with a backport of the pages.

Item integration

If variants are used, the two non-required OData endpoints must be published.

Standard	Required	OData Endpoint Name	PageID	Description
Yes	Yes	workflowItems	6409	Primary endpoint for items
No	No	Vareref	5736	Used for variants and barcodes, if these are set up as a reference
No	No	ItemVariants	5401	Used for variants
No	No	bom	36	Used for bills of materials
No	No	itemUnitOfMeasure	5404	Used to retrieve the units-per-case count for case barcodes

Inventory integration

Standard	Required	OData Endpoint Name	PageID	Description
Yes	Yes	workflowItems	6409	Primary endpoint for stock figures
No	No	InventoryItems	5701	Used if the accounting is enabled with variants (requires that the item inventory listing report is created and kept continuously updated in BC).
No	Yes	itemDraft	40	Used for stock regulations

Order integration

Picking tasks from Business Central can come either directly from a sales order that must be picked in full, i.e. one shipment per sales order — this is often used in B2C e-commerce setups where the shipping price is decisive. Alternatively, picking tasks can come via pick orders (shipments), where several can be created from one sales order — this is recommended for setups where partial deliveries are desired, often B2B.

Standard	Required	OData Endpoint Name	PageID	Description
Yes	Yes	workflowSalesDocuments	6402	Primary endpoint for sales orders
Yes	Yes	workflowSalesDocumentLines	6403	Sales order lines
No	No	inventoryPick	7377	Used for pick orders
No	No	inventoryPickLines	7378	Pick order lines
No	No	PurchaseReturnOrder	6640	Used for purchase return orders
No	No	Transferorder	5740	Used for transfer orders

Goods in integration

Goods in can take place either directly against a purchase order or via a put-away order.

Standard	Required	OData Endpoint Name	PageID	Description
Yes	Yes	purchaseDocuments	–	Primary endpoint for purchase orders
Yes	Yes	workflowPurchaseDocumentLines	–	Purchase order lines
No	No	putAwayHeader	7375	Used for put-away orders
No	No	putAwayLines	7376	Put-away lines