News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Material Consolidation...

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

Suggested answer

Material Consolidation/Item Attributes

(1) Share

Report

Report

Posted on by Flynn.Fr

63

Hello All,

My company manufactures some products using film rolls as our materials. We purchase rolls of the same film but sometimes in different lengths and widths.. Currently, we have an Item Number in the system for each configuration of the film. Is there a way in Business Central to consolidate these all into a single Item Number while maintaining the ability to track the different lengths/widths? We would want to use the single Item in Production BOMs/Orders & routing.. Item attributes was my initial thought, but when purchasing the material we wouldn't be able to specify which length/width rolls we want to purchase and we would not be able to specify which rolls would be used in Production BOMs.

Any and all feedback is appreciated.

Categories:

Dynamics 365 Business Central

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Material Consolidation/Item Attributes

Hi, just to add some information, Microsoft has announced a new feature in the 2021 release wave 1 plan, Lot Sizes. You can also try this feature.

Define lot sizes for various stages of production

https://learn.microsoft.com/en-us/dynamics365-release-plan/2021wave1/smb/dynamics365-business-central/define-lot-sizes-various-stages-production?wt.mc_id=DX-MVP-5004336

Handling Lot Sizes in Production

https://learn.microsoft.com/en-us/dynamics365/business-central/production-handling-lot-sizes?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU
Suggested answer

gdrenteria 12,338 Most Valuable Professional on at

Like (0)

Report

Material Consolidation/Item Attributes

Hi

As KasparsSemjonovs comments, you could rely on the concept of variants, the support for variants in production orders has been improving, but without being an expert I would say that to further enhance its functionalities, some external applications have appeared that help optimize these processes.

I hope this can help you, a give you some hints.

https://learn.microsoft.com/en-us/dynamics365-release-plan/2021wave1/smb/dynamics365-business-central/variant-code-added-production-order-header-plus-limited-support-production-boms-routes-stockkeeping-units

https://docs.cosmoconsult.com/en-us/business-central/advanced-manufacturing-pack/PM/production-structures/production-variants.html

https://www.im-projects.com/how-to-improve-size-and-color-management-in-ms-business-central-with-im-sizecolor/

https://appsource.microsoft.com/it-it/product/dynamics-365-business-central/pubid.it_integro%7Caid.bc_apc_001%7Cpappid.bc229fbe-9c00-11ed-a8fc-0242ac120002?tab=overview

Best Regards

Gerardo
Suggested answer

KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (0)

Report

Material Consolidation/Item Attributes

Item Variants could be an option, but when producing, you would still need to provide the item and variants for components or finished product.

Otherwise You can look adding a dimension - if those sizes/versions of fipms are more or less repetitive You can add a dimension valie on each transaction - and this way when manufacturing You would need to provide just the item no, and the dimension that will be assigned to the finished product.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans