Quickbooks Technical LImitations

[mlollar]

Since I was considering using Quickbooks for a consignment business, I was searching the web to see if this is the way I wanted to go. I found some interesting info on

http://www.jfoxcpa.com/tips/quickboo...imitations.htm

LIST NAME MAXIMUM #
Chart of Accounts 10,000
Items (including inventory items) 14,500
Total Customer, Vendor, Employee, and Other Names 14,500
Job Type (QuickBooks Pro only) 10,000
Vendor Type 10,000
Customer Type 10,000
Payroll Items 10,000
Class 10,000
A/R Terms and A/P Terms added together 10,000
Payment method 10,000
Ship Via 10,000
Customer Messages 10,000
To Do 10,000
Memorized Transaction 14,500
Memorized Reports 14,500
Templates 14,500

And since during a consignment period I could potentially have 20,000 items, I don't think Quickbooks will work for me. The web site also said that even if you delete inactive items, 14,500 is the maximum number that can ever be created, even if deleted. Go figure. Any feedback welcome. Now I am considering QB Point of Sale, but that may be too new and havn't found much info on their site.

[gibbo]

Another of my fun areas.

You are right about the limitations. And yes they are real. You cannot actually delete an item that has sales history, so inactive items that have been used just have to hide.

However, is your number of items the actual number you will be selling, or is it a list from which you will select your active lines?
If the first, 20,000 is a problem. If the second, what is better is to filter the lists outside QuickBooks and only import the ones you need. This could be done with an Access database or in Excel and a bit of Visual Basic.

Be careful with POS programs that integrate with QuickBooks! This is what we are involved with in Australia. We are working with POS Software Companies to send information to QuickBooks. Any program that puts transaction information (lots of data) into QuickBooks is going to cause you grief. Datafile size gets enormous, memory is never enough and reports take forever. If the POS is tracking sales and inventory, all you need is summary info to your accounting - reconciled against the money. We believe in keeping the information tight and small.

[Terry]

QuickBooks has come out with an "enterprise" version that is supposed to support nearly 30,000 items. I don't know much about it or what it costs, but it may be worth looking in to.

But to be honest, I doubt QuickBooks is the solution to track 20,000 unique pieces of inventory. If you want to stay low budget in your software, track the inventory in a database software and use QuickBooks for everything else.