Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Duraflex
Level 1

How to split / archive a corrupted .dbs file (or) create a new company file from the old one?

We 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"?

3 Comments 3
SashaMC
Moderator

How to split / archive a corrupted .dbs file (or) create a new company file from the old one?

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:

 

  1. Open QuickBooks Desktop and the company file you want to copy.
  2. Find where you saved your file by pressing F2 to open the Product Information window.
  3. In File Information, see where you save your company file on your computer.
  4. Back up your company file and rename it when you restore your company file.
    Note: This creates a unique copy of your original company file.  Save the new file to a unique folder.

 

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. 

 

 

Duraflex
Level 1

How to split / archive a corrupted .dbs file (or) create a new company file from the old one?

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?

Chrea
Level 8

How to split / archive a corrupted .dbs file (or) create a new company file from the old one?

@Duraflex 

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us