Skip to main content
Solved

BOM / routing setup advice

  • November 4, 2024
  • 8 replies
  • 130 views

Forum|alt.badge.img

In our business we have thousands of finished goods that we sell. However, a large number of them have the same manufacturing method e.g. all straight lengths follow the same process, all elbows follow the same process etc. the only change is the material that is used i.e. larger sheet blanks for larger finished goods. We can create 1 x BOM for each item, but that makes future potential modifications laborious e.g. if we change a manufacturing process by using a different machine, we’d have to change hundreds of affected BOMs. Before we create thousands of BOMS unnecessarily, are there any best methods of practice that fellow Acumatica users are adopting that could help in this scenario?

Thanks,

Best answer by josborn02

With the product configurator you can select a material for each item and you won’t have to create a BOM for everything. 

Alternatively, you could upload multiple BOMs at once using an Import Scenario.

View original
Did this topic help you find an answer to your question?

8 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • 817 replies
  • November 4, 2024

I would recommend you evaluate using the Acumatic Product Configurator.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 18 replies
  • November 4, 2024
angierowley75 wrote:

I would recommend you evaluate using the Acumatic Product Configurator.

Thanks Angie. We haven’t looked into the Configurator yet, and as these items are standard and resold regularly, we wouldn’t want to configure them each time...unless my understanding of how the Configurator works is incorrect (it probably is!)?


josborn02
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 50 replies
  • Answer
  • November 4, 2024

With the product configurator you can select a material for each item and you won’t have to create a BOM for everything. 

Alternatively, you could upload multiple BOMs at once using an Import Scenario.


Forum|alt.badge.img+1
  • 24 replies
  • November 4, 2024

When you say Machine, do you mean the Work Center on the Bill of Materials? It sounds like you want to “Mass Change” a specific Work Center on a list of BOMs. Currently Mass Change only works for Materials so that would not work here. There is also “Substitute Work Centers” but that would not solve your problem either unless the new Machine/Work Center is in a different Warehouse.

I haven’t worked with Configurator in Acumatica yet but my understanding is that you would have 1 Item that can be configured X number of ways. This would then drive a Production Order’s BOM Source. 

 

I agree with @josborn02 regarding the Import Scenario. This is probably the easiest way to manage it.


AndreasKleinfeld72
Varsity III
Forum|alt.badge.img+1

@RobLowe Please check the idea BOM Relation Item Class.

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 18 replies
  • November 5, 2024
josborn02 wrote:

With the product configurator you can select a material for each item and you won’t have to create a BOM for everything. 

Alternatively, you could upload multiple BOMs at once using an Import Scenario.

Thanks josborn02. We have used import scenarios to create our BOMs and that has worked well. The scenario I’m trying to foresee is how to keep future changes to BOMs manageable. If the routing for 100 finished goods is identical and only materials are different, is there a way to create 1 x common routing and apply it to all relevant finished goods? An idea I’ve got would be to create a subassembly (only containing operations) which can be used in all the finished goods with the same routing, then a separate operation which captures just the materials (which would be different per finished good). This way if a production process changed, by changing the subassembly, all relevant BOMs would be updated - I think?! Otherwise if a work center was changed (new machine bought etc.) I imagine you would have to go into each BOM and make the required change? Or as suggested, is using import scenarios the better solution?


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 18 replies
  • November 5, 2024
AndreasKleinfeld72 wrote:

@RobLowe Please check the idea BOM Relation Item Class.

 

That’s what I was thinking Andreas, thanks.


Forum|alt.badge.img+1
  • 24 replies
  • November 5, 2024
RobLowe wrote:
josborn02 wrote:

With the product configurator you can select a material for each item and you won’t have to create a BOM for everything. 

Alternatively, you could upload multiple BOMs at once using an Import Scenario.

Thanks josborn02. We have used import scenarios to create our BOMs and that has worked well. The scenario I’m trying to foresee is how to keep future changes to BOMs manageable. If the routing for 100 finished goods is identical and only materials are different, is there a way to create 1 x common routing and apply it to all relevant finished goods? An idea I’ve got would be to create a subassembly (only containing operations) which can be used in all the finished goods with the same routing, then a separate operation which captures just the materials (which would be different per finished good). This way if a production process changed, by changing the subassembly, all relevant BOMs would be updated - I think?! Otherwise if a work center was changed (new machine bought etc.) I imagine you would have to go into each BOM and make the required change? Or as suggested, is using import scenarios the better solution?

 

@RobLowe I would probably still lean towards an Import Scenario but I am pretty sure what you just described can be accomplished using a Phantom part on the BOM. The subassembly as you called it would contain the “Master Routing”, this would be your Phantom item. When you add this Item to the BOM you would mark it with a Material Type of Phantom and set Phantom Routing to “Before”. 

  • Before (default): Operations of the phantom subassembly are included in a production order before the parent operation.

You could then modify that Phantom Item’s BOM/Master Routing and it would apply to all the other BOMs where it has been added. I still think this will require a bit of work to configure and an Import Scenario is recommended.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings