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

All responses (4)

Answers (0)

Suggested answer

Kenneth Q Madsen 27 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,997 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 75,595 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,995 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

Quick Links

Congratulations 2024 Spotlight Honorees!

Meet the Top 10 leaders for December!

Get Started Blogging in the Community

Leaderboard

Featured topics

Product updates

Add the manufacturer field to 'ITEMS'

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Meet the Top 10 leaders for December!

Get Started Blogging in the Community

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates