You are viewing limited content. For full access, please sign in.

Question

Question

Quickbooks Desktop Integration

asked on February 8, 2022 Show version history

Has anyone ever been able to send data to a Quickbooks Desktop Server? From all the research I have done, even though they created the XML standard back in the early 2000's they never made a way to communicate with it outside of the SDK.

The SDK is for software developers who want to develop an app for the general public to put on the app store.

Here we are just trying to pass internal data within a small organization, something like a REST API would acomplish.

0 0

Replies

replied on February 9, 2022

It was a few years back but I think I used the QuickBooks ODBC Driver from CData.  QuickBooks ODBC Driver: ODBC Driver for QuickBooks - CData Software

1 0
replied on February 10, 2022

This looks perfect, thank you!

0 0
replied on June 23 Show version history

A late-to-the-party post but we are just completing a project for a Laserfiche VAR, integrating between LF Cloud and multiple Quickbooks Desktop files. Here's how we did it without the ODBC Connector due to pricing and yearly cost for the ODBC connector: We registered a dev account with Intuit to get a trial Quickbooks Desktop. We created a couple Global Script Rules in LF Cloud - one for pushing Bills to QB Desktop and one for getting Bill Payment updates. On a workstation we installed the remote agent and created a script rules DLL that takes requests from Cloud and generates QBXML requests. Quickbooks Web Connect is the middle layer that allows interaction with Quickbooks Desktop files without needing user interaction. The only part of the installed Quickbooks SDK we use is the XMLValidator tool. We also had to create a custom SOAP web service to communicate between the Script Rules DLL and Quickbooks Web Connect. There are a lot of moving parts which we centralized through a Configuration application and we log events to a location on the workstation, and created email alerts when there is a serious issue. The Quickbooks desktop and QBXML required to interact with it are old tech - requiring SOAP and XML 1.0. One of the issues we ran into is that Quickbooks accounts can contain special characters like "middle period" within Quickbooks, but you can't pass them through an XML 1.0 file. So instead of matching up on description passed from Laserfiche we had to add a layer that gets the ListID and matches the Account Name passed from a Laserfiche Template field to the Quickbooks ListID for that account. Intuit Tech support was no help but in the end it is painful but doable.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.