Reply
Emerging Member
Posts: 63
Registered: ‎02-04-2014
Kudos: 38
Solutions: 2

Re: UCRM With Quickbooks online

Sans titre.png

Emerging Member
Posts: 63
Registered: ‎02-04-2014
Kudos: 38
Solutions: 2

Re: UCRM With Quickbooks online

 

 

Member
Posts: 257
Registered: ‎01-18-2017
Kudos: 87
Solutions: 11

Re: UCRM With Quickbooks online

[ Edited ]

Tried installing today. For some reason I am getting this error:

 

[error] Error for request https://app.ourdomain.com/api/v1.0/clients. Curl error 7: Failed to connect to app.ourdomain.com port 443: Operation timed out

 

I am able to ping the machine from a shell on the machine. (app.ourdomain.com is a placeholder, the correct machine name is in the real error message)

Member
Posts: 257
Registered: ‎01-18-2017
Kudos: 87
Solutions: 11

Re: UCRM With Quickbooks online

Additionally I am getting this error now. I believe I followed the installation instructions and I double checked that I followed the readme....

Ubiquiti Employee
Posts: 3,511
Registered: ‎12-10-2015
Kudos: 1248
Solutions: 271

Re: UCRM With Quickbooks online

@synertic It seems that some more implementation might be needed for some countries. QB requires to push tax values along with the services. Please open a new topic for developers in the Plugin forum: https://community.ubnt.com/t5/UCRM-Plugins/bd-p/UCRMPlugins

@clarkraymond is your UCRM server using HTTPS correctly? Please check the ports and SSL used in the System > Settings.
Member
Posts: 257
Registered: ‎01-18-2017
Kudos: 87
Solutions: 11

Re: UCRM With Quickbooks online

I am able to issue the curl request from the command line with no problem
Member
Posts: 257
Registered: ‎01-18-2017
Kudos: 87
Solutions: 11

Re: UCRM With Quickbooks online

The time stamp in the plugin log is off by 6 hours. Time zone is set within UCRM to mountain time
Emerging Member
Posts: 63
Registered: ‎02-04-2014
Kudos: 38
Solutions: 2

Re: UCRM With Quickbooks online

Hi Clark, the time on logs are alway show usong the server time and date. Habitualy you always set the server with the time zone UTC 0 and after you set you real time zone in your applications.
Member
Posts: 257
Registered: ‎01-18-2017
Kudos: 87
Solutions: 11

Re: UCRM With Quickbooks online

[ Edited ]

When manually issuing the curl command from within the docker it cannot connect. When issuing the curl command from the host machine there is no problem.

 

So the container cannot reach out:

* Trying xxx.xxx.xxx.xxx...
* TCP_NODELAY set
* connect to xx.xx.xx.xx port 443 failed: Operation timed out
* Failed to connect to ucrm.xxx.xxx port 443: Operation timed out
* Closing connection 0

Ubiquiti Employee
Posts: 3,511
Registered: ‎12-10-2015
Kudos: 1248
Solutions: 271

Re: UCRM With Quickbooks online

Member
Posts: 257
Registered: ‎01-18-2017
Kudos: 87
Solutions: 11

Re: UCRM With Quickbooks online

Thanks Petr, I cannot successfully execute the curl command manually from within the docker. Turns out it is a firewall issue on the host box. Don't have it solved yet, but the OS guy will be back tomorrow and I am sure he will fix it.

 

Member
Posts: 257
Registered: ‎01-18-2017
Kudos: 87
Solutions: 11

Re: UCRM With Quickbooks online

We had to add an item to /etc/hosts for the ucrm server to make this work.

Highlighted
New Member
Posts: 20
Registered: ‎08-21-2017

Re: UCRM With Quickbooks online

hello I followed the instructions on GitHub and got as far as this: (I do have my Income account number under the plugin settings as 4000)

 

