Small and medium business | Business Central, N...

Add the manufacturer field to 'ITEMS'

(0) Share

Report

Posted on by Community member

I'm trying to add a field within Items to show the manuafacturer of a product, which I can then filter by in future. Any ideas?

e.g. If it was an iPhone, where could I record that it was 'Apple' other than the description?

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 31,628 Super User 2025 Season 2 on at

Like (3)

Report
Copy link

Link copied!

The Item Attributes functionality would be perfect for that: Set Up Item Attributes and Assign Them to Items - Business Central | Microsoft Learn

Valentin Castravet

Zander ERP Services

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,232 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, or use Dimensions.

In addition, there is a hidden No. 2 or Description 2 field in the Item table. You can also use this field to manage the manufacturer.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,671 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Since you can have a 1: Many relationship between Item: Manufacturers, it is better to make it a Flow field showing the count of the number of Manufacturers (similar to "Stockkeeping Unit Exists" field on Planning tab). This doesn't allow you to look at the Item list to see the Manufacturers, but there are other ways to accomplish the same goal. Instead, go to what you know, i.e. the Manufacturer. Open the table with the Item/Manufacturer relationship defined and filter by the Manufacturer. Now you have a list of all Items from a specific Manufacturer.

If your Items only have a single Manufacturer, then I would agree with adding it to the Item Attributes so you can quickly filter to the Manufacturer attribute.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Suggested answer

Kenneth Q Madsen 27 on at

Like (1)

Report
Copy link

Link copied!

I agree with the suggested solution of manufacturer as an Item attribute.

I just wanted to add a single downfall of this. When you save pages with a filter on attribute, the count is done on item numbers, meaning it is not dynamic like normal saved pages. Should you ever need it. This might not be important to you, but it's worth remembering if it's something you will be filtering on often.

Dimensions could also be an option. This would have the added benefit that you could do fiscal reports on the cost/sales of items with dimension = Apple, and start doing analysis on this.
- Also doable using attributes in Power BI, but with dimensions you have the tools directly in BC.
It would have the added benefit of being able to do a saved page for all your apple products also.

Both are fine options in my opinion.

/Kenneth Q. Madsen

Was this reply helpful? Yes No