Quickbooks Online: Common Sync Errors

Aaron Aldrich Updated by Aaron Aldrich

How to troubleshoot and fix common errors with Quickbooks Online sync. Occasionally, especially when first setting up and syncing with shopVOX; you will run into some issue that don't quite work with Quickbooks. This can also happen when you create a new Product or add a new material to an existing Product. Once you have these resolved, you shouldn't see errors of the same type in the future.

In this Article

  • Quickbooks::IntuitRequestException:Duplicate Document Number 
  • QuickbooksOnlinePostJob::QBOEmptyQueryResultError
  • Quickbooks::IntuitRequestException: 
  • Query returned zero results:
  • Notice: there was an error posting IN #xxxx to Accounting: Code: 2050

<Quickbooks::IntuitRequestException: Duplicate Document Number Error:>

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

Solution : This error Means there is already an invoice with that number.  If you get this error then you need to to delete the Invoice in QB to export it again. you need to go and add the same name in the Company field and then try to re-import. This happens when you manually create a customer in QB.

<QuickbooksOnlinePostJob::QBOEmptyQueryResultError:>

Select Id, CompanyName From Customer where CompanyName = 'James Stark Trucking Inc.'; returned 0 results>

Solution :  This means there is a customer name in QB but that name is only on the Display Name field and not in the company name it should be in both places

<Quickbooks::IntuitRequestException:>

A business validation error has occurred while processing your request: Business Validation Error: You cannot enter more than 31 characters in the sales_custom_1_val field. You tried entering Somewhere out there CAD and US vinyls, which is 37 characters.

Solution :  If something like this error shows up the reason for this is the Customer PO field has more than 31 characters. Make sure that field has less than 31 chars.

Fix this by reducing the number of characters to be less than 31.

<Query returned zero results:>

Query: Select Id, Name From Account where Name = ''; returned 0 results

Solution : This means one of the line items is a custom item and there is no Custom Item Income and Custom Item COGS in the COA mapping.

<Notice: there was an error posting IN #xxxx to Accounting: Code: 2050>

Type: Validation Fault Detail: String length specified does not match the supported length. Min:0 Max:100 supported. Supplied length:108

Solution :  In QB a line item name only allows 100 chars , so just make sure all the line item names in your transaction is less than 100 chars. 

How helpful was this doc?

How to export customer data from QuickBooks Online

Automatic Sales Tax Rates and QuickBooks Online

Contact