Skip to content

BC Item Operations ​

Creates, retrieves, updates, or deletes items in Microsoft Business Central.

Purpose ​

Use this task to manage Business Central item records as part of an automated workflow. It supports the full lifecycle of an item — from initial creation with required fields like type and unit of measure, through retrieving item data and attributes, updating individual fields, and deleting items when they are no longer needed. This task works well in combination with the BC Get Lookups task, which can supply valid codes for fields such as Base Unit Of Measure and Tax Group Code.

Inputs ​

FieldTypeRequiredDescription
CompanyTextYesThe name or ID of the Business Central company to operate against.
OperationDropdownYesThe item operation to perform: Create Item, Get Item, Get Item Attributes, Update Item, or Delete Item.
Item NoTextNoThe item number of the Business Central item. For Create Item this is optional — leave blank to let Business Central auto-assign a number. Required for Get Item, Get Item Attributes, Update Item, and Delete Item.
Display NameTextNoThe display name for the new item. Required for Create Item.
TypeDropdownNoThe item type: Inventory, Service, or Non-Inventory. Required for Create Item. Inventory items are stocked and valued; Service and Non-Inventory items are not.
Base Unit Of MeasureTextNoThe base unit of measure code (e.g. PCS, EA, KG). Required for Create Item. Use BC Get Lookups with Lookup Type set to Units of Measure to find valid codes.
Item Category CodeTextNoOptional item category code. Use BC Get Lookups with Lookup Type set to Item Categories to find valid codes. Only used when Operation is Create Item.
Inventory Posting GroupTextNoInventory posting group code. Use BC Get Lookups with Lookup Type set to Inventory Posting Groups to find valid codes. Only used when Operation is Create Item.
General Product Posting GroupTextNoGeneral product posting group code. Use BC Get Lookups with Lookup Type set to General Product Posting Groups to find valid codes. Only used when Operation is Create Item.
Tax Group CodeTextNoTax group code. Set this explicitly to avoid Business Central injecting an incorrect default from an item template. Use BC Get Lookups with Lookup Type set to Tax Groups to find valid codes. Only used when Operation is Create Item.
Fields to UpdateObject ListNoA list of field-value pairs specifying which item fields to update and their new values. Only used when Operation is Update Item.

Visibility Rules ​

Item No is only shown when Operation is set to Create Item, Get Item, Update Item, or Delete Item.

Display Name is only shown when Operation is set to Create Item.

Type is only shown when Operation is set to Create Item.

Base Unit Of Measure is only shown when Operation is set to Create Item.

Item Category Code is only shown when Operation is set to Create Item.

Inventory Posting Group is only shown when Operation is set to Create Item.

General Product Posting Group is only shown when Operation is set to Create Item.

Tax Group Code is only shown when Operation is set to Create Item.

Fields to Update is only shown when Operation is set to Update Item.

Operations ​

OperationDescription
Create ItemCreates a new item record in Business Central. Display Name, Type, and Base Unit Of Measure are required.
Get ItemRetrieves the full item record for the specified item number.
Get Item AttributesRetrieves the attribute values associated with the specified item.
Update ItemUpdates one or more fields on an existing item using the Fields to Update list.
Delete ItemPermanently deletes the item with the specified item number.

Outputs ​

NameDescription
ItemThe Business Central item record returned after a Create Item, Get Item, or Update Item operation. Downstream tasks can use this to read any item field.
Item AttributesThe list of attribute entries for the item. Available when Operation is Get Item Attributes.

Tentech