cancel
Showing results for 
Search instead for 
Did you mean: 
gerdgoebel
Level 4

Alter deleting all transactions items still remember average cost

I am using QB Prem 2020 with latest updates.

I used an existing database, deleted all the transactions and some items I don't need any longer.

I kept bulk inventory items and assembly items. However, when updating the cost and sales price on the bulk and assembly items I still see the previous average cost. I don't want that as the new DB should start with the new cost of the items.

How can I remove the average cost? 

I had tried a DB rebuild but no success.

I don't want to end up deleting all item then re-entering them from scratch.

4 Comments 4
Rejeil_O
QuickBooks Team

Alter deleting all transactions items still remember average cost

Hello there, @gerdgoebel.

 

It might be your QuickBooks Desktop is an outdated version that's why you're having trouble updating your bulk and assembly items. You can follow these steps on how:

 

  1. Sign out your company file in your QuickBooks Desktop account.
  2. Go to the Windows Start icon.
  3. Search for your QuickBooks Desktop.
  4. Right-click the icon and select Run as administrator.
  5. Go to Help in the No Company Open screen.
  6. Choose Update QuickBooks Desktop.
  7. Select the Options tab.
  8. Click the Mark All, then Save.
  9. Go to the Update Now menu and put a checkmark in the Reset Update box.
  10. Once done, Hit the Get Updates button.

 

Once the update is done, you'll have to close and reopen your QuickBooks Desktop. Then, select Yes to install the updates.

 

When the install finishes, restart your computer.

 

I've also added an article in case you'll need help updating your items in your QuickBooks Desktop account: Add, edit, and delete items.

 

If you have follow-up questions, please don't hesitate to leave a message in the comment section. I'll be happier to help. Take care, and have a good day.

gerdgoebel
Level 4

Alter deleting all transactions items still remember average cost

I have the latest updates installed already, rebooted the PC, restarted QB and started my company file.

The problem is that this company is a cleaned up copy of another db. All transactions have been deleted, but for whatever reason, QB still has the old average cost somewhere.

I checked the item inventory and item assembly tables with ODBC but in both tables there are no average cost displayed, thus, I assume it gets calculated somehow.

Any other ideas I could try?

Angelyn_T
QuickBooks Team

Alter deleting all transactions items still remember average cost

Thank you for the additional information, @gerdgoebel.

 

Deleting and recreating the item would resolve the issue. If you don't want to recreate them, I would recommend reaching out to our Support Team. This way, a representative can review your account securely and check for the possible reasons why the items still remember the average cost.

 

To contact support:

 

  1. Open QuickBooks.
  2. Go to Help, then select QuickBooks Desktop Help.
  3. Select Contact Us.
  4. Give a brief description of your issue, then select Let's talk, and then choose a way to connect.

To learn more about inventory tracking in QuickBooks Desktop, you can check out these articles:

 

Post again if you have any other questions. I'm always here to help. Have a good day!

gerdgoebel
Level 4

Alter deleting all transactions items still remember average cost

Unfortunately I have too many items. But I don't want the previous avg. cost either. I ended up deleting all the items and am still creating them again.

I will send an info to the development team about it. If there are no transactions we should only have the avg. cost being the one from the material.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us