cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Build Assemblies

Our inventory contains numerous Build Assemblies.   How can I export each Bill of Materials out of Quickbooks or a way to export to excel or csv file?  I am currently using Manufacturing and Wholesale 18.0.

4 Comments 4
HoneyLynn_G
QuickBooks Team

Build Assemblies

Hello there, @Anonymous. 

 

Welcome to the Community space. I can share some insights about exporting build assemblies in QuickBooks Desktop.

 

Currently, you can export all items to Excel or CSV file. However, this will not show each Bill of Materials under the assembly. If you wish to continue with the process, here's how:

  1. On the top menu, click List.
  2. Select Item List.
  3. At the bottom part, click Excel.
  4. Choose Export All items.

 

Another way of exporting data is through the Utilities option. You can follow the steps below:

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Export.
  4. Click Lists to IFF Files.
  5. Put a check mark on the Item List box.
  6. Click OK.

 

For additional reference, you can check these links:

That's it. Let me know if there's anything else I can do for you. Just add a comment below. I'm still around to help you further.

 

Anonymous
Not applicable

Build Assemblies

Thank you for excellent explanation however I need to export the Bill of Materials for each assembly.  


@HoneyLynn_G wrote:

Hello there, @Anonymous. 

 

 

Rustler
Level 15

Build Assemblies

@HoneyLynn_G 

 

The one size fits all answer does not answer the question

 

@Anonymous 

Short answer is that you can not get the BOM exported for assembly items

 

You can edit the assembly item, click print, then select the type of file to tab delimited, that can be imported into excel, but it is one BOM at a time

ScriptDawg
Level 4

Build Assemblies

I realize you’re using the desktop version, and this solution works better with QBO since it has integration features, but have you tried checking out the QuickBooks app store to monitor your production and handle your BOMs via a manufacturing app like Katana? You can easily save your product BOMs and variations within the app and export that information in an Excel sheet.   

Need to get in touch?

Contact us