QuickBooks Online error logs

Occasionally, TradeGecko may encounter difficulties when syncing data to your QuickBooks Online account. To help you identify the cause, TradeGecko lists each error within the integration error log. 

To view your Error Logs, navigate to Integrations on the left-side of your TradeGecko dashboard.

From Integrations, under the listing for QuickBooks, click on the option marked 'Logs’.

error.png

This will take you to the Log page. Successfully synced items as well as errors will be displayed. To view only errors, select the Only Show Logs With Errors option in the upper right corner.

On this page, you can perform the following actions:

1) Filtering - you can check on the top header to show only error logs.
2) Export logs via the button on the top right-hand corner of the page.
3) Search - Pull out logs of certain invoices or purchase orders by typing it into the search bar.
4) Bulk retry - Check to multi-select some of the logs and retry them in bulk via the bulk actions dropdown.

Note
Occasionally, TradeGecko needs to re-authenticate it's connection to the QuickBooks Online platform. This is completely normal and nothing to worry about. 
If needed, TradeGecko will prompt you to re-authenticate when accessing any section of the QuickBooks integration. Once re-authenticated, you can select the Retry option associated with any errors to sync them to QuickBooks.

The following table lists common types of errors you may come across in your Error Log as well some suggestions on how to resolve them;

  • Message refers to the error you will see in your QuickBooks Online error log.
  • Action is what we suggest you do to fix the error. 

No.

Message

Action

1

Your bill number or invoice number is too long. QuickBooks Online only allows 21 characters

The invoice sync failed as phone number entered in the associated sales order has 21 or more characters. To fix the issue, edit the order to ensure that the phone number is less than 21 characters. will not be more than 21. 

2

The listed transaction has negative total.

QuickBooks Online does not accept negative values. If the customer wanted to remove the line item we suggest cloning the sales order and removing the line item from the cloned sales order, then voiding the original order.

3

A business validation error has occurred while processing your request: Business Validation Error: Make sure all your transactions have a sales tax rate before you save.

Check if each line item in the sales order has correct tax type and if that tax type is mapped to the correct tax code in QuickBooks Online through the integration Tax Types settings.

4

The customer or vendor listed in this order has different currency setup in QuickBooks.

The customer or vendor in QuickBooks Online is using different currency that  the TradeGecko invoice. To resolve the issue, create a different vendor in QuickBooks Online that uses the same currency as the TradeGecko Invoice.

5

The invoice was already deleted in TradeGecko before the credit note sync runs.

This happens if you have deleted an invoice before the credit note synced to QBO. 
As the invoice no longer exists, you can safely delete this log.

6

A business validation error has occurred while processing your request: Business Validation Error: You cannot enter more than 21 characters in the doc_num field. You tried entering Paid credit #12345 for exclusive, which is 32 characters.

QBO does not accept more that 21 characters. To resolve the issue edit the doc_num field and ensure to have only 21 characters then retry the sync.

7

Error: Duplicate Document Number Error: Duplicate Document Number Error: You must specify a different number. This number has already been used.

QBO requires unique Invoice numbers. To resolve the issue, you can either rename the Invoice, or find the already-existing "duplicate" Invoice in QBO and delete it.

8

Invoice has been deleted in QuickBooks Online and the object is modified in TradeGecko. Modifying a deleted object in QuickBooks Online is not possible.

Simply ignore the error because the invoice you are trying to edit has already been deleted. If you would like to resync this invoice, you may have to reinvoice it again.

9

A business validation error has occurred while processing your request: Business Validation Error: Make sure all your transactions have a GST/HST rate before you save.

Ensure that the taxes used have mapped to the corresponding taxes in QuickBooks Online. You can check the mappings through the Tax Types section of the QuickBooks Online integration within TradeGecko.

10

The product name already exists in your QuickBooks Online account.

This error is usually associated with the customer's name having the same entry in QuickBooks Online. QBO has a limitation that requires each customer to have a unique name. For example, In QBO there's a customer named Customer A, if another Customer A is be synced from TradeGecko, QBO will not allow it. To resolve, edit one of the names to make it unique. 

