New features in Dynamics Nav: Item Attributes

Published: October 12, 2017 (Updated: October 16, 2017)

When working as a NAV end user, I lost count of how many times our company wanted to add attributes to items, but did not have the available field or space to add it to the description field. One of the great new features in Dynamics Nav 2017 is unlimited Item Attributes that can be defined by the customer or user.

The main benefits of using Item Attributes are:

  • Unlimited number of attributes per item
  • You can set own item attributes, examples could be length, width, diameter, colour, manufactured by,  etc.
  • Filter the item list using the item attributes.

Setting up new item attributes is relatively quick and easy too.

  1. Setup item attributes
  2. Allocate the attributes to an item category code
  3. Set the item category against individual SKU’s / items.

1. Setting up item attributes

Type Item Attributes into the search box:

Screenshot

Click New to create your new attribute:

Screenshot

Give your new item attribute a name. I have used Length in the example shown below:

Screenshot

When creating a new item attribute, you can choose from one of the following types:

  • Option - predefined list of values. Continuing to use Length as an example, we could set the values as Long and Short.
  • Text – You can type free text when selecting this attribute type.
  • Integer – This is a whole number
  • Decimal – We can use this for non-integer numbers.

If we select the type decimal another field will appear where we can populate the unit of measure. For this example I have used millimetres (mm):

Screenshot

You can also block Item Attributes if required.

2. Allocate item attributes to item categories

Type Item Categories into the search box.

Screenshot

Click New to create a new Item Category. I have created a parent called STEEL BAR and two children called HOLLOW and SOLID.

Let’s look at the parent first and how to allocate the attributes.

You can see I have created an item category code and description. Then in the item category lines I have selected Length, Outer Diameter, Steel Type and Thread Type:

Screenshot

Now let’s look at one of the item category children.

I have created an item category code and description. But in the parent category field I have selected the category STEEL BAR. This has then auto populated the item category card line with the attributes from the parent. These are shown in bold and you can see where the attributes are inherited from.

We can add further attributes such as the Internal Diameter. This would not be required on the solid bar item category.

Screenshot

3. Set the item category against individual SKU’s / items

Type Item in the search box. Create a new item and select the Item Category as shown below:

Screenshot

Then click on the attributes button and populate the values:

Screenshot

These attributes will also be displayed in the fact box as shown below:

Screenshot

Setting up item attributes is quick and easy, and display the specifications that make up your products.

Good luck!

Latest Posts

Using Microsoft Dynamics 365 Business Central with Outlook to streamline the way you work

Using Microsoft Dynamics 365 Business Central with Outlook to streamline the way you work

Microsoft Dynamics 365 Business Central is embedded in Office 365, whi...read more


Utilise Business Central’s Web Client for efficient remote working

Utilise Business Central’s Web Client for efficient remote working

During the Covid-19 outbreak businesses across the world have been wor...read more


Why ERP is crucial to efficient manufacturing

Why ERP is crucial to efficient manufacturing

Whether your manufacturing business is small or large scale there are ...read more


Why Microsoft Office 365 is the saviour for businesses working from home

Why Microsoft Office 365 is the saviour for businesses working from home

As a nation we are in an unprecedented situation, with many people hav...read more


Are you ready for the Making Tax Digital change in April 2020?

Are you ready for the Making Tax Digital change in April 2020?

If you are a business owner undoubtedly you will know about the Govern...read more