Parts In Assemblies Not Being Pulled From Inventory

Hello there, @johannaox.

In QuickBooks Desktop (QBDT), you have the option to combine inventory parts to build and track finished goods. Once you build, the system automatically updates your stock of components. To ensure it updates, let's make sure that you'd able to add your product's bill of materials. 

Once verified, try to run the Inventory Valuation Summary report again and check to see how it works. 

To learn more about tracking the products you manufacture, see this article: Track the products you manufacture.

Keep me posted with the result. I want to make sure you're taken care of. Have a great day!

Thank you for the reply! I think I've set everything up correctly for the assembly and part, but the inventory valuation summary still shows full stock of the item.  We should have zero quantity of the item highlighted.  I have attached pictures of the inventory valuation summary, inventory part, and assembly.                                                                                                                                                                                                                                      

Thanks for getting back in the thread and providing a screenshot, @johannaox.

A data integrity issue could be the reason why the part assemblies are not being pulled from inventory. In this case, let's run the  Verify Rebuild Data tool that helps identify and repair data issues within your company file. 

Here's what you'll need to do:

1. Click the File menu at the top.
2. Go to Utilities, then choose Verify Data.
3. If QuickBooks detected no problems, there's no further action needed. If you receive a message, "Your data has lost integrity", the file is damaged. Just continue to Rebuild Data to correct the problem.
4. When you Rebuild Data, you'll receive a message to back up your company file, just click OK. The utility starts as soon as the backup is finished.
5. Click OK when you get the message "Rebuild has completed".
6. Run Verify Data again to check for remaining data damage.

For more details about the Verify/Rebuild process, check this article: Verify and Rebuild Data in QuickBooks Desktop.

Once done, check to see if everything is working now. 

You'll also want to visit this link for more troubleshooting steps: Fix data damage on your QuickBooks Desktop company file.

Please let me know how things go on your end. I want to ensure this gets resolved for you. Take care.

Tried that as well, but to no avail.  It is still not updating the quantities of inventory parts within assemblies that have been sold.  Any other suggestions?  Is it because it can't update past transactions, only those going forward?

Joining the thread to assist you, @johannaox.

Yes, creating a new entry will not update past transactions that have been closed. A newly built assembly will only remove the inventory items in stocks moving forward.

Therefore, here's an article you can read to learn more about assembly you build: Combine your Inventory Items to Build Finished Goods.

But if you wish to adjust the quantity of your inventory items saying they've been sold in the past, I'd recommend contacting your account for guidance. Use this link to find who you're able to work with near you: Business is Better with a ProAdvisor.

I'm adding this article with the topics that allow you to skip manual tracking and focus on making your own products: Track the Products you Manufacture in QuickBooks Desktop Premier, Enterprise, or Accountant.

If you have any other questions aside from building an assembly, please let me know in the comments below. I'll be here to lend a hand. Take care and stay safe!

So I sold another assembly and checked to see if the quantity dropped for the parts within the assembly.  They did not.  So it seems, moving forward, it is not adjusting quantity on hand either.  Any other suggestions?

Thanks for coming back, johannaox.

Let's make sure we build the assembly before selling it to adjust the quantity on hand. Then, try selling another assembly again. If the same thing happens, we can download the QuickBooks Tool Hub helps to fix common errors. We'll need to close QuickBooks to use the tool hub. For the best experience, we recommend you use Tool Hub on Windows 10, 64-bit. Here's how: 

1. Close QuickBooks.
2. Download the most recent version (1.5.0.0) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it (like your Downloads folder or your Windows desktop). If you've installed Tool Hub before, you can find out which version you have. Select the Home tab. The version will be on the bottom.
3. Open the file you downloaded (QuickBooksToolHub.exe).
4. Follow the on-screen steps to install and agree to the terms and conditions.
5. When the install finishes, double-click the icon on your Windows desktop to open the tool hub.

Then, run a quick repair on your program by following the steps below: 

1. In the QuickBooks Tool Hub, select Program Problems
2. Select Quick Fix my Program.
3. Start QuickBooks Desktop and open your data file.

If the problem persists, I'd suggest contacting our Technical Support Team. They'll pull up your account in a secure environment and investigate what's causing this issue. You may send a message via chat, call us at a time convenient to you, or we’ll get in touch with you instead. To ensure we address your concern, our representatives are available from 6:00 AM to 6:00 PM on weekdays and 6:00 AM - 3:00 PM on Saturdays, PST. See our support hours and types for more details about this one.

Feel free to visit our Help Article page for more insights about managing your business on the software. 

I want to make sure everything is taken care of for you, please let me know how it goes or after contacting our support. Just leave a comment below and I'll get back to you. Take care always. 

IT WILL NOT WORK. I spent hours with Quickbooks.

If you invoice a customer for an inventory item, it will pull out of inventory.  If you invoice an assembly item, lets say model #1 consisting of an A B C item, once invoiced the # 1 product will be taken out of inventory but the items A B and C will not. 

The issue is, when you BUILD an Inventory item or Assembly item, it adds that to your inventory. In the case of an assembly item, during your building, the BOM components are deducted from inventory. So that's how it tracks inventory. Only until I Build product #1 then its ads the build to inventory while BOM A B C is deducted from inventory. 

The only workaround which I find a huge hassle, is you create your Product SKU as a Group, then list the components in that group. So when you invoice #1 group, it lists all the components A B C in that group on the invoice, and that will deduct from your inventory in real-time. I don't recommend this as Quickbook isn't really designed to work like that.   You're just not going to have accurate inventory totals until you complete your builds and invoice your sales.  You won't have real-time data showing your actual inventory while sales orders are waiting to be completed and your builds are waiting to be entered.