Quickbooks 2016 Pro - Condense Data

Last night I tried a condense on a customers QB Pro 2016 file because every year, they hit the limit on customers so we have to condense the file.  They don't want to spend the money to go to Enterprise which would alleviate this issue.  I thought we did all of the necessary backups, etc but it took over 6 hours and it seemed to lock up at 99% on Step 2 of 4 - I saw another inquiry on this from a while back but didn't have a lot of explanation to it.
Daren Anderson, MSISPresidentAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
I do not think you can do this for free (I have been using QB for years).

Try Supercondense:   http://quickbooksusers.com/quickbooks-supercondense/
Daren Anderson, MSISPresidentAuthor Commented:
I have done it at least a couple of times before - the utility is in QuickBooks.
JohnBusiness Consultant (Owner)Commented:
I have QB Pro 2017 here and the option is to Rebuild the file (which does some condensing).  But QB Pro does not (in the versions I use) remove a selection of records (say whole fiscal years)  . You may have a different Country version from me.
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

JohnBusiness Consultant (Owner)Commented:
If Rebuild is separate in your version, copy the file to a local machine and rebuild it. Never rebuild (or condense) over a network connection. Always do this locally.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Daren Anderson, MSISPresidentAuthor Commented:
Yes I was thinking that as well - I usually have never done that but thinking I will try that next.
Daren Anderson, MSISPresidentAuthor Commented:
I did it locally last week and worked fine.  Thanks
JohnBusiness Consultant (Owner)Commented:
Thanks for the update and I was happy to help you resolve this.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.