Adding Attributes to an Item and Importing Those Attributes to Multiple Items in Acumatica

by Jun 6, 2024Acumatica, technical how tos, training0 comments

In Acumatica, you can use attributes to capture more data about their products when the system’s out-of-the-box functionality does not capture the desired data. Once captured, a user can sort and filter data in reports and generic inquiries based on attributes to segregate data and perform further analytics on a company’s products.

What is an attribute in Acumatica?

An attribute could be the color of an item, the quantity of components contained within that item, the year of creation for the item, the brand of an item, etc. There are many ways users can use attributes within Acumatica.

For example, let’s say one of our clients sells crayons. They sell boxes of different colored crayons that contain 12 per pack. The blue 12-pack has the item number B12PK and the black 12-pack has the item number BL12PK. However, when creating the item in Acumatica, the person who wrote the description did not specify the color. We know it is not a good idea to leave a description blank, but let’s just say this was what happened.

These are the items as they appear in Acumatica:

Screenshot of items in Acumatica without attributes specified.

At a glance, you can’t tell which item blue and which item is black because of the lack of a semantic naming convention in the Item ID and the absence of color details in the description.

But, if you look at their respective attributes tab, you can see that someone has assigned them a color.

Black crayons with attributes applied
Blue crayons with attributes applied

Having added the attribute values to the item upon creation would have negated any problems that could have occurred related to the neglected description. Again, this is more of an elementary example, but for more expensive items, you can see how this could become a big problem.

This is just one minor example of how attributes can be useful. Setting up an attribute on an item during its creation allows you to drill down into that item and determine its color.

When running reports, you can also filter the report to show calculations for the desired query and get information without having to manipulate your data in Excel.

Creation of an Attribute

To create an attribute, first navigate to the Attributes screen in Acumatica.

Attribute creation screen in Acumatica

Once there:

  1. Name your attribute.
  2. Give it a description.
  3. Determine what kind of control type you’d like to use – If you are unsure what control type you would like to use, click the Help button and navigate to the Form Reference for the Attributes page.

Setting attributes in Acumatica
Acumatica attribute documentation
  • If necessary, add your attribute values.
  • Click Save.

For this example, we are using a Multi-Select Combo box and have added the values Black, Blue, and others.

Assigning an Attribute to an Item Class

For the system to allow the addition of an attribute to an item, the Attribute ID must be specified on the Item Class for that item.

  1. Navigate to the Item Class screen.
  2. Select your Item Class ID in which you’d like to add the newly created attribute.
  3. Click on the Attributes tab.
  4. Once there, left-click in the blank field below the Attribute ID column in the grid and select your newly created Attribute ID. Here, our Attribute ID is COLOR.
  5. Save.

Assigning an attribute to an Acumatica item class

Importing an Attribute on an Item

Sometimes, you may need to assign an attribute value to an item that wasn’t originally given one. Knowing how to do this with an import scenario can save hours or even days, rather than having to assign them manually depending on your dataset.

Once you have your item created and have confirmed that you have done the above steps to assign the Attribute ID to the Item Class, you can then import your attribute value.

For this example, I will switch our two items to be blank so we can confirm that the system assigns the values.

Attributes assigned to an item class in Acumatica
Attributes assigned to an item class in Acumatica

To accomplish this, we can make a very simple Excel file.

Excel file used to import attributes

Creating the Data Provider

  1. Navigate to the Data Providers screen in Acumatica.
  2. Name your Data Provider. We named ours “Import Color Attribute.”
  3. Specify the provider type. Ours is an Excel Provider because we created an Excel file to accomplish the task.
  4. Click Save.

Your screen will look like this:

Setting up the data provider
  • Click “Files” at the top right of the screen.
  • Click Browse on the window that pops up and select the file you just created.
  • Click Upload on the pop-up window.

Your screen will look like this:

Files pop up window
  • Close the “Files” pop-up window.
  • Click the “Schema” tab.
  • In the “Source Objects” grid, click the checkbox under the “Active” column to make your Excel worksheet active.

