Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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.
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?
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 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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here