Common Errors In QuickBooks Export
QuickBooks error message: The currency of the account must be either in home currency or the transaction currency.
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.
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.
Amazon now supports one integrated account (in US), but used to also sell to Canada. So even though you only have one US Amaozn 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. And on the Integration Setup page, select the correcponding 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 Teappix from your Marketplaces:
Login to your Teapplix account, and 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 error encounted during export. You can login to your Teapplix account, and go to QuickBooks->SystemLog to check if there is any error log. And you can refer to the corresponding solutions for each error messaegs below.
III. Check if there are orders noted with “attempted export: timestamp”, for each of such order, exam your QuickBooks to see if it has actually exported to your QuickBooks.
a).If it is already in your QuickBooks, please select that order and click on “Mark As Already Exported” button.
b). If it is not yet in your QuickBooks, please select that order and click on “Export Again” button.
Once you reviewed every orders, run the Web Connector again.
“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 an item with the same name is inactive or deleted in QuickBooks. To resolve this, you need to do the following:
- In Teapplix “Integration Setup”, Open Advanced Sync options, 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, and make any changes if needed, make sure to uncheck the “Re-download accounts and items next time” checkbox. Once you make the change, you may need to run Web Connector again to export remaining orders.
I have defined "Shipping and Handling" in my QuickBooks and loaded to Teapplix, but it does not show up in the list
Solution: Please make sure you defined 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", and run web connector again and make sure no errors occur during the run. Verify afterwards by refreshing Teapplix Integration Setup page, and make sure the shipping and handling dropdown contain your items.
QuickBooks Sync Error: Can not find Customer "XXX"
Solution: If you have chosen "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.
I configued 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 reason why an order not in QuickBooks is not showing in the Unexported Orders page
- The order is for an Return label. Normall the order id would start with RET-xxx. Order used for return label won't export to QuickBooks.
- The order is a plitted order of an original order. Normall the order id shoudl start with RT-xxx. The original order will be exported to QuickBooks including all order items. So the splitted order won't export to QuickBooks.
- If you specify the Start Export Date on the QuickBooks->Integration Setup page, the orders orders 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. So first finish sync for all the remaining orders. And at 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 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.
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: This 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.
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. And change your QuickBooks Integration setup for Amazon Canada Bank Acocunt.
Other Possible Cause of Export Failure
1). Foreign currency not turned on.
2). There is no QuickBok inventory item mapped to the order item name.
3). Your Quickbooks company file name contains special character such as "&".