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 Prodsmart via an Excel importer.

Excel template

The first part requires understanding how the Excel columns are organized. You can download the template here: https://app.prodsmart.com/import/consumption

And the downloaded file will contain 8 column:

  • Product Code: product that is being produced,

  • Operation Code: operation for the product being produced 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 “.”.

  • In case you have product revisions enabled, those can be imported as well via Excel. You can enter on column E the revision for the produced product code, and on column F the revision for the consumed product code.

  • 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)

  • 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.

In case you have product revisions enabled, those can be imported as well via Excel. You can enter on column E the revision for the produced product code, and on column F the revision for the consumed product code.

How to upload BoMs

The second step requires (1) opening the products page, on the left side of the screen, and afterwards (2) tap “Import”, on the top-right corner of the screen.

Here, you should tap on the second option, “Import BoM”.

You should afterwards click “Choose File”, and select the Excel file you want to import.

To finalize, tap “Start to Send”.

Take a look at the result to spot errors on the import (for example, in case neither the products or the operation exist). You can rework your Excel and try again, or ignore the error lines (on the column at the right). When you’re sure about the data entered, tap “Confirm”.

Take a look at the short video below:

Additional notes:

  • The importer sums repeated lines.

In other words, if a line is repeated, the system sums the quantities on both lines. Take a look below. Importing the following Excel lines:

Results on this BoM:

If you’d like to enable that option for a large set of consumptions, reach out to us on the chat so we an give you an extra help :)

Need help? Request a Prodsmart expert to contact you here.

Did this answer your question?