29 September 2023

6 thoughts on “Item Attributes in Business Central

  1. 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?

    1. 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)
      {
      }
      }
      }
      }
      }
      }
      }

    2. 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!

  2. 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?

    1. Si è possibile farlo, qualche partner l’ha già fatto, non è molto oneroso da implementare.
      Microsoft per ora non lo implementa, è pero presente nelle “Ideas” e quindi penso che lo faranno.

  3. Is it possible to add a checkbox field to select multiple items attributes? For example I want to select the color white and black.

    Currently, Item Attribute functionality in BC doesn’t support multi select. Is this possible? I’ve created page extension for page 7510 but its not working.

Comments are closed.