Skip to main content

Notifications

Announcements

No record found.

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

Guidance on best method for production orders

(1) ShareShare
ReportReport
Posted on by 10
Hello All
I am new to Business Central and hoping that you will be willing to help me with what I think is a relatively complex scenario by advising a good way to deal with it. I have come into a business where unfortunately there is very little knowledge of the existing Business Central system so would appreciate any guidance or assistance.
 
Sales Order 1:
90 x Manufactured Product A
Of these 90 Products 20 have an Upgrade X only
Of these 90 products 20 have an Upgrade Y only
Of these 90 products 10 have an upgrade of X and Y
 
90 x Product A have a unique serial number
Product A has a BOM
Upgrade X has its own BOM (sub assembly)
Upgrade Y has its own BOM (sub assembly)
 
Sales Order 2:
20 x Manufactured Product B
Of these 20 Products 10 have an upgrade Z
 
20 x Product B have a unique serial number
Upgrade Z has its own BOM (sub assembly)
 
Production Orders / Capacity / Batch
I can only manufacture 25 x Product A or B per week (5 per day)
I want to split my orders into production batches of 25, bearing in mind that this would cover 2 x sales orders.
ie. 1 order might need several production orders OR several orders might need a single production order!
 
Purchasing / Stock / MRP
We operate a Just in Time production facility and I want to order via MRP once per week, ie. once for each batch.
 
Other complication (low priority issue)
in an ideal scenario I would like to be able to "allocate" the Upgrade X, Y or Z to the appropriate serial no. for the product to which they relate.
 
Could anyone suggest how I might be able to do this?
Feel free to ask for any more information if necessary.
 
Thanks in anticipation.
 
Neil
  • Ben Baxter Profile Picture
    Ben Baxter 4,997 Super User 2024 Season 2 on at
    Guidance on best method for production orders
    You will likely need to use Item Variants.  You could do it with individual Item No. per Product + Upgrade, but then your Item list is messy.  By using Variants and Stockkeeping Units (SKUs), you can define the specific BOM per build.
     
    For your batch production, set a Max. Order Quantity per SKU on the Planning Tab, with the Reordering Policy set to Lot-for-Lot.  This will make what is needed based on demand, and if demand exceeds 25 it will break it into multiple Production Orders.
     
    For your MRP, if you want it to order the material specific to the Prod. Order set your Reordering Policy on the raw material to Order.  If you want it to group the demand, set the Reordering Policy to Lot-for-Lot.  Both policies allow for Lean/Just in Time style inventory.
     
    It sounds like your Upgrades are Serialized parts (upgraded motor or features to a main product).  This means they would be sub-assemblies and can have their own serial number.  Linking the sub-component serial to the finished serial no. is available in AppSource extensions or via a custom table populated during Output recording.
     
    So most of this is available out of the box, with the exception being the tracking of which serialized component is in which serialized finished good.  I would encourage you to reach out to your partner to ensure you get the system setup correctly from the beginning to avoid headaches down the road.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans