The Bill of Materials (BoM) feature can be checked in detail in this article, where you can understand how to set it for consumables inventory tracking.
However, later on, it becomes important to import this information in a faster manner. In this article, you’ll learn how to speed up the process in Autodesk Fusion Operations via an Excel importer.
Excel template
The first part requires understanding how the Excel columns are organized. You can download the template here:
The downloaded file will contain 8 column:
Product Code: product that is being produced,
Operation Code: operation in which the consumption takes place,
Consumed Product Code: code for the product being consumed,
Quantity: quantity of the consumed product code consumed (column C) per unit of product produced (column A). Decimal quantities should be denoted with a dot “.”.
If you have the Dynamic BoM feature enabled, you can set consumptions for specific product parameters in through the importer in column G, the format should be "Parametercode1:answer1,Parametercode2:answer2" (e.g. Color:Green,Size:L)
Fixed Quantity: If you want all consumptions for this product to be made with the same quantity, regardless of produced quantity, you can types "Yes" into this field to set the fixed quantity for the consumption.
How to upload BoMs/Consumptions
1. On the left menu, click on ‘Products’
2. Click on the arrow next to ‘Add Product’
3. Select 'Import Bill of materials'
4. You should afterwards click on the lightblue rectangular to select the file (or drag it to that area)
5. Tap "Start to Send"
Before confirming the import, take a look at the result to spot errors (for example, in case neither the products nor the operation exists). To fix those you can rework your Excel and try again, or untoggle the error lines (first column at the left).
6. When you’re sure about the data entered, hit “Confirm”
FAQ:
1. If a consumption is duplicated in the Excel import, how does the importer behave?
If a line is repeated, the system sums the quantities on the repeated lines. Take a look below. Importing the following Excel lines:
Results on this BoM:
2. How can I bulk edit or delete existing bill of materials?
It is not possible to directly bulk edit the consumptions on the bill of materials, since the error "Sub-Product already exists!" will be returned.
You should instead type the text [delete] on the quantity cell (column D), which will remove the consumption, and then use the importer again with the new quantities.
Need help? Request a Fusion Operations expert to contact you here.