"I just wanted to provide you with the link to the blog post I did today for our company's blog: http://www.divitaspeaks.com/ in which I talked about the Quickbooks 14500 club. I have happily decreased my customer master file by half - thanks to you and your wonderful program. Thanks again for your help."
No Data is Lost
Thanks Mark. We have a lot of repeat customers whose information we probably lost but we were able to cut our customer list down by thousands. I'm glad I found your program!
Quickbooks 14500 Solution for All Versions 2006 to current
Quickbooks 14500 Solution
Welcome to the Quickbooks Pro 14500 Community. The program sold on this website will allow you to continue using Quickbooks after the 14,500 limit has been reached. It does this by allowing you to merge customers, items, or vendors. For All Quickbooks versions 2006 to the current version.
"You Can Check Out Anytime You Like, But You Can Never Leave"
If you use Quickbooks Pro, then you need to be aware that once your names file (Customers, Items, Vendors, plus Other names) contains 14,500 names then life, as you know it, is over. 14,500 names is not unreasonable. At my e-commerce site, HandicappedPets.com , was, at the time, getting 20 - 30 orders a day for Dog Wheelchairs and other items.
20 orders x 365 days x 2 years = 14,600.
Quickbooks, under no circumstances, allows you to delete a customer record if there are, or were ever transactions attached. Neither the integrated "Clean Up Company Data Files" nor the "Make Inactive," "archive," or "Portable Company File" function will have any effect.
Quickbooks will tell you that the only solution is to upgrade to their Enterprise version for more than you want to spend.
Note: Your computer may give you a VIRUS WARNING when downloading this. This is because this program uses a "keyboard macro" and makes Quickbooks think you are hand-typing the "merge" commands into the keyboard. This is the only way Quickbooks will allow it. Many virus' also use keyboard macros.
In any case, if it was a virus and hacked into your computer to steal thousands -- oh wait, you already HAVE that virus. It's Called Quickbooks!
Here's What You Can Do
As you are probably in panic mode, wondering how to operate your business tomorrow, you can make room now, manually, in your customer file by MERGING unused customers, vendors, or Inventory Items.
Do this 7000 times and you no longer have any problem at all, except, perhaps, stubby fingers and old age.
Your program worked PERFECTLY! Thank you so much for having the smarts and making the effort to build this program. We upgraded all our software and computers, only to have the POS integration fail because of our 10,000 customers + vendors and items exceeding the 14,500 limit. All Quickbooks said was too bad, upgrade to Enterprise, which was totally unnecessary for us...a small chocolate/candy store that uses Quickbooks Point of Sale and never should have been transferring customers to Quickbooks in the first place...totally not needed. Thanks again. Probably the best $75 this store has ever spent!
- Tim Downey www.4somethingsweet.com
You are a GENIUS!! Thank you for coming up with that script. I have successfully merged all my customers so I can now import new orders into QB. This has been a tremendous help.