We are currently trying to change the scrap percentage of a component which exists in thousands of parts, and it looks like the Mass Change function in Bills Of Materials work space is limited to only replace one part for another. I was hoping there would be something that we could make a change to any field that exists in the BOM for a component and be able to reload to Acumatica.
Is there a way to mass change/update data in BOM's without having to replace an item.
Best answer by MichaelShirk
Here is the export scenario I use to export BOMs and the Import Scenario I use to Update BOMs.
Note that this Import scenario is set up to either Add, Delete, or Modify material lines. When preparing to run the import It’s important to make sure the appropriate lines are set as “Active” to accomplish the task at hand.
Obviously if you need to set it up on a schedule, you would probably want to create separate Import scenarios for each operation. However, since I’m always manually triggering it, it’s easier to have one Import scenario that can do various update operations just by changing the active lines on the scenario.
These scenarios are working in the 2023R2 Acumatica release.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.