Growing business needs distributed access.


D

d_r_newcomb

I am trying to assist a cousin who owns a small specialty furniture
company. He now has a production shop and showroom, and is planning to
add an additional showroom. They have been running QB at one location
but this has become inadequate. They now copy off the QB file and give
it to the "bookeeper" to work with at home then return it to the
showroom computer.

He was looking at QB Enterprise but the price puts him off a bit. Also,
GoToMyPC. After reading this group, I suggested that he upgrade the
main computer to WinXP-Pro and add a high-speed network connection to
be able to run QB via MS "Remote Desktop".

He also has the idea that each of the lead employees should be able to
carry a laptop and work on his part of the books, wherever they may be,
and synchronize the changes when they get network access. I told him
that this was beyond my (very limited) understanding of financial
software.

I'm primarly a scientific geek. I understand computers, databases and
networks but have little understanding of the business software market.
Any suggestions are appreciated, including going to programs other than
QB.

Donald Newcomb
DRNewcomb (at) attglobal (dot) net
 
Ad

Advertisements

K

Karl Irvin

I am trying to assist a cousin who owns a small specialty furniture
company. He now has a production shop and showroom, and is planning to
add an additional showroom. They have been running QB at one location
but this has become inadequate. They now copy off the QB file and give
it to the "bookeeper" to work with at home then return it to the
showroom computer.

He was looking at QB Enterprise but the price puts him off a bit. Also,
GoToMyPC. After reading this group, I suggested that he upgrade the
main computer to WinXP-Pro and add a high-speed network connection to
be able to run QB via MS "Remote Desktop".

He also has the idea that each of the lead employees should be able to
carry a laptop and work on his part of the books, wherever they may be,
and synchronize the changes when they get network access. I told him
that this was beyond my (very limited) understanding of financial
software.
You need a third party transfer utility to do this. One is the Data Transfer
Utility at www.q2q.us
 
D

d_r_newcomb

So you think that multiple copies of single-user QB combined with this
sort of utility, will allow a small business to work reasonably well in
a distributed computing environment?

Donald Newcomb
DRNewcomb (at) attglobal (dot) net
 
T

Tee

I am trying to assist a cousin who owns a small specialty furniture
company. He now has a production shop and showroom, and is planning to
add an additional showroom. They have been running QB at one location
but this has become inadequate. They now copy off the QB file and give
it to the "bookeeper" to work with at home then return it to the
showroom computer.

He was looking at QB Enterprise but the price puts him off a bit. Also,
GoToMyPC. After reading this group, I suggested that he upgrade the
main computer to WinXP-Pro and add a high-speed network connection to
be able to run QB via MS "Remote Desktop".
One copy, 5 user license. Each computer (including the bookkeeper) installs
the software using a different license. The main company file resides on
the most trusted computer. All others access that one company file via
Multi-User Access (only available with multi-license purchases).

A high-speed connection and a reliable source computer are needed. I'd
advise against just deciding to go this route without considering other
options first. Are the other employees trustworthy & knowledgable? How
safe is the data in terms of someone screwing it up royally and throwing the
books into an accounting nightmare? How necessary is it to have the
information from the other location entered by the other location?

IOW what about a point-of-sale solution? What about an Excel spreadsheet
solution? What about using pre-printed or hand-written sales receipts,
sales orders, etc?

I may be overly anal about this but I really don't think too many hands
should be able to change the books. Leave that to the bookkeeper and/or
owner and find a simpler, less risky, solution for the day-to-day running of
the business for others.
 
K

Karl Irvin

So you think that multiple copies of single-user QB combined with this
sort of utility, will allow a small business to work reasonably well in
a distributed computing environment?

Donald Newcomb
DRNewcomb (at) attglobal (dot) net
Probably not. The comments were directed at the question about using laptops
offline and then getting the data to the main QuickBooks file. For fixed
locations with high speed internet connections I would try remote access
first but the best way is to use Windows terminal server on your own server
or have your QuickBooks hosted on terminal server.
 
Ad

Advertisements

H

HeyBub

I am trying to assist a cousin who owns a small specialty furniture
company. He now has a production shop and showroom, and is planning to
add an additional showroom. They have been running QB at one location
but this has become inadequate. They now copy off the QB file and give
it to the "bookeeper" to work with at home then return it to the
showroom computer.

He was looking at QB Enterprise but the price puts him off a bit.
Also, GoToMyPC. After reading this group, I suggested that he upgrade
the main computer to WinXP-Pro and add a high-speed network
connection to be able to run QB via MS "Remote Desktop".

He also has the idea that each of the lead employees should be able to
carry a laptop and work on his part of the books, wherever they may
be, and synchronize the changes when they get network access. I told
him that this was beyond my (very limited) understanding of financial
software.

I'm primarly a scientific geek. I understand computers, databases and
networks but have little understanding of the business software
market. Any suggestions are appreciated, including going to programs
other than QB.
Copy a database and take to another computer for updating then make another
copy and re-install on original, is equivalent to yelling (fill in your own
outrage). Someday, something will go wrong.


It is a rule of the universe that there can be only ONE copy of a database.
This applies to American Airlines Reservations, the New York Stock Exchange,
Social Security Administration, or QuickBooks. All workstations MUST be
working against the same, single, database.

It IS possible to violate this rule (although not with QB) if you throw
enough money at it - but even then, there are insurmountable problems.
Suppose two ancillary sites each change the same thing, say a customer's
address. Even when these time-date stamped transactions reach the master -
assuming each field carries its own update time- who's to say whether one of
the outboard computers clock is correct?

Remote Access (in XP) won't work inasmuch as it only allows the operator to
translate the target computer's keyboard and screen to a single remote
machine. For these far-flung data sources, you'll need a master machine
running something like Windows 2003 Server, and a VPN (Virtual Private
Network) over relatively high-speed lines.

Sometimes a five-cent solution is better than a $50 one: tell the sales
force to hand-write their orders and fax them in.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

USA software for growing business 1
Distribution Center 0
Tax complexity grows and grows 1
USA Distribution to Officers 5
USA Payroll vs Distributions 1
Taxes on trust distribution 5
USA Distribution on S-corp 0
USA LLC Distributions to Members 0

Top