Quickbooks Data in Web Apps

Jun 15, 2008 6 Replies

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.


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":

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.

Jesse,

We provide the same service you are looking for through our Web service InLattice -

formatting link
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

formatting link
for moreinfo.

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

formatting link
more information.

Jesse,

We provide the service you are looking for through our Web service InLattice -

formatting link
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

formatting link
for moreinfo.

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

formatting link
more information.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required