Quickbooks synchronization with OpenERP

Quickbooks is one of the leading Accounting application in the Unites States and OpenERP is one of the fastest developing Open Source ERP. An integration or synchronization between these two great applications can be a great mile stone for the users of both applications.
We were successful in synchronizing OpenERP and Quickbooks and would like to summarize our approach and experience. We are expecting that OpenERP is trying to include the Quickbooks integration as part of US localization and will be available with version 6.1.

Anyway at that time of development we were not able to directly connect from OpenERP to Quickbook. So we decided to take a work around. Our solution was to use a PHP application in between OpenERP and Quickbook which can talk to Quickbook.

So our solution include
1. Quick book
2. Quick book Web connector
3. PHP DevKit from consolibyte
4. OpenERP

1. Quick book : Quick books was “QuickBooks Pro” and it should work with other versions also.

2. Quickbook web connector : It was installed and configured on the same machine that runs the Quickbooks. It was configured with full access to QuickBooks file and scheduled to resync in every few minutes with the PHP application. http://marketplace.intuit.com/webconnector/

3. PHP DevKit from consolibyte : It was an independent application which keep data in a mysql DB and keep the data synchronization with Quickbooks using the calls from Webconnector.https://idnforums.intuit.com/messageview.aspx?catid=56&threadid=9164

4. OpenERP : As we have the data in mysql DB it was easy for openerp to connect and keep the data updated. It support two way synchronization.

Goal of the project was to handle the sale order and shipping side from OpenERP and let Quickbook handle the accounting side. We did synchronization of the following objects
1. Partner/customer synchronization : Two way
2. Account list synchronization : QuickBooks to OpenERP
3. Invoice synchronization : OpenERP to QuickBooks

Comments

Anonymous: i have all these things ,but i dont know how to connect all thease".

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Sam says:
    November 11, 2011 at 1:44 pm

    Hi Sinoj – I’m interested in your project, I am looking to sync my OERP with Quickbooks for my accountant. Please get in touch via my email if you can assist.
    Thanks
    Sam

    Reply
    1. Aaron says:
      January 26, 2012 at 2:50 pm

      Hi Sam & Sinoj,
      Could one of you get in touch with me via email? I’m interested in integrating both Quickbooks and OERP as well.
      Thank you,
      Aaron

      Reply
  2. kedar says:
    January 27, 2012 at 3:36 pm

    hi
    im also trying to integrate the quickbook to openerp.but im stuck in importing the items.as items query gives information for stock on hand and on sale order. but i dont no how to integrate this with openerp real and virtual stock.also im putting the quickbook queries to openerp database directly.please help me for integration of quickbook stock to openerp stock

    Reply
  3. Andreas Brueckl says:
    May 10, 2012 at 5:48 pm

    Hello,
    Our company uses OpenERP since about one year. Although OpenERP supports accounting we would like to keep quickbooks for that.
    So we would like to synchronize all OpenERP Invoices to Quickbooks. Therefore I would like you to ask if you can provide me more information about your OpenERP module.
    Regards,
    Andreas

    Reply
  4. Errol says:
    June 7, 2012 at 5:20 am

    Please contact me by email, I am interested in this Quickbooks accounting solution for OpenERP.
    Thanks,
    Errol

    Reply
  5. Gabriel says:
    July 3, 2013 at 11:43 am

    I’m very interested in this module. Was it ever finished?

    Reply
    1. Darci says:
      January 4, 2014 at 11:21 am

      Hi there, I check your new stuff on a regular basis.
      Your story-telling style is witty, keep doing what you’re doing!

      Reply
  6. Anonymous says:
    September 9, 2013 at 12:44 pm

    Hi,
    I tried to install http://marketplace.intuit.com/webconnector/ but got some errors.
    Can you tell me the dependencies of the QuickBooks Connector.
    Thanks

    Reply
  7. Anonymous says:
    May 6, 2014 at 6:19 pm

    i have all these things ,but i dont know how to connect all
    thease

    Reply
© 2020 Zesty Beanz Pvt Ltd All Rights Reserved.