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

Microsoft Business Central gives you truly dynamic financials

Microsoft Business Central gives you truly dynamic financials

Imagine if with one touch you could synchronise your financials with y...read more


Is ERP more cost effective than multiple software applications?

Is ERP more cost effective than multiple software applications?

Is it more cost effective to use multiple software applications to man...read more


GDPR: How new regulations will affect your organisation from May 2018

GDPR: How new regulations will affect your organisation from May 2018

In just a few weeks’ time, the General Data Protection Regulatio...read more


ERP: business-wide management software to move your business forward in 2018

ERP: business-wide management software to move your business forward in 2018

Many of us are likely to have heard the term ERP before – but wh...read more


Dynamics NAV 2018 has arrived – and it’s packed with new features

Dynamics NAV 2018 has arrived – and it’s packed with new features

Dynamics NAV 2018 features many updates, improvements and enhancements...read more