Hey everyone,
I know we can use the Mass Change function to swap one item for another across multiple BOMs. Is it possible to use function to just remove an item without swapping out another one.
Best answer by MichaelShirk
View original
Userlevel 2
It’s not possible to do this with the Mass Change functionality, but it’s a fairly simple process to accomplish this with an Import and Export scenario. We do this all the time.
If you need more details I’d be happy to help, but this is the basic process.
- Create an Export scenario to export BOMs and when exporting, set a “Source Restriction” filter on the export scenario to only export the material lines that need to be removed.
- Create an Import scenario that uses the data from the export to target those material lines that need to be deleted. Use the <Line Number> =-2 action to delete the targeted lines. See the below screen shot from the import scenario for reference.
-
Import Scenario Mapping A few things to note.
I also use the scenario to add BOM materials, so ignore the lines that are unchecked in the ‘Active’ column.
I don’t have a line that takes the BOMs off hold, after making the change. This seems to be an Acumatica bug and I couldn’t figure out how to make that work, so I just use the mass update functionality on the BOM GI to take them off hold after making changes.
Thanks. I wonder if anyone has put this in as a future improvement. Seems like a function that would be beneficial.
Userlevel 7
+3
This request has not been captured yet as a Community Idea - I agree it would be good to have it created if you can make the time and provide you Use Case.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.