Item Categories and Item Attributes in Business Central: What You Need to Know

In modern inventory/product management, being able to classify and enrich your items with meaningful metadata is critical. Dynamics 365 Business Central gives you two key tools to do that: Item Categories and Item Attributes. Categories give your items structure through hierarchies, while attributes add flexible details like color, size, or material. Together, they improve search, reporting, and setup efficiency — but they also come with limitations like governance needs, reporting gaps, and migration challenges.

---

Introduction: Why Item Classification Matters

Every manufacturer or distributor eventually faces the same pain: a growing item list that’s hard to search, filter, and report on. When data gets messy, operations slow down — sales can’t find products, purchasing makes errors, and finance struggles with reporting.

Microsoft Dynamics 365 Business Central tackles this with item categories and item attributes. These two tools give you structure (categories) and flexibility (attributes). They’re also Microsoft’s official replacement for the older Product Group feature, which has been deprecated.

Let’s dive into what categories and attributes in Business Central are, what happened to Product Group, and how to use these tools to their full potential — including the benefits, the limitations, and best practices from real-world implementations.

---

What Happened to Product Group?

If you’ve worked with Dynamics NAV or older versions of Business Central, you’ll remember Product Group. It was a way to classify items into buckets for reporting and filtering.

But here’s the catch:

• Microsoft marked Product Group as obsolete. In fact, Table 5723 – Product Group and related fields are gone in recent versions.
• Why? Because Product Group was too limited. It couldn’t support the flexible classification, searching, and reporting that modern businesses need.
• The replacement: Item Categories (hierarchical grouping) and Item Attributes (detailed properties).

Takeaway: If your system still uses Product Group, it’s time to migrate. Everything you did with Product Group can — and should — now be handled with categories and attributes.

---

Item Categories Explained

Item Categories are the backbone of classification in Business Central.

• Hierarchy: You can build parent-child structures (e.g., Furniture → Office Furniture → Desks).
• Category-specific defaults: You can assign attributes, costing methods, and posting setups to categories. Items in that category inherit or default those settings.
• Navigation: Categories make it easier for users to browse, search, and report on logical groups of items.

Example:

Imagine you’re a manufacturer of kitchen products:

• Parent Category: Kitchenware
• Child Categories: Cookware, Cutlery, Bakeware
• Item: Stainless Steel Frying Pan → belongs to Cookware

When a new Cookware item is created, it inherits attributes like “Material = Stainless Steel” and “Category = Kitchenware.”

---

Item Attributes Explained

Attributes are metadata tags that describe specific properties of an item.

• Attribute Types: Option (dropdown list), Text, Decimal, Integer, Boolean (Yes/No).
• Flexibility: Add as many attributes as you need — Color, Size, Brand, Material, Voltage, Allergens.
• Category Inheritance: Define attributes at the category level, then assign values on each item.

Example:

That same Stainless Steel Frying Pan might have attributes:

• Color: Silver
• Diameter: 10 inches
• Material: Stainless Steel
• Oven Safe: Yes

Attributes make it easy to filter: “Show me all stainless steel cookware larger than 8 inches.”

---

Benefits of Categories and Attributes

Here’s why item categories and attributes in Business Central matter so much:

1. Organized Data
   Categories give structure, attributes give detail. Together, they prevent item chaos.
2. Faster Item Setup
   Assign attributes at the category level, and new items inherit them automatically.
3. Better Search & Filtering
   Sales reps can find items faster: “All red shirts in size medium.”
4. Improved Reporting
   Use attributes to filter reports and BI dashboards. NOTE: see limitations below
5. Customer-Facing Value
   Attributes can power e-commerce filters or dealer portals (color, size, brand).
6. Future-Proofing
   Categories and attributes are Microsoft’s long-term strategy. Product Group is gone — categories and attributes are here to stay.

---

Real-World Story: Migrating from Product Group

One of our clients, a specialty coatings manufacturer, relied heavily on Product Groups in NAV. They had groups like Resins, Pigments, Additives. Reports, pricing, and even some posting logic depended on these groups.

During their Business Central upgrade:

• We mapped each Product Group to an Item Category (Resins → Raw Materials → Chemicals).
• Attributes were added for properties like Viscosity, VOC Content, and Packaging Size.
• Old reports were rebuilt using category filters and attribute values.

The result?

• Sales could now filter by “Low VOC Resins” instantly.
• Purchasing had cleaner visibility into chemical families.
• Finance no longer depended on a deprecated table.

The key lesson: Migration takes planning, but categories and attributes unlock far more value than Product Group ever did.

---

Limitations and Challenges of Item Categories and Attributes

