Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Can the database become corrupted when negative inventory is repeatedly sold (the client was desperate to bill for the sale of products - ignored the dangers of selling negative inventory)?
Can this corrupt the database and the db pointers to the extent that there is no recovery for the database?
Thanks
Hi there, @Neural Bookkeeping.
Let me share some information on what will happen when selling negative inventory.
The database will not be corrupted when you repeatedly sell negative inventory. However, it may cause errors on your reports in QuickBooks.
Selling inventory, that you do not have will cause your Quantity On Hand (QOH) negative and incorrect Cost of Goods Sold (COGS) on your P&L report.
In case, you want to view your negative inventory, run the Inventory Valuation Detail (IVD) report.
The IVD is the ONLY report that you can use to evaluate the extent of your negative inventory. It will shows negative numbers in the Quantity on Hand (QOH) column.
For more information about negative inventory, you may open this article: Fix negative inventory issues in QuickBooks Desktop. It also contains steps on how to fix and prevent negative inventory in QuickBooks.
To know more about managing inventories in QBDT, consider checking out these articles:
Please let me know in the comment below if you have follow-up questions about inventory or anything else QuickBooks. I'm always here to help. Take care!
What would cause the DB to be corrupted, because it is corrupt. We enter correcting transactions, QB Enterprise accepts the changes, we check the results, all good. 1 hour later, we are working on another problem and we are notified that the transaction that we fixed is now should as not being paid. Would deleting, redefining, and entering Items from the Item list corrupt the data?
Thanks for getting back here, @Neural Bookkeeping. Allow me to chime in and share some information about what causes data damage in QuickBooks Desktop.
Deleting, redefining, and entering items from the item list won't corrupt the data. It's possible that there's another cause for it.
To get this sorted out, let's try running the Verify and Rebuild Data Utilities. This identifies any potential data damage issues that might've caused the transaction showed as not being paid.
First, make sure to secure a backup copy of your company file.
Here's how to verify data:
To Rebuild Data:
You can check out this article that details the process: Verify and Rebuild Data in QuickBooks Desktop.
If this doesn't work, you can run a QuickBooks repair to ensure that the software and your files are free from any potential damage.
Here's how:
I'm adding this article to learn about the different damage errors in QuickBooks Desktop: Different types of Data damage.
You might also want to learn how to add, edit, and delete items. This article will guide you through the process: Manage items in QuickBooks Desktop.
Let me know in the comment below if you have any other questions about data damage or any other QuickBooks-related concerns. I'm always around to help. Have a nice day!
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