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