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
i have all these things ,but
i have all these things ,but i dont know how to connect all
thease
Hi, I tried to install
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
I'm very interested in this
I'm very interested in this module. Was it ever finished?
Hi there, I check your new
Hi there, I check your new stuff on a regular basis.
Your story-telling style is witty, keep doing what you're doing!
Please contact me by email, I
Please contact me by email, I am interested in this Quickbooks accounting solution for OpenERP.
Thanks,
Errol
Hello, Our company uses
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
hi im also trying to
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
Hi Sinoj - I'm interested in
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
Hi Sam & Sinoj, Could one of
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