Quickbooks - get data from QB

The place to discuss and announce issues that don't relate directly to ProMatrix, but that are of interest to ProMatrix users. Feel free to use the Chatter forum as you like (as long as your use is in good taste).

Quickbooks - get data from QB

Postby cyril » Wed Dec 04, 2013 8:37 pm

I need to get the trial balance and chart of accounts from QB.

Has anyone done this successfully with VFP?

Any tips or suggestions/
Or <hopefully> some sample code to help get me started?

All ideas welcome. My email is fgolver@y7mail.com

Thanks
Cyril
cyril
 
Posts: 9
Joined: Tue Jan 25, 2011 1:48 am

Re: Quickbooks - get data from QB

Postby cti2 » Thu Dec 05, 2013 6:27 am

Although most of their examples are in VB, I was able to figure most things out by downloading their SDK, using the SDK and Mr. Google
Pete
cti2
 
Posts: 181
Joined: Wed Oct 13, 2010 6:38 am

Re: Quickbooks - get data from QB

Postby stecenko » Thu Dec 05, 2013 10:47 am

And here is a link that I found especially helpful...
http://doc.qodbc.com/qodbc/20/tables/ta ... ables_id=1
Richard Stecenko
Interactive Computer Services Inc.
Victoria, British Columbia
204.453.2052
stecenko
 
Posts: 822
Joined: Mon Jun 21, 2010 8:06 pm
Location: Saanich, British Columbia

Re: Quickbooks - get data from QB

Postby cyril » Thu Dec 05, 2013 6:37 pm

Thanks Pete and Richard

I am interested to see that you went with their SDK rather than one of the 3rd party tools. For example I found this:
http://synergration.com/software/coreobjx/

Did you look at any tools like this?

I'd be interested to see how coding the SDK looks.

Cyril
cyril
 
Posts: 9
Joined: Tue Jan 25, 2011 1:48 am

Re: Quickbooks - get data from QB

Postby cti2 » Thu Dec 05, 2013 6:43 pm

I looked at a few 3rd party tools but determined they were just another layer between me and QB.
I'de rather have direct control.
My QB integration is so extensive that I needed to learn a lot about it anyways so I bit the bullet and went through the learning curve and it all works quite well.
Pete Ryder
cti2
 
Posts: 181
Joined: Wed Oct 13, 2010 6:38 am

Re: Quickbooks - get data from QB

Postby stecenko » Thu Dec 05, 2013 8:08 pm

I also downloaded a few 3rd party tools and some worked, some didn't.

I agree with Pete: it's just as easy to learn QB's SDK as it is to learn some 3rd party tool.
Richard Stecenko
Interactive Computer Services Inc.
Victoria, British Columbia
204.453.2052
stecenko
 
Posts: 822
Joined: Mon Jun 21, 2010 8:06 pm
Location: Saanich, British Columbia

Re: Quickbooks - get data from QB

Postby cyril » Fri Dec 06, 2013 2:06 am

Thanks for the info.
Have you looked at the online version of QB? If yes, does the SDK work with it as well?

Cyril
cyril
 
Posts: 9
Joined: Tue Jan 25, 2011 1:48 am

Re: Quickbooks - get data from QB

Postby cti2 » Fri Dec 06, 2013 5:17 am

No I haven't looked at it but their SDK documentation should indicate if it does.
cti2
 
Posts: 181
Joined: Wed Oct 13, 2010 6:38 am


Return to Chatter

Who is online

Users browsing this forum: No registered users and 1 guest

cron