[2018-11-26 23:46:01.285049] [info] CLI process started
[2018-11-26 23:46:01.294529] [notice] Authorization URL: https://appcenter.intuit.com/connect/oauth2?client_id=Q0BsH3zQsKXoWvbugkOIuDzGEKKrEI5IedSa2m4iCFQbg7...
[2018-11-26 23:46:01.294801] [info] CLI process ended
[2018-11-26 23:46:27.084223] [notice] Authorization Code obtained.
[2018-11-26 23:47:01.239765] [info] CLI process started
[2018-11-26 23:47:01.613523] [notice] Exchange Authorization Code for Access Token succeeded.
[2018-11-26 23:47:04.038516] [info] Income account numbers in QBO Active accounts:\n Account:Accounts Payable (A/P) ID: 33
Account:Accounts Receivable (A/R) ID: 84
Account:Advertising ID: 7
Account:Arizona Dept. of Revenue Payable ID: 89
Account:Automobile ID: 55
Account:Fuel ID: 56
Account:Bank Charges ID: 8
Account:Billable Expense Income ID: 85
Account:Board of Equalization Payable ID: 90
Account:Checking ID: 35
Account:Commissions & fees ID: 9
Account:Cost of Goods Sold ID: 80
AccountMan Very Happyepreciation ID: 40
AccountMan Very Happyesign income ID: 82
AccountMan Very Happyiscounts given ID: 86
AccountMan Very Happyisposal Fees ID: 28
AccountMan Very Happyues & Subscriptions ID: 10
Account:Equipment Rental ID: 29
Account:Fees Billed ID: 5
Account:Insurance ID: 11
Account:Workers Compensation ID: 57
Account:Interest Earned ID: 25
Account:Inventory Asset ID: 81
Account:Job Expenses ID: 58
Account:Cost of Labor ID: 59
Account:Installation ID: 60
Account:Maintenance and Repairs ID: 61
Account:Equipment Rental ID: 62
Account:Job Materials ID: 63
AccountMan Very Happyecks and Patios ID: 64
Account:Fountain and Garden Lighting ID: 65
AccountMan Tonguelants and Soil ID: 66
AccountMan Frustratedprinklers and Drip Systems ID: 67
AccountMan Tongueermits ID: 68
Account:Landscaping Services ID: 45
Account:Job Materials ID: 46
AccountMan Very Happyecks and Patios ID: 47
Account:Fountains and Garden Lighting ID: 48
AccountMan Tonguelants and Soil ID: 49
AccountMan Frustratedprinklers and Drip Systems ID: 50
Account:Labor ID: 51
Account:Installation ID: 52
Account:Maintenance and Repair ID: 53
Account:Legal & Professional Fees ID: 12
Account:Accounting ID: 69
Account:Bookkeeper ID: 70
Account:Lawyer ID: 71
Account:Loan Payable ID: 43
Account:Maintenance and Repair ID: 72
Account:Building Repairs ID: 73
Account:Computer Repairs ID: 74
Account:Equipment Repairs ID: 75
Account:Mastercard ID: 41
Account:Meals and Entertainment ID: 13
Account:Miscellaneous ID: 14
Account:Notes Payable ID: 44
AccountMan Surprisedffice Expenses ID: 15
AccountMan Surprisedpening Balance Equity ID: 34
AccountMan Surprisedther Income ID: 83
AccountMan Surprisedther Portfolio Income ID: 26
AccountMan Tongueenalties & Settlements ID: 27
AccountMan Tongueest Control Services ID: 54
AccountMan Tonguerepaid Expenses ID: 3
AccountMan Tongueromotional ID: 16
AccountMan Tongueurchases ID: 78
Account:Refunds-Allowances ID: 6
Account:Rent or Lease ID: 17
Account:Retained Earnings ID: 2
AccountMan Frustratedales of Product Income ID: 79
AccountMan Frustratedavings ID: 36
AccountMan Frustratedervices ID: 1
AccountMan Frustratedtationery & Printing ID: 19
AccountMan Frustratedupplies ID: 20
Account:Taxes & Licenses ID: 21
Account:Travel ID: 22
Account:Travel Meals ID: 23
Account:Truck ID: 37
AccountMan Very Happyepreciation ID: 39
AccountMan Surprisedriginal Cost ID: 38
Account:Unapplied Cash Bill Payment Expense ID: 88
Account:Unapplied Cash Payment Income ID: 87
Account:Uncategorized Asset ID: 32
Account:Uncategorized Expense ID: 31
Account:Uncategorized Income ID: 30
Account:Undeposited Funds ID: 4
Account:Utilities ID: 24
Account:Gas and Electric ID: 76
Account:Telephone ID: 77
Account:Visa ID: 42

[2018-11-26 23:47:04.038628] [info] CLI process ended

 

but when I try and run the plugin again i get these errors:

 

