"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."
Benecia Beyer - Accountant
DiVita & Associates, Inc. www.divitainc.com
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!
Regards Jack & Debbie LaBrake - LaBrake's Garden Path & Pond LLC - www.gardenponds.com
ANSWER: No Information was lost in this process - Check the "Retail" account and you'll see that everything's there. Besides, you've got your backup.
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 current.
"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!
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.
Identify customers, vendors, items, or other Names which are inactive and (in single user mode) change their Customer ID to "Retail" or something similar. Quickbooks will ask you if you want to Merge transactions, say "Yes." Do this a few hundred times and you'll have room for a hundred more customers.
Do this 7000 times and you no longer have any problem at all, except, perhaps, stubby fingers and old age.
Or - you can use the QuickBooks14500 solution script.
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.
Discount Catholic Store, Inc, Charlotte, NC 28273
[Thanks, but if I'm so smart how come I'm using Quickbooks?]
I just finished using your program to reduce the size of my Quickbooks customer list and would like to say that it works exactly as you advertise. I would recommend it to anyone that runs into the 14500 Quickbooks customer limit. I was not about to spend $3,000 to upgrade to Enterprise just because I am unable to remove old customers. I own a rapidly growing company (www.landairsea.com) and can find other more important places to spend $3,000. Thank you for a great solution to a problem that many Quickbooks users will eventually face.
Best regards, Rob WagnerPresident - LandAirSea Systems, Inc