Question

EIR Inventory Receiving - what happens if the client repeated sells negative inventory

Forum|Forum|3 years ago
December 29, 2022
3 replies
16 views

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

QuickBooks Enterprise Suite

JoesemM

QuickBooks Team

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.

Go to the Reports menu.
Select Inventory, then select Inventory Valuation.

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!

N

Neural BookkeepingAuthor

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?

Nicole_N

QuickBooks Team

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:

Go to the File menu.
Scroll down to Utilities and select Verify Data.
Click OK.

To Rebuild Data:

Go back to the File menu, then choose Utilities.
Select Rebuild Data.
Click on OK when you get the message Rebuild has completed.

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:

Go to Start.
Select Control Panel.
Under Programs and Features, select Uninstall a Program.
Click QuickBooks, and select Uninstall/Change.
Select Repair.
Click Finish.

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!

Sign up

Login with SSO

Let's get you signed in

Login with SSO