[AccessD] QuickBooks Project... Anyone game?

Robert Gracie Subscriptions at servicexp.com
Fri Jun 11 06:34:32 CDT 2004


Christopher,
 I guess there are about 75 VB examples in the SDK (3.0). All of which are
as seamless as the next as far as I have played with (there just a pain to
work with). It is really easy to see this for yourself if you have
QuickBooks 2002 or above..

 The problem is, there are no (none that I can find at least) complete
sophisticated solutions that are under 500.00. I have tried the coreObjX
dll, but that thing is a nightmare to even get registered on the users
machines (even their own install routine will not register 9 time out of
10), the other (AcctSync) solutions I found is about 1K, so it's out of my
price range.

 What I'm hoping (going) to build is a class based solution based on the
QBFC. So in the end I will end up with a solution that will allow for
portability, and very easy communications with QB. The solution will do all
the "grunt" work under the hood automatically, and allow me to send and
interpret QB requests very easily.

 It's not easy working with QB's API, and I would have like to made it an
open source kind of thing, but I was hoping for at least 5 serious
developers to join in.


Robert Gracie
www.servicexp.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Christopher
Hawkins
Sent: Thursday, June 10, 2004 8:51 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] QuickBooks Project... Anyone game?


Wait a minute - aren't there prepackaged VB6 samples for the customer
and invoice creation modules in the QB SDK?  That would explain the
seamlessness of those tow particular operations.  ;)

What do you need to be able to do with QB that you can't do now?
That is to say, what is the intended scope of this QuickBooks project?

-C-

---- Original Message ----
From: Subscriptions at servicexp.com
To: accessd at databaseadvisors.com,
Subject: RE: [AccessD] QuickBooks Project... Anyone game?
Date: Thu, 10 Jun 2004 20:00:25 -0400

>Christopher,
> At this point (just starting), I am able to create a new customer,
>and a
>invoice completely within my program. Now, QuickBooks has too be
>open, (I
>think I maybe able to use their QuickBooks Remote Data Sharing
>Client with
>QuickBooks Remote Data Sharing Server to get around this but I'm not
>sure)
>to interact with the data. Outside of that it's seamless.
>
>
>Robert Gracie
>www.servicexp.com
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Christopher
>Hawkins
>Sent: Wednesday, June 09, 2004 8:53 PM
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] QuickBooks Project... Anyone game?
>
>
>Mine are too.  The trick is, how seamless can it be made?  The last
>time I looked at the SDK and the documentation, it appeared to me
>that part of the non-seamlessness was baked in to QB itself.
>
>-C-
>
>---- Original Message ----
>From: Subscriptions at servicexp.com
>To: accessd at databaseadvisors.com,
>Subject: RE: [AccessD] QuickBooks Project... Anyone game?
>Date: Wed, 9 Jun 2004 20:22:20 -0400
>
>>Wow
>> Intuit has a greater then 85% market share. I'm not sure about you
>>guys,
>>but my clients are screaming for a strong solution that interacts
>>with
>>QuickBooks in my products.
>>
>>
>>Robert Gracie
>>www.servicexp.com
>>
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John
>Bartow
>>Sent: Tuesday, June 08, 2004 10:18 PM
>>To: Access Developers discussion and problem solving
>>Subject: RE: [AccessD] QuickBooks Project... Anyone game?
>>
>>
>>Mark, I don't want to continue this OT too much but I have to agree
>>- even
>>though I use it. You can't even have a customer be a vendor that you
>>also
>>purchase from! Drives me nuts!
>>
>>JB
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MarkH
>>Sent: Tuesday, June 08, 2004 7:46 PM
>>To: 'Access Developers discussion and problem solving'
>>Subject: RE: [AccessD] QuickBooks Project... Anyone game?
>>
>>
>>Side tracking a little... We use QB for the company accounts, the
>>lady
>>who does my books has torn it to pieces. She has found numerous
>>flaws in
>>the program, in particular in relation to journal postings and VAT,
>>can't remember what exactly (as I have a very short attention span)
>>but
>>don't be surprised if things don't always balance... I looked at
>>developing a few tools (data extracts and analysis) for it but
>didn't
>>bother starting once I realised Quickbooks couldn't even do a decent
>>job
>>of it themselves...
>>
>>Sorry to be negative but I found it to be a very disappointing piece
>>of
>>software, particularly in respect to data extracts, windows
>>integration
>>and simple accounting practices...
>>
>>Mark
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
>>Smolin
>>- Beach Access Software
>>Sent: 08 June 2004 23:54
>>To: Access Developers discussion and problem solving
>>Subject: Re: [AccessD] QuickBooks Project... Anyone game?
>>
>>
>>Robert:
>>
>>I looked at the QuickBooks SDK and gave up.  Used the two-step -
>>export
>>from my app to their funky file format and import into QuickBooks.
>>You
>>can have the code if it helps.  But I think you're looking for the
>>seamless solution.
>>
>>Rocky
>>
>>----- Original Message -----
>>From: "Robert Gracie" <Subscriptions at servicexp.com>
>>To: "Access Developers discussion and problem solving"
>><accessd at databaseadvisors.com>
>>Sent: Tuesday, June 08, 2004 2:45 PM
>>Subject: [AccessD] QuickBooks Project... Anyone game?
>>
>>
>>> Ok,
>>>  The first question is.. Does anyone here currently (or have plans
>>in
>>> the
>>> future) to programmatically interact with QuickBooks 2003 or
>>greater,
>>either
>>> on a data or "front end" (Version 2004)level?
>>>
>>>  The second question, would anyone here be interested in grouping
>>our
>>> efforts together to come up with a "wrapped" solution, such has
>>been
>>> done with the BEU?
>>>
>>>  I'm looking at a Class based solution that can handle all the
>>major
>>> functions a typical company would need to interact with QB.
>>>
>>>  What Say You?
>>>
>>>
>>> Robert Gracie
>>> www.servicexp.com
>>>
>>>
>>>
>>> --
>>> _______________________________________________
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>
>>--
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>--
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>
>>
>>--
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>
>>--
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>


--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list