Common QuickBooks Online Errors

This article lists some common error messages when exporting from Pallet Connect to Quickbooks online.

Error Loading Account Code - This can be due to Pallet Connect and Quickbooks losing connection. This can happen when more than one Quickbooks admin user connects to Pallet Connect. To fix, disconnect from Quickbooks within Pallet Connect and connect again.

Customer - Duplicate name  QuickBooks does not allow the same contact to be a vendor and a customer, but Pallet Connect does. To handle this you need to set an export code for either sales or purchase so we match the proper name in QuickBooks.

For example, the Customer "ABC Company" might be in QuickBooks as a Customer named "ABC Company", but a Vendor named "ABC Company Ven".  So in Pallet Connect, under the contacts profile, you would setup a Purchases Export Code as "ABC Company Ven". Here is some further help on that:

CLICK HERE FOR ARTICLE

Item - Duplicate Name Exists - The item duplicate is often trying to use an item that has previously been deleted in Quickbooks. To begin, search Quickbooks for that item in "Products and Services". Make sure to have the "show inactive" flag on. If the item is there and inactive, make it active again.

Item - Duplicate Name. The name supplied already exists(Delivery): 

We have a built in Delivery/Collection fee with the export code "Delivery/Collection".If this item has not yet been exported to Quickbooks and hasn't been mapped on our side. Look for an item in Quickbooks with the name "Delivery/Collection"

Make the item inactive in Quickbooks. Here are the steps:

1. From Dashboard -> Hover over "All apps" in left side menu (box with 9 dots)
2. Hover over "Sales & Get Paid" (3rd from top)
3. Click "Products & services (very bottom item in Sales & Get Paid)
4. Search for "Delivery" in the search box
5. Click the checkbox next to the Delivery items
6. Click "Batch Actions" above the table on the right
7. Click Make Inactive

After that is done, you should be able to export to QB from Pallet Connect, which will create a new "Delivery/Collection" Service in QBO and map it to the Pallet Connect item for future exports.

Duplicate Document Number - This simply means the invoice has already been exported and it will not allow it to be sent again. You will need to "Mark as Exported" in Pallet Connect so it no longer shows in the list. See article below for more information:

CLICK HERE FOR ARTICLE

Business Validation Error - The name of the item has some illegal characters or the name is too long. Some illegal characters can be brackets, ampersands and percent signs - (), &, %. You will need to rename this item in Manage Stock.

Automatic emails from Quickbooks: All exported invoices are automatically sent out to customer emails on file, via QB mailer, with a payment link.