Quickbooks integration

rubyonrails-talk
1

Does anyone out there have experience integrating with QuickBooks using qbXML, the QuickBooks Web Connector (QBWC), and ActionWebService? I'm going to write an integration soon and was looking for any war stories, hints, or advice.

Thanks, Zack Chandler http://depixelate.com

2

I will be needing to do this a couple of months from now for a project I am working on. I'd love to hear about your experiences. Sorry won't be able to contribute anything right now.

-bakki

PS: Co-incidentally the customer I am working for also is a Zack :slight_smile:

3

I’ve done this before using a combination of Perl, SQL, and qODBC ( http://www.qodbc.com ) – not the most “open” solution and not without its problems, but qODBC provides great support and it’d be easy in my mind to extend ActiveRecord to interface with it.

I can provide some more details on implementation if you like.

D. Taylor Singletary, Reality Technician http://www.realitytechnicians.com

4

Thanks for the ideas. QODBC looks interesting put won't work for my situation because the integration will happen with a web app.

Since posting my original question I've done quite a bit of research into the QuickBooks SDK and am confident that the integration can be done the way I want it.

Since there seems to be some interest on this topic I'll post an article on the integration within the next few days on my blog at www.depixelate.com.

5

The first article in the series is up: http://depixelate.com/2006/12/7/rails-and-quickbooks-integration-part-1

6

Thanks a million for that! I can see the pain coming my way in the not so far future :slight_smile:

-bakki

7

I just finished moving a long time client away from quickbooks to Netsuite. We did his quickbooks integration with straight qbxml as that was all they had available at the time. The Netsuite stuff is very nice, with a very complete soap interface. It's not cheap, but then again the main reason our client left quickbooks was because it has hard limits on the number of customers which he hit.

Chris

8

Chris,   I've looked at NetSuite and it looks nice. I'll probably integrate with them in the future. QuickBooks is very popular with small service-based businesses so this is a priority.

  When you did the integration did you use the QuickBooks Web Connector to sync with the desktop versions? Did you integrate with QuickBooks online by any chance?

9

  When you did the integration did you use the QuickBooks Web Connector to sync with the desktop versions? Did you integrate with QuickBooks online by any chance?

They didn't have the web connector at the time, it was just raw qbxml. Never touched quickbooks online.

Chris