Let me help you get the Avg Cost Value get back to the correct amount, Yeazel.
Possible data damage in your company file might have caused the Avg Cost value to change. Let's use the Rebuild Data tool that can resolve common data problems in QuickBooks Desktop.
Here's how:
- Go to the File menu, select Utilities, and then click Rebuild Data.
- Click OK, then follow the onscreen steps to save a backup.
- Let the tool repair your file. It may take some time. QuickBooks may seem stuck, but as long as you can move your mouse, the tool is working.
- When the tool finishes, select OK.
- Go back to the File menu, select Utilities, and then click Verify Data.
- Let the tool check your file for data issues.
Once done, go back to the inventory report and check if the Avg Cost value has gone back to $0.01.
We might also need to run a couple of reports and take a closer look at your company file just in case the issue persists. To do that, please contact our phone or chat support teams so they can help you further with this. Here's an article where you can get their contact details: Contact QuickBooks Desktop Support.
I'd also like to share these additional articles about inventories just in case you might need them in the future:
Add a reply below or reach out to us anytime you need anything else when working in QuickBooks. We're always here to help and guide you.
