Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveWe use the desktop version. Our live.dbs carried over old data from 2006 that was incompatible with the last global version upgrade we did in 2023. This glitch caused severe file corruption taking our company down for 7 days. Upon restoration, the Intuit high tier engineer recommended to split the database/archiving anything prior to 2016. In the process of him restoring the .dbs, the system created over 5k entries of "negative inventory". We were told by the high tier Intuit tech that any negative inventory prevents splitting the .dbs & we would have to create a "new company file". Our active .dbs is far too large, needs to be compressed/archived or we need to create a new company file. We can't risk more down time. How can we safely "split" or "archive" the older records with this negative inventory (or) how do we "create a new company file"?
Thank you for reaching out to the Community Duraflex! I will be happy to help you create a new company file from the existing one. Here's how:
From there, you would need to remove transactions from the copied company file, check your accounts, and add any other online banking. No worries though, this article below has step by step instructions:
Let me know if you experience any problems! My team and I will be here to assist further. Take care.
Thank you for the reply. This process would copy over all 5k+ potentially corrupted negative inventory records/transactions. We have no idea what those records/transactions are or where to even start looking for them. Is there a way to search for all negative inventory transactions?
You need to run the Condense Data utility to remove old data and create a new company file with a condensed one. The problem is you will need to fix the Negative Inventory issue beforehand.
Run the Inventory Valuation Detail (IVD) report and select Reports>Inventory>Inventory Valuation Detail.
Click the Dates drop-down and select All.
Find all occurrence's of negative amounts in the On Hand column.
Scroll through the report to an item that is showing a negative amount in the On Hand column.
If you can do so legitimately, adjust the dates of the bills and/or invoices so that the bill dates are before the invoice dates.
Repeat those seps for each item with a negative quantity in the On Hand column. It is not sufficient to adjust the current QOH to a positive value. You must eliminate each occurrence of negative QOH.
If you don't have time to fix them, you can purchase a 3rd party service to do so during weekend to lower your downtime.
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