I am not sure if following info is what you are looking for.
Nevertheless, these days, it's relatively easy to import/export data
with Quickbooks. It can import Excel or csv file easily. Also many
banks provide transaction details on .qbo files just for importing into
Quickbooks. The .qbo appears to be a type of XML file. Looking at the
content of .qbo files, R:Base can be easily programmed to produce .qbo
files from data table.
--
James
On 5/9/2017 2:41 PM, karentellef via RBASE-L wrote:
Great question
Karen
-----Original Message-----
From: Bruce Chitiea <[email protected]>
To: rbase-l <[email protected]>
Sent: Tue, May 9, 2017 11:54 am
Subject: Re[2]: [RBASE-L] - Quickbooks
Ok then, looking forward.
Is anyone aware of - or had any direct experience with - ANY
accounting system in QuickBooks' market segment (Peachtree, perhaps)
which hosts dead-bang, SQL-compliant import/export capabilities; with
or without resort to third-party "translators"?
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 5/9/2017 8:47:08 AM
Subject: Re: [RBASE-L] - Quickbooks
From: "Bill Downall" <[email protected] <mailto:[email protected]>>
To: [email protected] <mailto:[email protected]>
Cc:
I've built a bridge between R:BASE and QB through a 3rd party product
called Transaction Pro Importer out of Bay State Consulting. It's been
working well for years, but Karen is right: when QB gets upgraded or
moved from desktop to cloud, the TPI product may have to change and
the R:BASE end reworked, too.
That company's experience with trying to move from QB Desktop to QB
Online was a disaster, as others have described. (Would have had to
archive/abandon historical details, and it still took over 24 hours to
convert in testing.) I've also seen a non-profit I have worked with
abandon efforts to improve their QB by moving it to QB Online.
Frank's story -- a company spending 6 figures to learn that moving to
XXX was not an improvement in the end -- is one many people have
shared and heard over and over again when R:BASE developers got together.
On Tue, May 9, 2017 at 11:31 AM, karentellef via RBASE-L
<[email protected] <mailto:[email protected]>> wrote:
Thanks for the two cents. Just confirms everything I've heard
that QB does _not_ want to talk to other programs. The vertical
market app they're looking at apparently has a separate add-on
program you can buy to make the transfer, but who knows what
version of QB it interfaces with. Gonna share your post (but not
your name) with the company.
Karen
-----Original Message-----
From: Frank Massimo <[email protected]
<mailto:[email protected]>>
To: rbase-l <[email protected]
<mailto:[email protected]>>
Sent: Tue, May 9, 2017 10:21 am
Subject: Re: [RBASE-L] - Quickbooks
Karen,
One of my clients has been using R:Base from DOS through
Enterprise 10 (nearly 20 years). Their accountant felt that the AR
portion of the R:Base application should be handled through
Quickbooks (Enterprise Ver 14). They have been using QB as a check
writer for years. I made a number of arguments against it, as they
produce 1000-1300 invoices per day and the well-honed, specialized
R:Base programs developed to create, track and process the
ultimate payment of 1000-1300 invoices a day was in place and
working. The only thing that was missing was integration of AR
numbers for general ledger purposes in Quickbooks, which I pointed
out could be produced easily on demand when the necessary reports
were required. The accountant prevailed and the debacle began. I
wrote the necessary programs to provide overnight data which had
to be fed to QB via Transaction Pro because the QB process of
importing the data was too slow. On the AR side, all of the
specialized functionality of the custom R:Base programs was lost
so the AR staff had to learn (the hard way) that QB had pretty
screens and some neat features but it took them twice as long to
post invoices, not to mention the dozens of other glitches the
import process encountered, the difficulty of handling incoming
EDI payments, and all of the other oddities that R:Base let's you
code around. That's the short version, but bottom line, I am now
busily migrating the AR system back to R:Base.
Just my two cents. Cost them six figures to come to the same
conclusion, though.
Frank Massimo
Tri-State Logistics, Inc.
------------------------------------------------------------------------
*From:* karentellef via RBASE-L <[email protected]
<mailto:[email protected]>>
*Sent:* Thursday, May 4, 2017 1:17 PM
*To:* [email protected] <mailto:[email protected]>
*Subject:* [RBASE-L] - Quickbooks
It's been decades since I've had to deal with Quickbooks, and it
wasn't exactly a joy back then...
Someone just asked me about sending stuff from RBase into
Quickbooks (they do not own QB yet, so it would be a new version
of the software).
Has anyone here used a new version of QB and let me know if it's
easier nowadays to send data to QB? For example, what kind of
formats does it accept as an import? Any gotchas? We'd probably
be sending over lists of "members" (name, address, etc), and
different kinds of revenues received (member fees, special fees,
event fees)
Thanks for any insight!
Karen
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
