Dynamics Community Forum Thread Details

Guidance on best method for production orders

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

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

Quick Links

Leaderboard