Skip to main content

Notifications

Announcements

No record found.

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

Material Consolidation/Item Attributes

(1) ShareShare
ReportReport
Posted on by 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.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    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
    Handling Lot Sizes in Production
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 12,338 Most Valuable Professional on at
    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. 
     
    Best Regards
    Gerardo
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,962 Super User 2024 Season 2 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans