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:

Business Central

All responses (4)

Answers (0)

Suggested answer

Kenneth Q Madsen 21 on at

Like (1)

Report

Add the manufacturer field to 'ITEMS'

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
Suggested answer

Ben Baxter 4,915 Super User 2024 Season 2 on at

Like (1)

Report

Add the manufacturer field to 'ITEMS'

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
Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (1)

Report

Add the manufacturer field to 'ITEMS'

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
Suggested answer

Valentin Castravet 24,793 Super User 2024 Season 2 on at

Like (3)

Report

Add the manufacturer field to 'ITEMS'

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

Add the manufacturer field to 'ITEMS'

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Leaderboard

Featured topics

Product updates

Add the manufacturer field to 'ITEMS'

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Subscribe to

Leaderboard

Featured topics

Product updates