While item categories and attributes in Business Central add much-needed structure and flexibility, they’re not a silver bullet. In fact, one of the most common frustrations we hear from clients is that filtering and reporting with attributes doesn’t go as far as they expect. Here’s what you need to know:

1. Filtering is Limited to the Item List (and Lookups)

• You can filter by attributes when you’re on the Item List or when doing an item lookup (like adding lines on a Sales Order or Purchase Order).
• Example: a customer asks for a “blue medium jacket.” You can open the Item lookup on the sales line, filter by Color = Blue and Size = Medium, and pick the right item.
• But: once the item is on the Sales Order line, the attributes don’t display there and can’t be filtered further.

Reality check: Attributes are great for helping users find the right item during setup or order entry — but they don’t carry through to transaction lines.

---

2. Attributes Do Not Flow Into Posted Documents

• When you post a Sales Order or Purchase Order, the attribute values are not carried into the posted invoice, shipment, or receipt.
• That means you cannot filter or report on posted sales by attributes without customization or external reporting tools.

If you need to analyze sales by color, size, or material, attributes alone won’t cut it — you’ll need to extend BC or push data into Power BI.

---

3. Attributes Are Not Dimensions

• This is a frequent misconception. While both are descriptive tags, they tag different things. Attributes tag items while dimensions tag transactions. There’s far more capabilities for reporting with dimensions.
• You can’t run a trial balance, P&L, or inventory valuation report by attribute. That’s what dimensions are for.

Attributes may look like dimensions on the surface, but they are fundamentally different tools.

---

4. Reporting Capabilities Are Weak

• You can filter item reports by attributes, but the options are narrow.
• Complex queries (e.g., “All red jackets larger than medium sold in Q2”) usually require Power BI, custom queries, or extensions.
• Attributes also don’t handle OR logic well out of the box (e.g., Red OR Blue jackets).
• You’ll find limitations in trying to use these with the Analyze feature as well.

---

5. Maintenance & Governance Still Matter

• Even with the above limitations, messy attribute data only makes things worse.
• Free-text attributes lead to chaos (red, Red, crimson).
• Too many attributes overwhelm users and slow down lookups.

---

The Bottom Line

Attributes are powerful for item setup and discovery — they make finding the right product faster and more accurate. But they are not designed for deep reporting or transaction-level filtering. Many companies expecting “attributes to act like dimensions” end up disappointed.

If you need consistent financial or sales reporting by product characteristics, dimensions or a custom solution will still be required. Attributes should be seen as a front-end usability tool, not a complete reporting solution. Hopefully, this is an area Microsoft will expand on in the future.

---

Step-by-Step: Setting Up Categories and Attributes

Here’s how to set them up in Business Central:

1. Define Your Category Structure
   • Go to Item Categories.
   • Create parent categories (e.g., Furniture).
   • Add child categories (e.g., Desks, Chairs).
2. Assign Attributes to Categories
   • Go to Item Attributes.
   • Define attributes like Color, Size, Material.
   • Assign them to categories.
3. Create Attribute Values
   • For “Color,” add Red, Blue, Green.
   • For “Size,” add Small, Medium, Large.
4. Create an Item
   • Assign it to a category.
   • Inherit attributes.
   • Fill in values (e.g., Color = Red, Size = Medium).
5. Test Filtering
   • Go to the item list.
   • Filter by attributes.
   • Verify results.

---

Best Practices

• Keep it simple: Start with a small set of attributes and categories. Expand gradually.
• Use option attributes: Prevent spelling errors and inconsistency.
• Govern your data: Assign an “attribute owner” in your organization.
• Review annually: Retire unused attributes, merge duplicates.
• Train your team: Don’t assume users understand categories and attributes — explain why they matter.

---

FAQs About Categories and Attributes

Q: Are item attributes the same as dimensions?
A: No. Attributes describe item properties. Dimensions are used for financial and management reporting.

Q: Can attributes drive posting setups?
A: Not directly. Categories can influence posting groups, but attributes are more about filtering and reporting.

Q: Can attributes be mandatory?
A: Out of the box, no. This would be a great addition.

Q: How do categories and attributes affect integrations (e.g., e-commerce)?
A: Many e-commerce platforms map to attributes for product filters. This makes attributes especially valuable in B2B/B2C scenarios.

---

Conclusion: Categories and Attributes Are the Future

Item categories and item attributes in Business Central aren’t just replacements for Product Group — they’re a leap forward. They give you structure, flexibility, and richer data for search, filtering, and reporting.

But they require design and governance. Start small, enforce consistency, and train your users. If you’re still on Product Group, the time to migrate is now.

When done right, categories and attributes can transform how you manage your items — giving your team clarity, speed, and confidence in your data.

Please subscribe to see more info like this on Dynamics Power Play