[2018-11-26 23:51:01.262463] [info] CLI process started
[2018-11-26 23:51:11.722707] [info] Income account number (4000) set in the plugin config does not exist in QB or is not active. Active accounts:\n Account:Accounts Payable (A/P) ID: 33
Account:Accounts Receivable (A/R) ID: 84
Account:Advertising ID: 7
Account:Arizona Dept. of Revenue Payable ID: 89
Account:Automobile ID: 55
Account:Fuel ID: 56
Account:Bank Charges ID: 8
Account:Billable Expense Income ID: 85
Account:Board of Equalization Payable ID: 90
Account:Checking ID: 35
Account:Commissions & fees ID: 9
Account:Cost of Goods Sold ID: 80
AccountMan Very Happyepreciation ID: 40
AccountMan Very Happyesign income ID: 82
AccountMan Very Happyiscounts given ID: 86
AccountMan Very Happyisposal Fees ID: 28
AccountMan Very Happyues & Subscriptions ID: 10
Account:Equipment Rental ID: 29
Account:Fees Billed ID: 5
Account:Insurance ID: 11
Account:Workers Compensation ID: 57
Account:Interest Earned ID: 25
Account:Inventory Asset ID: 81
Account:Job Expenses ID: 58
Account:Cost of Labor ID: 59
Account:Installation ID: 60
Account:Maintenance and Repairs ID: 61
Account:Equipment Rental ID: 62
Account:Job Materials ID: 63
AccountMan Very Happyecks and Patios ID: 64
Account:Fountain and Garden Lighting ID: 65
AccountMan Tonguelants and Soil ID: 66
AccountMan Frustratedprinklers and Drip Systems ID: 67
AccountMan Tongueermits ID: 68
Account:Landscaping Services ID: 45
Account:Job Materials ID: 46
AccountMan Very Happyecks and Patios ID: 47
Account:Fountains and Garden Lighting ID: 48
AccountMan Tonguelants and Soil ID: 49
AccountMan Frustratedprinklers and Drip Systems ID: 50
Account:Labor ID: 51
Account:Installation ID: 52
Account:Maintenance and Repair ID: 53
Account:Legal & Professional Fees ID: 12
Account:Accounting ID: 69
Account:Bookkeeper ID: 70
Account:Lawyer ID: 71
Account:Loan Payable ID: 43
Account:Maintenance and Repair ID: 72
Account:Building Repairs ID: 73
Account:Computer Repairs ID: 74
Account:Equipment Repairs ID: 75
Account:Mastercard ID: 41
Account:Meals and Entertainment ID: 13
Account:Miscellaneous ID: 14
Account:Notes Payable ID: 44
AccountMan Surprisedffice Expenses ID: 15
AccountMan Surprisedpening Balance Equity ID: 34
AccountMan Surprisedther Income ID: 83
AccountMan Surprisedther Portfolio Income ID: 26
AccountMan Tongueenalties & Settlements ID: 27
AccountMan Tongueest Control Services ID: 54
AccountMan Tonguerepaid Expenses ID: 3
AccountMan Tongueromotional ID: 16
AccountMan Tongueurchases ID: 78
Account:Refunds-Allowances ID: 6
Account:Rent or Lease ID: 17
Account:Retained Earnings ID: 2
AccountMan Frustratedales of Product Income ID: 79
AccountMan Frustratedavings ID: 36
AccountMan Frustratedervices ID: 1
AccountMan Frustratedtationery & Printing ID: 19
AccountMan Frustratedupplies ID: 20
Account:Taxes & Licenses ID: 21
Account:Travel ID: 22
Account:Travel Meals ID: 23
Account:Truck ID: 37
AccountMan Very Happyepreciation ID: 39
AccountMan Surprisedriginal Cost ID: 38
Account:Unapplied Cash Bill Payment Expense ID: 88
Account:Unapplied Cash Payment Income ID: 87
Account:Uncategorized Asset ID: 32
Account:Uncategorized Expense ID: 31
Account:Uncategorized Income ID: 30
Account:Undeposited Funds ID: 4
Account:Utilities ID: 24
Account:Gas and Electric ID: 76
Account:Telephone ID: 77
Account:Visa ID: 42
[2018-11-26 23:51:44.858133] [error] Client with Display name containing: UCRMID-80724578 is not found
[2018-11-26 23:51:44.858230] [info] Payment ID: 73 needs to be exported
[2018-11-26 23:51:45.141311] [error] Client with Display name containing: UCRMID-80724584 is not found
[2018-11-26 23:51:45.141556] [info] CLI process ended

 

Can anyone help me with what I am doing wrong?

Reply