The release of Dynamics NAV 2017 presents several important features, which proves how advanced this release is. One of these important features is the item attributes which are highly essential features especially for companies with high variations of SKUs such as but not limited to distribution, retail and manufacturing companies.
Item attributes are completely different that item variants, you may refer to the previous post on Dynamics NAV essentials for a better understanding of the item variants on this link.Item attributes are more of characteristics of the same SKU while an item variant is a variation that can be tracked under an item SKU.
Item Variants versus Item Attributes | Example:
Lets suppose that a distribution company has an item which has three specific colors (red, blue and white). There are two different scenario that can be considered:
1- Creating one item card, with three different variants (red, blue and white) | for that the system will support quantity tracking for all variants across all locations. Although, the system will have one item code under which there are three variations.
2- Creating three different item cards, and creating one attribute called (Color). The first item will be assigned to the item attribute value (red), while the second will be assigned to the second item attribute value (blue) and the third one will be assigned to the item attribute value (white). Although, there will be three separate item codes in the inventory module.
Understanding Item Attributes
In Dynamics NAV 2017, item attributes can be assigned either to single items or to item categories. Although, it is definitely better to assign attributes to the categories in order to make sure that they are inherited by items when assigned to categories.
When creating a new item attribute, you can choose from one of the following types:
- Option (predefined list)
- Text
- Integer
- Decimal
Note: Both decimal and integer can be assigned to a predefined unit of measurement.
Now the next step is to assign a specific set of attributes for either an item category or to an item card. As shown below, the item category (Table) is assigned to a set of attributes which are (Color, Depth, Height and Material Description), it means that once an item is added to the system and assigned to the item category (Table), it will automatically inherit all these attributes.
It is worth to mention finally that item attributes could have default values either on the item category level or item card level.
The next post will shed a light on the technical aspects of item attributes, SQL tables and import insights.
Best Regards,
Mahmoud M. AlSaadi
Hi Mahmoud,
THis post is really useful, but I am struggling a little with the complexity of the import routines as I have 25 item attributes to populate for 3000+ products.
Did you ever publish the next post with regards to imports you mention at the end of this post.
Thanks
Alex
LikeLike
Hello Alex,
Hope you are doing well
In fact, importing the item attributes is kind of a tricky process, there are basically three tables involved and you got to consider the table relations when importing the item attributes through the Rapid Start Services module in NAV.
The post on the technical aspects has been postponed, although, it will be published very soon.
Best Regards,
Mahmoud M. AlSaadi
LikeLike
I see at the end of this post in your blog you indicate that on the next post you’ll talk more about the technical aspect of Item Attributes. Did you do a follow up? I am looking to do a SQL script to create a item list to pull the Item attributes to the Item. This item has these attributes. We have two Attributes: One is level one (Groupings) and a level two which is the order with in the grouping. So we have items that are families like TriTip Steak and then we have sub items: We cut 5 oz, 7 oz and 9 oz steak from a cut of beef and then we have fall off (trip) and / or odd size steak(s), and fat. all are item numbers but a family (group. The 5, 7, & 9 oz steaks are the TriTip Steak group and are all level 1, the others trim, and odd size steak fall off are level 2 and fat is level 3.
When I saw that a possible follow up to attributes more technical and possibly SQL then I’d ask this question.
Again thanks for all you do
LikeLike