Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the best way to integrate with quickbooks from C# code? [closed]

Tags:

c#

quickbooks

from my research it looks like there are basically 3 options.

1: Using COM
2: Using A Webservice and the web connector
3: Using a 3rd party component (and there appears to be quite a few)

Each of these options present a problem for me:
1: I was told I cant use COM
2: This solution seems very hokey to me since I am needing to integrate from a windows service
3: Some of these solutions are rather expensive.

I looks like I am going to have to go the 3rd party route and there are two front runners in my mind:

1: QODBC (http://www.qodbc.com/usa.html)
2: AccessBooks (http://www.synergration.com/AccessBooksUpdater/default.aspx)

My questions, dear reader, are as follows:

1: Which solution (com, web service, which 3rd party) would you use?
2: Why would you choose it over the other options?
3: Is there some other option that I have missed?

like image 421
iamkrillin Avatar asked Aug 16 '11 19:08

iamkrillin


People also ask

What is the difference between C and R in QuickBooks Online?

C is Cleared and would be from accepting a green match in the Review screen. R is Reconciled and means you have completed a reconciliation that includes that cleared item.

Does QuickBooks have API integration?

QuickBooks Online has two APIs that allow third party apps to connect, the QuickBooks Online Accounting API, which allows developers to connect to QBO and the QuickBooks Payments API, which allows developers to process credit card payments on an eCommerce site.

Is QuickBooks Desktop being phased out?

Your access to QuickBooks Desktop Payroll Services, Live Support, Online Backup, Online Banking, and other services through QuickBooks Desktop 2019 software will be discontinued after May 31, 2022.


1 Answers

I have decided to go with another product not mentioned above called "QuickBooks ADO.NET Data Provider" it is apparently made by the same folks who make the QuickBooks integrator product

The reasons I chose it...

1) It has a remote access component
You install the remote server, and you can access your QuickBooks data from anywhere on your network

2) The remote access component can run as a service
Nuff said

3) Provides a SQL style interface to the QuickBooks data
4) Does some auto magic caching to speed up the data access

like image 131
iamkrillin Avatar answered Sep 19 '22 16:09

iamkrillin