Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
GWedll
Level 1

Item Assembly showing as $-0- average cost

I have a problem with at least one of my assemblies not relieving COGS properly. I have an assembly 300STEEL-SO-540 that shows no average cost even though there have been a couple of previous builds and the components have costs attached to them.

When I create an assembly build the Total Qty on Hand is adjusted and the average cost is adjusted properly.  When I sell the assembly the Qty on Hand is adjusted properly BUT the average cost is set back to 0.00. The worst part is that there is NO COGS recorded for the transaction.  I am not actually sure where the sold value goes to but it does not go to COGS per invoice transaction journal.

 

I have compared the 300STEEL-SO-540 directly to 250STEEL-DOT-3-540 assembly that IS working properly. Even when we go negative the COGS is recorded as sold with the Average Cost price.  When the Qty on Hand is negative or 0 the average cost value does not reset to 0.00 but keeps an average cost price.

 

I have attached both Item setups for comparison. I am seeing no differences in these and am unsure how to get the average cost price to work correctly for 300STEEL-SO-540.

 

 

 

1 Comment 1
Rasa-LilaM
QuickBooks Team

Item Assembly showing as $-0- average cost

Thanks for dropping by the Community today, GWedll.


I appreciate for being detailed about your inventory concerns. The screenshots will give us a clearer view of what happened to the item and transactions.


Let’s perform some basic troubleshooting steps for the correct average cost to show on the entry. We’ll have to run the Rebuild and Verify Data Utilities to rectify the issue.


The former will help identify common issues in a company file, while the Rebuild Data is used to resolve data damage found by the Verify Data tool.


Before proceeding, create a backup of the company file to keep a copy of your transactions. Once done, follow the steps below to run the utilities.

 

  1. Go to the File menu at the top to choose Utilities and Rebuild Data.
  2. Click OK to create a backup of the company file.
  3. Tap the Save menu to keep the copy.
  4. Press the OK button once the Rebuild is completed.
  5. Then, go back to the File menu to choose Utilities and Verify Data.

 

When the tool finds an issue with the file, click the Rebuild button. If the issue persists, let’s resort the lists in your company file. This troubleshooting makes your items or lists go back to their default order.


For future reference, the following resource outlines steps to fix issues arising from negative inventory: Fix negative inventory issues in QuickBooks Desktop. The solutions are scenario-based, so I suggest you choose the one that fits your situation.


In addition, this link will guide you on how to fix damaged transactions in QuickBooks Desktop. Running the troubleshooting steps will get the file to work properly.


Reach to anytime if you have additional questions about inventory. I’m more than happy to answer them for you. Have a good one. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us