Community mailing list archives

community@mail.odoo.com

Re: Quickbooks connector

by
Ben Olsen
- 02/16/2015 12:19:10
I'm currently using the Quickbooks Web Connector with a standalone web bridge to connect my Odoo to Quickbooks. Using the XML-RPC is recommended by Intuit, as there's not much error checking with IIF. You can find information on the QBWC here:

I'll attach a stripped-down script (if this list allows python attachments) that uses Twisted web and an RPC library called Spyne to talk to both sides. I'm using it to send timesheet information to Quickbooks, but if you look over the docs mentioned above:
You can use it to do almost anything. Personally I found this to be much easier than messing with IIF.

Ben Olsen


On Mon, Feb 16, 2015 at 4:27 AM, David Goodenough <dfgoodenough@googlemail.com> wrote:
The interface is COM based, and the documentation comes as part of
the Quickbooks SDK.  The request and response details are available at

https://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.html

but be careful which browser you use to access that, it is the most finicky
site I have ever met - well badly constructed would be a better description.
Their XML is referred to as QBXML.

I have some Java code which uses it, but separating it from the application
may take a little while. But I should be able to answer questions.

I know little of Python, and I do not know if there is a COM bridge for
Python, but if there is it should be possible.

I have only ever run this on a standalone single user version of QB, I have
never tried it on a multi-user server and I have no idea if the interface
even exists on the linux servers.

Be careful when reading up on this as you will find references to both
QBXML and to their REST API.  You may think - REST, I know that, lets use
that instead.  Thing is that that is only for their online version, not the
standalone application.

QBXML has gradually opened up access to the data in QB over the years,
and there are differences between the US and the rest of the world as
to what is released.  But Quickbooks versions are quite good at telling
you what they support.  They tend not to fail catastrophically if you ask them
for something this version does not support.  

David

On Monday 16 February 2015 07:02:51 OpenERP Master wrote:
> Hi,
> I actually did not know this. Originally, I developed a connector that does
> IIF files because that is what the customer wanted. There is also another
> ERP software called MOM (multichannel order manager), that provides this
> exact functionality. I think it may be too late to backtrack, however if
> you would be so kind as to provide a link to some documentation I would
> appreciate it. Even better if you had some Odoo/OpenERP snippets to look
> at. We have 2 potential customers needing this feature and in the United
> States, I hear about this feature all of the time. I would be nice to just
> get this module out of the way. On Sun, Feb 15, 2015 at 4:27 AM, David
> Goodenough < dfgoodenough@googlemail.com [1] > wrote:
> On Sunday 15 February 2015 08:23:22 OpenERP Master wrote:
> > Hello Community,
> > 
> > We have been tasked with developing a quickbooks interface for Odoo 8. We
> > are looking for companies interested in this feature. We would like to
> > make
> > this module generic so it will work for everyone. The module will export
> > journal entries from sales orders/invoices and vendor invoices/payments in
> > the form of an IIF (Quickbooks compatible format) File. AR/AP. Development
> > is already 50% complete. If you are interested please let us know if you
> > would like to contribute to it.
> > 
> > _______________________________________________
> > Mailing-List: https://www.odoo.com/groups/community-59 [2]
> > Post to: mailto: community@mail.odoo.com [3]
> > Unsubscribe: https://www.odoo.com/groups?unsubscribe [4]
> 
> Why are you using IIF, there is a very good XML-RPC API to Quickbooks which
> gives you access (read and write) to most of Quickbooks data. I have used
> this to copy customer and invoice details from a pre-existing invoicing
> system into Quickbooks for some years now.
> David
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59 [5]
> Post to: mailto: community@mail.odoo.com [6]
> Unsubscribe: https://www.odoo.com/groups?unsubscribe [7]
> 
> 
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
> 
> [1] mailto:dfgoodenough@googlemail.com
> [2] https://www.odoo.com/groups/community-59
> [3] mailto:community@mail.odoo.com
> [4] https://www.odoo.com/groups?unsubscribe
> [5] https://www.odoo.com/groups/community-59
> [6] mailto:community@mail.odoo.com
> [7] https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe