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, QuickBooks 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.
3. The item exists on both sides, but there was a typo / inconsistency between the two

Solutions

Remove colons from your SKUs

Connex assumes that the item exists, if it has a colon. If it is missing, then you must create it. For more info, read this guide.

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. Navigate to the Connex dashboard.
2. Select settings on your connection.
3. Select the menu tab "Chart of 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.