Hi guys,
We tried to utilize ERP Next – QuickBooks connector (GitHub - indictranstech/erpnext_quickbooks) in the custom ERP Next implementation for one of our customers.
We faced some issues per the list below. We tried to integrate it with Quickbooks Online, the US version.
Does anyone face the similar problems with this application? Is there any known workaround for the problems below?
Thank you.
George
P.S. Back to the issues we faced
- App would not connect to a live quickbooks account even after getting production keys
- Is the app production ready or how reliable is the application for importing data?
- On a clean erpnext installation, importing the US Sandbox quickbooks account data failed sync due to “Duplicate data index group” error (detailed example of the error trap provided below)
- On a clean erpnext installation, importing the above data also produced a lot of “Duplicate Data” errors. The database was new and clean
- We noticed the system does not check for existing accounts in the ERP Next’s chart of accounts thus producing duplicates
- We also faced errors when trying to synchronize orders and invoices from Quickbooks online to ERP Next
More specific examples of the error messages we trapped are listed below
#1
This sequence of individual accounts from Quickbooks tries to be mapped to a single account in ERP Next, raising a duplicate data error:
{u’Name’: u’Maintenance and Repair’, u’Classification’: u’Revenue’, u’CurrencyRef’: {u’name’: u’United States Dollar’, u’value’: u’USD’}, u’AccountSubType’: u’OtherPrimaryIncome’, u’sparse’: True, u’AccountType’: u’Income’, u’Active’: True, u’Id’: u’53’}
{u’Name’: u’Maintenance and Repair’, u’Classification’: u’Expense’, u’CurrencyRef’: {u’name’: u’United States Dollar’, u’value’: u’USD’}, u’AccountSubType’: u’RepairMaintenance’, u’sparse’: True, u’AccountType’: u’Expense’, u’Active’: True, u’Id’: u’72’}
{u’Name’: u’Maintenance and Repairs’, u’Classification’: u’Expense’, u’CurrencyRef’: {u’name’: u’United States Dollar’, u’value’: u’USD’}, u’AccountSubType’: u’OtherMiscellaneousServiceCost’, u’sparse’: True, u’AccountType’: u’Expense’, u’Active’: True, u’Id’: u’61’}
2
When tried to synchronize invoices between QB and ERP Next, we trapped the error below
File “/home/zwebmaster/frappe-bench/apps/erpnext_quickbooks/erpnext_quickbooks/sync_orders.py”, line 21, in sync_qb_si_orders
create_order(qb_orders, quickbooks_invoice_list)
File “/home/zwebmaster/frappe-bench/apps/erpnext_quickbooks/erpnext_quickbooks/sync_orders.py”, line 43, in create_order
create_sales_invoice(qb_orders, quickbooks_invoice_list, company=None)
File “/home/zwebmaster/frappe-bench/apps/erpnext_quickbooks/erpnext_quickbooks/sync_orders.py”, line 59, in create_sales_invoice
“taxes”: get_order_taxes(qb_orders)
File “/home/zwebmaster/frappe-bench/apps/erpnext_quickbooks/erpnext_quickbooks/sync_orders.py”, line 93, in get_order_taxes
if not qb_orders[‘GlobalTaxCalculation’] == ‘NotApplicable’:
KeyError: u’GlobalTaxCalculation’