Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: buckworks
Maybe there's a comphensive list of software available somewhere on the web, but I can't find it.
You might consider programming a front-end for your Access database with Coldfusion. Coldfusion integrates with Access Databases rather easily. Also, if you used to be a programmer of any sort you should be able to learn Coldfusion easily.
We have over 1100 inventory items in QuickBooks and I have a feeling I'm not far from exceeding it capability to manage inventory -- that's not QB's main job, and it seems that it's getting slower as time goes by.
It'd be smarter to use QB to keep track of total daily sales and accounts payable, but I'm in a little too deep at this point to just change how I do things...
I think I'll need to buy software as I just don't have the time to start programming a better UI. My accountant has advised me to consider Quickbooks, though how easy is it to import/export data and customise?
Currently my Access system allows me to:
1)Import orders from my custom web shop
2)Process credit card transactions (using ActiveX component)(for phone orders)
3)Postcode addresss lookup for delivery/invoice addresses (for phone orders) for speed and acurracy.
4)Export data to Courier system for printing of despatch labels and delivery manifest
5)Inventory control & forecasting
6)Reconcilling online credit card transactions received against individual orders
Does anything think the above is possible with Quickbooks?
I would say you need to answer:
1. Do I need a warehouse tracking system?
if Yes...find a warehouse and shipping system that has financials built in...not the other way around.
2. Do I do my own taxes or does someone do them for me?
I do my own...QB and TurboTax have good integration, etc.
If someone else does them look for something that generates ACCURATE reports.
I am not suggesting one package over another...just trying to give an example of how to look at the problem. There are some software selection matrices on the web...usually used for consulting. I would find one that fits your finances/reporting/sales needs and fill it out. It should highlight your needs and help in the decision process.
QB works acceptably well for inventory control, provided you enter invoices for every order -- either by importing or manual entry. Plus you have to enter your item receipts when new inventory is received. The benefit is that creating purchase orders is fairly easy, though not automatic.
QB really shines as an accounting tool for tracking your income and expenses, but isn't particularly suited as a point of sale system (Intuit sells a separate POS system that is separate from but integrates with QuickBooks. Aimed more at a retail storefront operation than a web store, I think.) It'll handle the inventory, sales orders, invoices, etc. for you but there are probably better tools.
It's hard to find one system to do every thing. A lot of people use the above described system and it works fairly well.