Skip to main content
Sparkrock's Customer Success Center

How to Work with Attributes

Master Records are things in the database like vendors, items, employees, g/l accounts, customers, and fixed assets. The following article explains how to use attributes to track additional data related to certain master files. 

For information on importing attributes, see How to Import Attributes.

Overview

Attributes enable you to track additional data related to certain master files. Attributes are typically physical characteristics that you add to items– for example, color, model year, and so on. Users can quickly search on these attributes.

For a list of supported attributes, access the Attribute Setup list in Microsoft Dynamics NAV.

Viewing and Creating an Attributes

  1. Click Tell Me and search for Attribute Setup. Select the page from the drop-down list.
    The Attribute Setup page displays a list of all attributes, organized by page.
    attribute_setup.png
  2. To view the defined attributes for a particular page, select the page and on the Action Bar click (More Options) > Actions > New Document > Attributes.
    The Edit Attributes Page displays.
    edit_attributes.png
  3. To edit an existing attribute, click Edit on the Action Bar.
    The Edit Attribute Page displays. Modify the attribute as needed.
  4. To add a new attribute, on the click New on the Action Bar
    The New Attribute Page displays. 
    new_Attribute.png
  5. Provide values for the Name and Type fields. Valid types are: text, data, date, option integer, and decimal.
    Note: You can hide item attributes that are no longer in use by adding a checkmark to the Blocked checkbox.
  6. If you are creating attributes of type Option, specify the possible values. Click Attribute Values on the Action Bar.
    attribute_values.png
  7. Click New and in provide the attribute value text in the Value field. Repeat this step for every attribute value that you want to add.
  8. Click the Left Arrow to return to the New Attribute page.

Assigning Attributes

In the following example, attributes are assigned to a particular item, but this example works for all master record types (vendors, items, bank accounts, employees, and so on).

  1. Open the page that you want to assign attributes to. For example, open the Items list. In the Search field, type Items and then select the Item list from the drop-down list.
  2. Select the item that you want to assign attributes to, and then from the Ribbon click Attributes.
    The Attributes Values page displays.
    attribute_values.png
  3. In the Attribute field, choose an attribute that you want to assign to this item from the drop-down list. 
  4. In the Value field, choose an attribute value.
  5. Repeat steps 3 and 4 for each attribute that you want to assign.
  6. Click OK.
    attribute_values.png

Filtering on Attributes

You can filter a Page based on a particular Attribute value. 

To filter based on attributes:

  1. Open the page that you want to filter. For example, the Items page.
    items_list.png
  2. On the Action Bar, click the Show Filter Pane icon.
    The Filter Pane displays.
    item_list_show_filter_pane.png
  3. Under the Filter List By heading, click +Filter.
  4. Specify the attribute that you want to filter the page by and provide an attribute value in the field provided.
  5. Select an item matching the filter criteria in the drop-down list. 
    That item displays.
  • Was this article helpful?