In Autodesk Fusion Operations, it is possible to bulk update the Bill of Materials (BoM) for a product using an Excel import. This allows you to,
Delete the existing BOM
Add to and update the existing BOM.
1. Delete the existing BoM
The first step to update a product's BoM is to delete the incorrect materials/quantities.
1. Go to products (1), apply any filters if needed (2), select all products (3), and export the BoM (4) of all products that respect the filter.
2. Download the file.
3. On the Excel export, apply the filters on the desired column, taking into consideration the update you need to do:
To update the consumed products of a specific product: Apply the filter on column A
To update the BoM of all products that consume a specific product: Apply the filter on column C
4. Go to products (1), select "Import Bill of Materials" (2) and click on the ‘Excel’ link (3) as shown below to download the template for importing the BoM update.
5. Copy the previously filtered data from the exported file and paste it into the template.
To delete the consumed product, in the "Consumed Product Quantity" column, place the text [delete].
For this example, all the BoM of the product "Mango Cake" will be deleted.
6. Import the template (1) and click confirm (2).
2. Add/update existing BoM.
You can also add consumed products to the existing BoM.
1. Go to products (1) and select "Import Bill of Materials" (2) and click on the ‘Excel’ link as shown below to download the template for importing BoM.
2. Fill in the template with any new products that need to be added.
3. Import the template (1) and click confirm (2).
Pro-Tip: You can also add new consumed products or delete existing consumed products in a single import, as shown below.
If, after reading this article, you still have some doubts, feel free to reach out to us through our live chat feature or directly to your CSM.
Need help? Request a Fusion Operations expert to contact you here.