Reply
Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

Where?  

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

Where in quickbooks would I find this account number you speak of?

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

@UBNT-Petr

I have some time today to work on it.  Didn't know if you could give me some guidance.

Ubiquiti Employee
Posts: 3,272
Registered: ‎12-10-2015
Kudos: 1158
Solutions: 253

Re: UCRM With Quickbooks online

Unfortunately, I am not familiar with QB, need to ask the team. Does QB have some support which could give you the info?
Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

I have already contacted quickbooks.  They are not sure what number you are referring to (the customer ID,  the number of some income account in particular, etc.)

 

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

Does anyone actually have this plugin working?  If so what number did you utilize for the account number and where did you get it?

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

bump

Ubiquiti Employee
Posts: 3,272
Registered: ‎12-10-2015
Kudos: 1158
Solutions: 253

Re: UCRM With Quickbooks online

@popcorrin this is the only way we found how to find the ID:

1) go to Accounting

2) choose the register you need and click View register

3) use the ID in the URL header bar

 

Additionally, we have just released a new QB Plugin upgrade which shows all available account IDs in the plugin log in case the used ID is incorrect.

 

Selection_976.png

Selection_977.png

New Member
Posts: 25
Registered: ‎05-06-2015
Kudos: 1

Re: UCRM With Quickbooks online

Hi Guys,

 

Thanks for updating the plugin however still getting the below regarind GST not being selected and validation failing, keen to get this workign so i can use it.

 

 

[2018-08-13 10:15:05.480355] [info] Export of invoice ID 20 started.
[2018-08-13 10:15:08.924046] [info] Invoice ID: 20 export failed.
[2018-08-13 10:15:08.924166] [error]  Invoice ID: 20 export failed with error It is not possible to parse QB error: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><IntuitResponse xmlns="http://schema.intuit.com/finance/v3" time="2018-08-13T03:15:08.590-07:00"><Fault type="ValidationFault"><Error code="6000" element=""><Message>A business validation error has occurred while processing your request</Message><Detail>Business Validation Error: Make sure all your transactions have a GST rate before you save.</Detail></Error></Fault></IntuitResponse>.
[2018-08-13 10:15:08.924488] [info] CLI process ended

 

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online


@UBNT-Petr wrote:

@popcorrin this is the only way we found how to find the ID:

1) go to Accounting

2) choose the register you need and click View register

3) use the ID in the URL header bar

 

Additionally, we have just released a new QB Plugin upgrade which shows all available account IDs in the plugin log in case the used ID is incorrect.

 

Selection_976.png

Selection_977.png


I followed your instructions and it doesn't fix anything.  I get the exact same error.

 

 [info] Income account number (57) set in the plugin config does not exist in QB.

Ubiquiti Employee
Posts: 3,272
Registered: ‎12-10-2015
Kudos: 1158
Solutions: 253

Re: UCRM With Quickbooks online

@popcorrin if you use the latest plugin version 1.0.4 you should see this notice - note the numbers mentioned at the end - use of the active account numbers:

Income account number (...) set in the plugin config does not exist in QB or is not active. Active accounts: ...
Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

Tried the latest plugin.   Now I'm not getting any error messages but it doesn't sync anything though.

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

Now I am getting error

[2018-08-14 19:45:11.952337] [error] Account: Getting all Accounts failed with error It is not possible to parse QB error: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<IntuitResponse time="2018-08-14T12:45:11.610-07:00" xmlns="http://schema.intuit.com/finance/v3">
<Fault type="SERVICE">
<Error code="3100">
<Message>message=AuthorizationFailed; errorCode=003100; statusCode=403</Message>
</Error>
</Fault>
</IntuitResponse>

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

I'd really like to get this working but obviously I need some help.  I realize that it is free software but I'd be willing to pay for some support.  

It would be nice if there was a support package that a person could buy so when they had problems there was a channel they could go through.

Ubiquiti Employee
Posts: 3,272
Registered: ‎12-10-2015
Kudos: 1158
Solutions: 253

Re: UCRM With Quickbooks online

Hi, we are preparing one more improvement which will handle some error states. Besides that, please check your plugin configuration as this error "AuthorizationFailed" indicates that your connection / credentials are incorrect.

However, note that we might not be able to solve all the issues and use cases related to this 3rd party tool. You could possibly create a new topic in this UCRM Plugin section: https://community.ubnt.com/t5/UCRM-Plugins/bd-p/UCRMPlugins - to get more users and developers (and even paid developers) involved in this plugin. I assume QB is widely used so it shouldn't be hard to get the support of the community.

Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

I don't think I'm the only one having problems.  I haven't heard from anyone that does actually have it working.

Ubiquiti Employee
Posts: 3,272
Registered: ‎12-10-2015
Kudos: 1158
Solutions: 253

Re: UCRM With Quickbooks online

@popcorrin one more thing. If you recently modified some basic connection parameters in the Plugin, you need to remove the Plugin and add it again to UCRM.

I am sure there are more users of this plugin, it's been one of the top requested features, see https://community.ubnt.com/t5/UCRM-Feature-Requests/idb-p/UCRM-Ideas/tab/most-kudoed
Established Member
Posts: 1,036
Registered: ‎04-30-2009
Kudos: 173
Solutions: 4

Re: UCRM With Quickbooks online

Okay, if I had it working I would be helping others get it working and I know others on this forum do the same.  I just don't see others piping up about how they got it working.  Makes me think that it's not working for most.

Emerging Member
Posts: 57
Registered: ‎02-04-2014
Kudos: 28
Solutions: 1

Re: UCRM With Quickbooks online

Account ID is not the account number. In my case my account number is 4205 but for UCRM the account ID is 80.

 

When you try to sync with your account ID 499XX the log will sort your account list from Quickbooks. Browse the list to find the account log.

 

see my log: you find the account name only not hte account number

 

[2018-08-28 3:28:26.217292] [info] Income account number (4208) set in the plugin config does not exist in QB or is not active. Active accounts:\n Account:Achats ID: 126
Account:Achats - CDS ID: 13
Account:Actif du stock ID: 156
Account:Actif sans catégorie ID: 48
Account:Actions ordinaires ID: 74
Account:Actions privilégiées ID: 75
Account:Amendes et règlements ID: 47
Account:Amortissement informatique ID: 99
Account:Assurance ID: 22
Account:Autres coûts - CDS ID: 12
Account:Banque National ID: 61
Account:BMO ID: 57
Account:Bénéfices non répartis ID: 2
Account:Capital d’ouverture ID: 58
Account:Carte de crédit BMO Prepaye ID: 141
Account:Cellulaire ID: 42
Account:Compte Client ID: 63
Account:Compte clients WHMCS ID: 64
Account:Compte d’attente pour la TPS/TVH - TVQ ID: 56
Account:Comptes fournisseurs (CF) ID: 100
Account:Comptes fournisseurs (CF) - USD ID: 131
Account:Cost of Goods Sold ID: 160
Account:Coût de la main-d’œuvre ID: 153
Account:Coût des marchandises vendues ID: 155

 

 

Emerging Member
Posts: 57
Registered: ‎02-04-2014
Kudos: 28
Solutions: 1

Re: UCRM With Quickbooks online

Did you set your plugginn in Developpement or Production?

Reply