Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
youmick5
April 15, 2024
Question

Extract a detailed and complete BOM (assembly) of an item from QuickBooks

  • April 15, 2024
  • 3 replies
  • 31 views

Hello, I am facing a problem relating to the management of BOMs or assemblies in QuickBooks Deskop.

We are a car manufacturer and we therefore have many different assemblies with several levels (up to 6 levels).

I would like to extract the detailed BOM for a car with details of each level which would allow me to extract the complete list of all the parts making up the car


For example :

The assembly number of my car is: "CAR 1".
This assembly is made up of 3 sub-assemblies:
- GROUP 1 - Chassis
- GROUP 2 - Engine
- GROUP 3 - Bodywork

Each of these 3 sub-groups is made up of sub-sub-groups of assemblies, for example in the 1st sub-group "GROUP 1 - Chassis":
- Fitted frame (assembly made up of 10 child parts, for example)

 

In this way, we have up to 6 levels of sub-groups, each made up of assemblies and child parts.

I would therefore like to be able to extract the complete and detailed assembly of the car comprising the 6 levels of detailed parts.


To date I have not found any solution to do this. It's only possible to print out the assembly details in an Excel version, but it's not possible to extract all the different levels of an assembly to have the complete list of parts for making my car, for example.
Or you have to do this manually, which is very long and tedious.

If anyone has a solution, it would be great!

Thanks a lot in advance

3 replies

QuickBooks Team
April 15, 2024

Thank you for posting in the Community, youmick5. I'd like to provide some insights regarding assemblies in QuickBooks Desktop. 

 

As of now, the option to extract the complete assembly information of a car that includes its child parts is unavailable. However, you can submit your feedback to our Product Development Team. We prioritize product enhancements based on customer requests, and we quickly review them. 

 

Here's how:

 

  1. Click the Help option.
  2. Select the Send Feedback Online option.
  3. Choose the Product Suggestion option, and a pop-up window will appear.
  4. Type your feedback suggestion.
  5. Click the Send Feedback button, and your feedback will be sent.

 

Furthermore, you can also find a third-party app as a workaround.

 

Additionally, you can check this article if you need to adjust the quantity of your product in QuickBooks Desktop to maintain accurate inventory status: Adjust your inventory quantity or value in QuickBooks Desktop.

 

Please let me know if you have any other concerns regarding assemblies in QuickBooks Desktop. I'm always here to assist you. Stay safe.

youmick5
youmick5Author
April 15, 2024

So your answer is that no solutions exist.


People have already reported this problem 4 years ago and nothing has changed.

What's more, you're asking me to do the work for you by reporting the problem again, even though as a QuickBooks employee you're fully capable of doing so.

It's just absurd to pay astronomical sums for software like yours when it doesn't even allow you to extract basic things like that...

 

The lack of professionalism on the part of your technical teams and the obsolescence of your software will force us to subscribe to another, more efficient, competitor.

 

 

 

Level 5
April 16, 2024

@youmick5 

Have you explored the exporter tool?

https://get.transactionpro.com/qbd

 

Use the trial version to check. Then you can purchase a $299 one time license. You can get $100 cashback to purchase it thru a partner.

New Member
June 19, 2026

I hear you on this.  Did you come up with a solution, or leave Quickbooks altogether?  I'm thinking of using the ODBC driver and creating reports using MS Access.

SIAB
Level 2
June 20, 2026

 

Do you need to produce this report?

 

Assembly Item NameParent Item NameIncome AccountCOGS AccountAsset AccountPurchase CostPurchase DescriptionSales PriceSales DescriptionBuild PointComponent Item NameComponent Item QtyUnit of Measure
Kit1 General SalesCost of Goods SoldInventory Asset56Sample Kit90Sample Kit Carpeting1 
Kit1 General SalesCost of Goods SoldInventory Asset56Sample Kit90Sample Kit Pad1 
Kit2 General SalesCost of Goods SoldInventory Asset60Sample Kit105Sample Kit Wood Door1 
Kit2 General SalesCost of Goods SoldInventory Asset60Sample Kit105Sample Kit Toilet1 
Kit2 General SalesCost of Goods SoldInventory Asset60Sample Kit105Sample Kit Sink1