11

Invalid Reference Id: Invalid Reference Id : Something you're trying to use has been made inactive. Check the fields with accounts, customers, items, vendors or employees.

The error is referring to the accounts, customers, items, vendors or employees that have been archived in QuickBooks Online. To rectify the issue kindly check if it has been deleted/archived if yes, then you have to unarchive then retry the sync in TradeGecko. 

12

Invoice INV1234 already exists in your Quickbooks account

It is possible that an invoice is already using this number in QBO. You can either rename that invoice in QuickBooks Online or rename the one in TradeGecko.

13

String length is either shorter or longer than supported by specification: String length specified does not match the supported length. Min:0 Max:21 supported. Supplied length:28

The error refers to the 21 characters used on the phone number field on your sales order. To fix, edit the phone number and ensure to have 21 characters and resync the invoice.

14

Invoice can't be created because VARIANT A has been removed from your QuickBooks account.

The error occurs when VARIANT A in PRODUCT A was linked to a variant in QBO which has been deleted. You'll need to restore the variant in QuickBooks Online before the Invoice can sync.

15

One of the line items in your invoice does not have tax type

Check if the all line items added to the associated order have the correct tax type and ensure that the tax type used is mapped to a QuickBooks Online tax type through the Tax Types section of the QuickBooks Online integration within TradeGecko.

16

A business validation error has occurred while processing your request: Business Validation Error: We are sorry, QuickBooks encountered an error while calculating tax. Try reselecting the tax rate or reentering the product/service item and saving the form again. <a href='https://support.qbo.intuit.com/support/help-article.cfm?faq_id=5558&locale=en_HK' target="_blank" title="Help">Please click here for more information</a>

It refers to the tax code which has been correctly mapped to the QBO tax code.

17

HTTP Error Code: 429, Msg: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <IntuitResponse time="2017-04-06T21:12:10.750-07:00" xmlns="http://schema.intuit.com/finance/v3"> <Fault type="SERVICE"> <Error code="3001"> <Message>message=ThrottleExceeded; errorCode=003001; statusCode=429</Message> </Error> </Fault> </IntuitResponse>

The error message is due to a time-out issue, specifically if the customer hit QuickBooks rate limit. This happens when there's too many transaction being pushed to the QuickBooks service which exceeds the amount of transactions they allow on their API. Choosing the retry option associated with these errors will cause TradeGecko to attempt the sync again.

18

Invalid account type used: Invalid account type: For a stock product, the expense account must have Account Type: 'Cost of Sales' and Detail Type: 'Supplies.'

Product Type in QuickBooks Online is set to "Inventory" instead of "Service". To fix the issue, you will need to change it to Service in your QuickBooks account. If you are unsure of how to change the product type in QuickBooks, please reach out to QuickBooks support for further assistance.

19

Your Payment account setting is incorrect

The error occurs when the payment method used in the TradeGecko sales order is not properly mapped to a QuickBooks Online ledger account. Once the payment has been properly mapped through the QuickBooks Online Payment Methods section of the QuickBooks Online integration within TradeGecko, you can retry to sync the payment.

20

The error: Invalid Reference Id: Invalid Reference Id : One of the list elements assigned to this transaction has been deleted. Before you can modify this transaction, you must restore TradeGecko Non-Product (deleted).

The error occurs when you have a line item in the Sales Order that is a product/freeform line items in TradeGecko but the product/freeform line items is deleted in QuickBooks. To resolve the issue, provide the affected invoice number and we will escalate it to our Engineer for further assistance.

 

Caution
Resolving each of the issues detailed above will not always trigger TradeGecko to automatically resync an affected Invoice to your QuickBooks Online account.
If not, the error will remain listed in the error log. You'll need to select Retry next to each of the affected errors to trigger the re-sync.

 

Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF
Have more questions? Submit a request
Was this article helpful?
0 out of 0 found this helpful

Comments

NEW TO TRADEGECKO? START A 14 DAY FREE TRIAL, NO CREDIT CARD REQUIRED