Item Attributes in Business Central

Item Attributes in Business Central

I’ve never talked about this feature of Business Central (and NAV 2017) that I find interesting and that can be useful. It can be used to store and manage some information related to articles in a simple way; it is not a product configurator but can be useful and can be enhanced with some small customizations.

Some Benefits

  • You can add additional details to items (ex: E-commerce attributes)
  • You can define many types of attributes fields
  • You can manage also multi language for attributes
  • You can block an old attribute and values (like in Dimensions)
  • In addition, you can use attributes in Sales Orders… or where you need, with a little and simple customizations.

Item Attributes – Tables

#1 – Let’s now look at some functional examples:

  • Open Item Attributes

  • Define a new attribute (ex: SIZE Attribute, Type=OPTION)

Note: If you select Option in the Type field, then you can choose the Item Attribute Values action to create values for the item attribute.

  • Define ATTRIBUTE VALUES and TRANSLATIONS

  • We can assign Item Attributes Values

Ex: Dimensions (Values) for “Size” Item Attribute

  • We can also define a “translation” for each value

At “the end”…. we can find the “New Item Attribute” SIZE ready to use in Attribute List Page.

Item Attributes, where I can find them on Item Card?

In Items List Page and in Item Card Page you can open “Attributes” to select attributes and assign values for them.

Ex: Attributes from Item Card

NOTE:

  • Blocked Attributes and blocked Attribute Values are hidden in the dropdown list.

Filtering by Attributes

You can filter objects by Attributes Ex: Filtering on Item List Page

#2 – Attributes for Item Categories

We can also define attributes for the “Item Categories” will be applied to the item while creating new Items.

Note: By Default, Item attributes for parent categories will be inherited to child categories, you can change\override them as you want.

#3 – Item Attributes utilization example: Item Attributes on Sales Order (from Advanced View)

Selecting items in a Sales Order Line, you can apply the Item Attributes filter using “Advanced View”

Item Attributes (on Microsoft Docs)

https://docs.microsoft.com/en-us/dynamics-nav-app/inventory-how-work-item-attributes

5 thoughts on “Item Attributes in Business Central

    • Author gravatarAuthor gravatar

      Hello, this is a nice feature, but is it possible to report on item Attributes in Power BI? Are the item attributes populated in the datasets available from Business Central in Power BI?

      • Author gravatarAuthor gravatar

        hi, not possible to date.

        Workaround
        you can create a new Query on AL based on table “Attribute Value Mapping” and publish as Web Services.

        A query like this:
        query 50121 “Item Attribute Value Mapping”
        {
        //version v.1.0 RS
        elements
        {
        dataitem(Item;Item)
        {
        column(No_;”No.”)
        {
        }
        column(Description;Description)
        {
        }
        dataitem(Item_Attribute_Value_Mapping;”Item Attribute Value Mapping”)
        {
        DataItemLink = “No.”= Item.”No.”;
        column(Table_ID; “Table ID”)
        {
        }
        column(No;”No.”)
        {
        }
        column(Item_Attribute_ID;”Item Attribute ID”)
        {
        }
        column(Item_Attribute_Value_ID;”Item Attribute Value ID”)
        {
        }
        dataitem(QueryElement6;”Item Attribute”)
        {
        DataItemLink = ID=Item_Attribute_Value_Mapping.”Item Attribute ID”;
        column(Name;Name)
        {
        }
        column(Type;Type)
        {
        }
        column(Unit_of_Measure;”Unit of Measure”)
        {
        }
        dataitem(QueryElement10;”Item Attribute Value”)
        {
        DataItemLink = “Attribute ID”=Item_Attribute_Value_Mapping.”Item Attribute ID”,
        ID=Item_Attribute_Value_Mapping.”Item Attribute Value ID”;
        column(Value;Value)
        {
        }
        column(Numeric_Value;”Numeric Value”)
        {
        }
        column(Date_Value;”Date Value”)
        {
        }
        column(Blocked;Blocked)
        {
        }
        }
        }
        }
        }
        }
        }

      • Author gravatarAuthor gravatar

        Yes, it’s possible.

        You just need to make a relation between tables

        27 – 7505 – 7501

        Between 27 and 7505 you need to use Item ID field.

        Between 7505 and 7501 you will need and aux column, linkin together “Attribute ID” + any character or number + “ID”.

        Hope it helps!

    • Author gravatarAuthor gravatar

      Buona sera, vorrei sapere se era possibile estendere gli attributi non solo agli articoli ma anche ai clienti e fornitori.
      Se si è una modifica complicata?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: