QuickBooks Desktop Error Messages

QuickBooks Error: Invalid Argument. The Specified Record Does Not Exist In The List.

Error 3140 : While trying to Add a(n) Invoice with order number of ..., QB responded There is an invalid reference to QuickBooks Item "..." in the Invoice line. QuickBooks error message: Invalid argument. The specified record does not exist...

Description

When attempting to sync an order or transaction to QuickBooks, the following error message is returned to the Connex Transaction Log:

Error 3140 : While trying to Add a(n) Invoice with order number of ..., QB responded There is an invalid reference to QuickBooks Item "..." in the Invoice line. QuickBooks error message: Invalid argument. The specified record does not exist...

Causes

Here are the causes:

  1. You deleted accounts in QuickBooks that Connex uses to make missing items. 
  2. The item exists in QuickBooks, but it is marked inactive. Our tool cannot match inactive items in QuickBooks.

Solutions

Instruct Connex to make no new items

You can map new items to existing ones. If Connex makes products, it usually means you have a mismatch.

Check if accounts exist in QuickBooks

  1. Log into Connex.
  2. Click manage.
  3. Expand orders > sync orders to QuickBooks > new order and product accounts:
  4. Verify that these accounts exist in QuickBooks. If not, choose different ones. If the account is missing from the drop downs, refresh the list.

Check if the item is inactive

  1. In QuickBooks, go to lists > item list.
  2. On the bottom, click inactive.
  3. Ensure there is no X next to the item:
  4. If you see an X, edit the item. Uncheck the inactive field.

Once I fixed the error, what are the next steps?

Run a manual sync. Click log on the left hand side of the page to see results.