Quickbooks Data in Web Apps


J

jesseplace

I am looking for a relatively simple solution to access QB data in a
company file from an ODBC connection.

All I need it to be is read only. I would like a solution where I can
upload the files daily to my web server and allow clients to access
their invoice totals, etc.

I've seen some tools online, but they either seem overly complicated
or require QB actually running on the server.

Does anyone know of or have any experience connecting to a QB file
with ODBC?

THaks.
 
Ad

Advertisements

K

klunk

Even QODBC connects to the QB data file via the QB SDK,
which must connect to an instance of QuickBooks running
"somewhere" -- right?

As for a "simple" solution: setting up a secure way of allowing
multiple customers to view only their invoices over the web
is not a simple project. Unless someone else has already built
it and will sell it to you...

"Karl":
 
J

jesseplace

Yes, the concept of QODBC is what I want, but I would prefer a way
without it running an instance of QB. As for exporting, I need a
fully automated method - upload the company files and connect to them
using SQL.
 
G

Golden California Girls

jesseplace said:
Yes, the concept of QODBC is what I want, but I would prefer a way
without it running an instance of QB. As for exporting, I need a
fully automated method - upload the company files and connect to them
using SQL.
QB runs on a closed version of SQL for a very $$ reason. If it ran on a open
version, someone would create an application to update the payroll deduction
table, thus denying QB a revenue stream.
 
I

InLattice

Jesse,

We provide the same service you are looking for through our Web
service InLattice - http://www.inlattice.com

Inlattice allows you to import invoice, PO and payment data from
QuickBooks with a click of a button.

Your customers can access invoices on the web. Document history is
updated when customer view/print the document as a confirmation. You
can also resolve any discrepancies online.

Please visit http://www.inlattice.net/content/view/21/41/ for more
info.

Similarly, your vendors can view POs, payment data on the web. Vendors
can create their invoices on the web (or import it from QB) and you
can post it to your QuickBooks with a click of a button. Other
features include: Online invoice approval, Notes to resolve
discrepencies, Attacments to invoices etc.

InLattice is being used by 500+ users in both US and UK for over two
years.

You can use the service for as low as $12 per month to exchange up to
to documents.

Note: As Carl has mentioned in the posting, building such a system is
not simple and we have developed this robus, simple to use service,
over the last few years.

Please contact inlattice at infonics.com or visit http://www.inlattice.com
for more information.
 
Ad

Advertisements

I

InLattice

Jesse,

We provide the service you are looking for through our Web service
InLattice - http://www.inlattice.com

Inlattice allows you to import invoices, PO and payment data from
QuickBooks with a click of a button.

Your customers can access invoices on the web. Document history is
updated when customer view/print the document as a confirmation. You
can also resolve any discrepancies online.

Please visit http://www.inlattice.net/content/view/21/41/ for more
info.

Similarly, your vendors can view POs, payment data on the web. Vendors
can create their invoices on the web (or import it from QB) and you
can post it to your QuickBooks without any data entry. Other features
include: Online invoice approval, Notes to resolve discrepencies,
Attacments to invoices etc.

InLattice is being used by 500+ users in both US and UK for over two
years.

You can use the service for as low as $12 per month to exchange up to
50 documents.

Note: As Carl has mentioned in the posting, building such a system is
not simple and we have developed this robust, simple to use service,
over the last few years.

Please contact inlattice at infonics.com or visit http://www.inlattice.com
for more information.
 

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

Top