^^^^ Yes, this is similar to the type of functionality we are looking for as well. There are other ERP systems that have built in integration with QB; an automatic sync function.
Here are a few examples of those:
Hi, I am trying to do the same syn doibarr with quickbooks for our accountant.
Can you please guide us with the setup process.
quickbook webconnector is asking for .qwc file (where to get that)
what kind of setup is required in dolibarr for sync process?
waiting for reply.
Thanks.
A .qwc file is a proprietary extension for Quickbook files. Quickbooks has its own schema as well that is very difficult to map with other databases. I ran some testing with a connector called Consolibyte and i was able to successfully connect QB desktop to an online PHP database, but the database had to also be based on the QB schema (same tables, fields, etc.). Since Dolibarr’s database is not the same schema as Quickbooks, it is more difficult to map. You would need to find a developer to customize this for you.
thanks for reply.
I have checked REST API can’t figure out anything.
I used demo script to create qbc file and got connected using SOAP, but its keep on asking to enter password to complete sync process.
where can I get password ?
the help of quickbooks says the password will be provided by web service server which in this case will be dolibarr.
any insight?
tx.
Thanks for quick reply.
Yes I saw that in SOAP and tried to used that as password in Web Connector of Quickbooks but authentication fail error.
You are right I saw REST/API too and found the way for user and password. But the problem is Quickbooks Desktop version only uses web connector to sync and not API.
I am new to Dolibarr so I can’t speak to spefics, but it seems the API interface for Dolibarr is based on REST API (I just saw they have the option for a SOAP one). The way QuickBooks desktop SDK works it via a desktop app (Quickbooks Webconnect). This external application implements the QB SDK via a SOAP API (using qbXML format). The external (to the quickbook application), will make very speific SOAP calls to the SOAP webserver listed in the .QWC file.
[QB]<->[QWC]<via SOAP QXML>[webbased sever]
QWC is setup to call out to the web-based server at defined intervals of time, there is no provision for the webserver to reach out an activate QWC. Thus on the webserver a que used to queue up request for QB to handle when QWC eventually ask for them.
There, fortunately, are many tools out there that have been created to implement a SOAP to REST API server, which means there is a possibility with some work to create an interface.
You can use Consolibyte, you would just need to map the Dolibarr database to the Quickbooks database, which I have been told by developers is very tricky because QB has a lot of sub-tables that need to be taken into account. Are you a developer? Have you tried mapping the tables?
Thanks for your reply.
Not a developer, but can do some troubleshooting… self learning.
Well then I dont see a way ahead with this sync process…
I guess Dolibarr developer should seriously consider developing report printing in Accounting, so that the output will be in standard format of accounting.
I hope developers are reading us.
Thanks.
[color=#0044ff]You can use the QuickBooks mobile app and use sync with your QuickBooks account. You will sign in using the same login credentials. If you are using an iPad, make sure you download the Mobile app and not the QuickBooks Online for iPad app. You will need an online account for that app. Contact Quickbooks cloud hosting support they will help you.