Making your Excel worksheet the active data provider
  1. In the “Source Objects” grid, click “Fill Schema Objects.”
  2. In the “Source Fields” grid, click “Fill Schema Fields.”
  3. Click Save.

Your screen will look like the image below:

Source objects grid

Creating the Import Scenario

  1. Navigate to the Import Scenario screen.
  2. Click on the “+” to create a new Import Scenario.
  3. Create your Scenario name.
  4. Assign the screen name. For our example, we are adding an attribute value to a stock item, so we will select the Stock Items screen here.
  5. Select your data provider you just created. Ours is “Import Color Attribute.”
  6. Select the Provider Object. Ours is “Sheet1.”
  7. Assign Sync Type to be “Full.”

Your screen will look like the image below:

Setting Sync type
  • I typically click “Save” now, so I have the scenario created and saved.
  • Set up your scenario as shown below:

Note: the lines for fields `<Key: InventoryCD>`, `<Action: Cancel>`, and `<Key: AttributeID>` are system lines that are created automatically when you create the “Inventory ID” and “Attribute -> Attribute ID” fields. Do not create those lines manually.

  • Save your scenario.
Setting up the attribute import scenario

Importing your Scenario

  1. Navigate to the Import by Scenario screen.
  2. Use the magnifying glass next to the name field and select your import scenario you just created.
  3. Click “Prepare.”

Your screen will look like the image below:

Getting ready to import your scenario

Note: If you get an error here, make sure that your Target Object for your attributes is “Attributes -> Attributes,” not “Attributes.” This is very confusing and has caused problems for many clients over the years.

When we go back to our items in Acumatica, we can see that they have successfully been assigned the correct attribute values based on the values we assigned in our Excel file.

Attributes once they are set

Conclusion

Using attributes in Acumatica is a powerful way to enhance your data management and product tracking capabilities. By following the steps outlined above, you can easily enhance your data management and product tracking capabilities by creating, assigning, and importing attributes to capture and access all necessary product details. This not only improves the accuracy of your records but also streamlines reporting and analysis, enabling better business decisions. Whether you’re dealing with a simple product like crayons or more complex inventory, leveraging attributes can significantly optimize your operations and prevent potential issues related to data omission. Start implementing these practices today and see the difference in your Acumatica experience.

Need more help to get started with attributes in Acumatica? Contact us! Do you want more Acumatica tips and tips like this? Visit our blog archive.

You may also enjoy

Acumatica Industry Editions: The ERP Revolution You Didn’t Know You Needed

Acumatica Industry Editions: The ERP Revolution You Didn’t Know You Needed

Acumatica Industry Editions revolutionize ERP by offering tailored solutions that fit your business like a custom suit. Unlike one-size-fits-all systems, Acumatica transforms inefficiencies into profit, streamlining operations and unlocking hidden potential. With industry-specific options for construction, retail, manufacturing, and more, discover how this ERP system propels your business forward with unmatched precision and scalability.

read more
Acumatica Pro Tip: Managing Access Rights by Role

Acumatica Pro Tip: Managing Access Rights by Role

Managing access rights by role in Acumatica allows administrators to easily control user access to different modules and screens. This guide walks you through assigning, modifying, and revoking permissions, ensuring security and compliance. Learn how to efficiently manage user roles and streamline your system with step-by-step instructions tailored to your business needs.

read more
Unlock New Possibilities with Acumatica 2024 R2: What’s New & Why It Matters

Unlock New Possibilities with Acumatica 2024 R2: What’s New & Why It Matters

Acumatica 2024 R2 delivers enhanced automation, advanced analytics, and industry-specific tools to help businesses streamline operations, improve decision-making, and increase efficiency. With upgrades to user experience, reporting, and security, this release empowers companies to work smarter and more strategically. Explore these powerful features and discover how they can transform your business.

read more

Brandon Honeycutt

With more than 5 years of experience as an Acumatica ERP Consultant at Intelligent Technologies, Inc., I have earned 16 Acumatica certification badges. My role involves implementing Acumatica for diverse companies, working with all its modules, and setting up various system integrations. I am passionate about helping clients implement new strategies, streamline processes, and reduce costs. With Acumatica, I am confident we can achieve your business goals together!