Editing Common SQLink Errors
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== SQLink Error 702 == | == SQLink Error 702 == | ||
− | 702 - 702: The query request has not been fully completed. There was a required element ("800005BC-1267498278") that could not be found in QuickBooks. The element (########-#########) is | + | 702 - 702: The query request has not been fully completed. There was a required element ("800005BC-1267498278") that could not be found in QuickBooks. The element (########-#########) is QB terms for an item; Customer, Vendor, Employee, Inventory, Service, Account, etc... |
The string - ("800005BC-1267498278" - is the QB ID for an item in QB) - means that the item, a customer, invoice, account, service, etc... used to be in QB but it now has a new QB ID or has otherwise been modified in QB. Modifications can include setting the item as inactive, deleting or merging it with another item, etc... To resolve look at all items related to the error and make sure they exist in QB. | The string - ("800005BC-1267498278" - is the QB ID for an item in QB) - means that the item, a customer, invoice, account, service, etc... used to be in QB but it now has a new QB ID or has otherwise been modified in QB. Modifications can include setting the item as inactive, deleting or merging it with another item, etc... To resolve look at all items related to the error and make sure they exist in QB. | ||
− | + | - If it's a customer, make sure the customer is active. | |
− | + | - If it's an invoice it should re-export creating a new QB ID. | |
− | + | - If it's an inventory/service item review them on the invoice and make sure they are all QB items. | |
− | + | - Check SQLink defaults and make sure all accounts on the default tabs in SQLink are present and active in QB. | |
− | + | - Open SQLink> File> Setup> check all tabs and make sure the listed items are active in QB. | |
== SQLink Error 805 == | == SQLink Error 805 == | ||
Line 25: | Line 18: | ||
Need to shorten the address to less than 40 characters. There are tools available online to help you count characters such as http://www.lettercount.com/ | Need to shorten the address to less than 40 characters. There are tools available online to help you count characters such as http://www.lettercount.com/ | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
Line 48: | Line 33: | ||
The other is to place the cursor over the customer and drag it to the new parent. If there are payments, etc.. you will not be able to move the customer. This will also return an error in SQLink since if QB cannot move it then SQLink cannot move it. | The other is to place the cursor over the customer and drag it to the new parent. If there are payments, etc.. you will not be able to move the customer. This will also return an error in SQLink since if QB cannot move it then SQLink cannot move it. | ||
− | These issues are why I recommend 'only' reassigning customers in QuickBooks. | + | These issues are why I recommend 'only' reassigning customers in |
+ | QuickBooks. | ||
− | |||
== SQLink Error 810 == | == SQLink Error 810 == | ||
− | + | 810: There was an error when saving a Invoice. QuickBooks error message: The transaction is empty.<br> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <br> | ||
− | + | it means the invocie was a combined invoice and the order on the invoice was removed or deleted. Go to invoice in SME and either uncheck "export to QB" or delete invoice.<br> | |
− | |||
− | |||
− | |||
− | |||
− | |||
Line 104: | Line 64: | ||
- Check if the record should be tied to a specific customer. If the record has no information you can safely set it as inactive and delete it.<br> | - Check if the record should be tied to a specific customer. If the record has no information you can safely set it as inactive and delete it.<br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Duplicate Customer == | == Duplicate Customer == | ||
Line 120: | Line 72: | ||
You can follow the following steps to resolve the error or watch the video below. | You can follow the following steps to resolve the error or watch the video below. | ||
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
<br>'''Find which customer record is the duplicate''' | <br>'''Find which customer record is the duplicate''' | ||
Line 164: | Line 116: | ||
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
Line 190: | Line 142: | ||
# Run the QBFC7_0Installer. | # Run the QBFC7_0Installer. | ||
− | Also, SQLink and QuickBooks must reference the same path to access the QuickBooks company file. | + | Also, SQLink and QuickBooks must reference the same path to access the QuickBooks company file. to check this: |
# Open QuickBooks. | # Open QuickBooks. | ||
Line 253: | Line 205: | ||
* Remove the 1 from the name and click '''OK'''. | * Remove the 1 from the name and click '''OK'''. | ||
* When asked if you would like to merge the names, click '''Yes'''. | * When asked if you would like to merge the names, click '''Yes'''. | ||
− | <br>5. | + | <br>5. Do this for all items that have the issue from the SME log. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |