The subsections below will go into more detail regarding some of the more common troubleshooting errors that you might encounter.
Invalid Reference
The error, "Error in executing post to QuickBooks: Invalid Reference Id, Invalid Reference Id: An item in this transaction is set up as a category instead of a product or service" means there is an item is set up as a category instead of as a product or service:
To fix this error, please ensure that the designated item is set up as a product or service instead of as a category.
Invalid Number
The error, "Error in executing post to QuickBooks: Invalid Number Id, Invalid Number: [number here]" means the item is not synced to QuickBooks Online yet.
To fix this error, please ensure that the designated item is synced to QuickBooks separately.
Invalid Email Address Format
The error, "Error in executing post to QuickBooks: Invalid Email Address format, Email Address does not conform to the syntax rules of RFC 822. Supplied value:NO EMAIL - MAIL ONLY" means that the email address was entered incorrectly.
Please ensure that the email address meets with QuickBooks Online's format. The email address used when syncing between QuickBooks and MobiWork can be found in the "Billing" tab of the View Customer pop-up window.
Missing Term
The error, "Error: Could not find in QuickBooks a sales term that matches: "[number here]", PLEASE ADD THE MATCHING SALES TERM IN QuickBooks" means that the matching number is missing in QuickBooks.
To fix this error, please ensure that the number in QuickBooks matches the account number of the desired item, service, etc. in MobiWork.
Vendor ID not Found
When exporting purchase orders and vendors and the following message appears, "Error: Vendor not found QuickBooks with QBOId: #... Something you're trying to use has been made inactive," it means that QuickBooks cannot find the designated external ID that matches that of the vendor.
To fix this error, please ensure that the vendor matches the External ID listed in QuickBooks.
Failed to Execute Entity Query
When trying to create a bill in QuickBooks from a purchase order, and the following message appears, "Failed to execute an entity query: select * from item where active = true and id = ''" it means one of the items does not have an external ID, in other words, it has not been pushed to QuickBooks Online.
To fix this error, please ensure that the item is exported to QuickBooks.
Exporting Payment Error
When trying to export a payment and the following message appears, "Error in executing post to QuickBooks: Unsupported Operation...The entity name must immediately follow the '&' in the entity reference. is not supported," it means that you are trying to export the payment before exporting the invoice.
To fix this error, please export the invoice and then the payment.
Error in executing post to QuickBooks: Invalid Reference ID
The error, "Error in executing post to QuickBooks: Invalid Reference ID, Invalid Reference ID : Product/Service assigned to this transaction has been deleted. Before you can modify this transaction, you must restore Billable to ... (deleted)" occurs because the item, which previously had an external ID (indicating it was synced with QuickBooks Online), has since been deleted in QuickBooks Online. To resolve this issue, please remove the external ID from the item; once the external ID has been removed repush the item, then repush the invoice to QuickBooks Online.
