Common Errors In QuickBooks Export
“Object “x” specified in the request cannot be found. QuickBooks error message: Invalid argument. The specified record does not exist in the list.”
Solution: This indicates that a Customer/Account/Item with the same name is inactive or deleted in QuickBooks. To resolve this, you need to follow the instruction below re-download Accounts and Items from QB to Teapplix:
If you are integrating with QuickBooks Desktop:
- In Teapplix “Integration Setup”, click on the Show Advanced Setting link at the bottom of the page, check the “Re-download accounts and items next time” checkbox. Then, press the “Update QuickBooks Setup” button.
- Run the WebConnector again by pressing “Update Selected” button.
- After that, refresh your QuickBooks Integration Setup page.
If you are integrating with QuickBoosk Online:
In Teapplix “Integration Setup”, click on the Show Advanced Setting link at the bottom of the page, and click on the button "Download initial data from QuickBooks".
QuickBooks error message: There was an error when saving a SalesReceipt. QuickBooks error message: Transaction amount must be positive
Solution: This error happens when we sync one of your Amazon order, because the Amazon fee value is greater than the selling price of your item. So QuickBooks recognizes that it is a negative sale and rejects the order.
Unfortunately QuickBooks does not provide the order id with this issue. But this error is not a blocking error, so your good orders will still be synced to QuickBooks. And eventually only the order with this issue is left in the Unexported Orders page. Then you can click on the Update action link for that order and adjust the Amazon fee value.
QuickBooks error message: The currency of the account must be either in home currency or the transaction currency.
Solution: This error happens mostly because you have orders in non-US currency (such CAD for Canada, EUR for Europe, and GBP for British). When you export these orders, QuickBooks requires the Accounts associate with them to be the same as the Customer. If you choose to have Teapplix creates the customer, we will create it with the same currency as the order. So you need to setup the Account also using the same currency as the order. Please first enable multi-currency in your QuickBooks, and then make sure each individule account is set up with the right currency.
The given object ID "" in the field "list id" is invalid.
Solution: This error means we failed to export some orders because they are not in US currency, most likely you are using an integrated Amazon account selling in both US and Canada, or you have just added a new foreign Amazon account
Please make sure the following:
Turn on Multi currency in your QB and add the new foreign currency. Create one Account and one Customer in QB to be used for those foreign orders, and make sure they all use the same foreign currency.
Redownload QB accounts and items to Teapplix.
On Integration Setup page, pick the right Account and Customer you just setup in QB for those foreign Amazon orders .
QuickBooks found an error when parsing the provided XML text stream.
Solution: Amazon now supports one integrated account (in US), but used to also sell to Canada. So even though you only have one US Amazon account, there will be orders with Canada currency. Please make sure you turn on multi-currency in your QuickBooks and setup separate Account and Customer (both with Canada currency) for Amazon Canada orders. On the Integration Setup page, select the corresponding Accounts and Customers to ensure Canada orders being successfully exported.
WebConnector Run Without Error but No Orders Are Exported to QuickBooks
I. First find out if your orders are downloaded to Teapplix from your Marketplaces:
Login to your Teapplix account, go to QuickBooks->Unexported Orders to check if there are any orders unexported. If there is no new orders unexported, it could mean your Marketplace order download is not working properly. It could be due to the delay of the backend process, you can do a manual sync for that Marketplace to force order download.
II. If there are unexported orders, which means the orders were downloaded from your Marketplace successfully. But not exported to your QuickBooks. It could be due to the following reason:
a). Item Mapping is not done for those order items (if you configured to "skip orders with no matching inventory" on the Integration Setup page).
b). The orders are downloaded from Amazon FBA, but since the Amazon fee can only be obtained from the every-two-weeks FBA settlement report, those orders won't be reconciled until the Settlement Report is received. So if you have configured to export the order with Amazon fee, those orders will not be exported until they are reconciled.
c). Due to the error encountered during the export. You can login to your Teapplix account, go to QuickBooks->SystemLog to check if there is an error log. Refer to the corresponding solutions for each error message below.
III. Check if there are orders noted with “attempted export: timestamp”, for each of such order, examine your QuickBooks to see if it has actually exported to your QuickBooks.
a). If it is already in your QuickBooks, select that order and click “Mark As Already Exported”.
b). If it is not yet in your QuickBooks, select that order and click “Export Again”.
Once you have reviewed every order, run the Web Connector again.
I have defined "Shipping and Handling" in my QuickBooks and loaded to Teapplix, but it does not show up in the list
Solution: Make sure to define the "Shipping and Handling" item as "Other Charges" in your QuickBooks.
If you have that and the dropdown is still empty in Teapplix, you need to check "re-download accounts and items", then run web connector again and make sure no errors occurred during the run. Verify afterwards by refreshing Teapplix Integration Setup page, and make sure the shipping and handling dropdown contain your items.
There is an invalid reference to QuickBooks Customer “xxxx” in the SalesReceipt. QuickBooks error message: Invalid argument. The specified record does not exist in the list.
Solution: If you choose the option to"Create one per order" for the Customers on the Integration Setup page, please be aware that QuickBooks (non Enterprise version) has a limit of maximum number of 14500 Customers total and each Customer length can not be longer than 31 characters. In order to check if you have hit that limit, you can try to first manually create this named Customer in your QuickBooks. If you have hit that limit, you have to either upgrade to Enterprise version or remove some of your existing Customers.
If you choose the option to use "One Customer Per Marketplace", this error indicates that the “customer” you selected for your marketplace is inactive or deleted in QuickBooks. You need to perform the same steps as above to Re-download accounts and items.
I configured to "Use default item for all sales" on the Integration Setup page, but I am still getting unmapped items error during Export
Solution: For certain items in an order, we always require you to map it, such as "Discount Item" which has a negative value in price.
I can search an order on the Order History page that is not exported to QuickBooks, but that order does not show up on the Unexported Orders page
Solution: There could be a few reasons why an order not in QuickBooks is not showing in the Unexported Orders page
- The order is for a Return label. Normally the order id would start with RET-xxx. Order used for return label won't export to QuickBooks.
- The order is a split order of an original order. Normally the order id should start with RT-xxx. The original order will be exported to QuickBooks including all order items. So the split order won't be exported to QuickBooks.
- If you specify the Start Export Date on the QuickBooks->Integration Setup page, the orders older than that date won't export to QuickBooks.
QuickBooks Sync Error: Failed to save SalesReceipt QuickBooks error message: There is an account missing in one or more items used in the transaction detail lines.
Solution: This error is not a blocking error. It will first finish the sync for all the remaining orders. at the end the order causing the error will be left in the Unexported Orders page. Find out that order's SKU, find it in your QuickBooks, and make sure it is a sellable item with an account associate with it. If it is a parent item that is not sellable, you need to redo the mapping for that order's item name and map it to a child item that is sellable (with an account in QuickBooks).
There was an error when saving a SalesOrder. QuickBooks error message: QuickBooks error message: Error: could not load string. Check status. (error code 3180)
Solution: When you get this error, try to create a sales receipt by hand with this item. You may have created a mandatory custom field on the item. Teapplix software does not populate any custom fields when creating sales receipts or sales orders.
QuickBooks Integration: call SalesOrderRet returned error 3270: Missing posting account.
Solution: When you get this error, please make sure a sales order can be created in your QuickBooks successfully. You can try create a sales Order by hand with this item, to see if there are missing configurations in your QuickBooks.
If your inventory option is set to “Create inventory part as needed” and you get the following error: QuickBooks Integration: call ItemQuery returned error 3100: The name “x” of the list element is already in use.
Solution: Same as above to Re-download accounts and items.
The name "Amazon Canada" of the list element is already in use
Solution: This indicates that the bank account "Amazon Canada" has already been created in your QuickBooks, but not configured to be used in Teapplix. So Teapplix will try to create it again in QuickBooks when you sync. You need to perform the same above action to Re-download accounts and items. Change your QuickBooks Integration setup for Amazon Canada Bank Account.
Other Possible Cause of Export Failure
1). Foreign currency not turned on.
2). There is no QuickBooks inventory item mapped to the order item name.
3). Your QuickBooks company file name contains special character such as "&".