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: | ||
− | == | + | == Error including a string of numbers “########-##########” == |
− | + | ||
− | + | The “########-##########” string of numbers refers to the QuickBooks list UID for the referenced item in the error. Any time you see that string in relation to an error, you will need to locate what item that number is referring to by adding the appropriate QB list ID field to a view so you can search on the string and locate the offending item. SME pulls the string from QB when an item is synced.<br> | |
− | [[File: | + | |
+ | The following is a list of QB list ID’s for the various modules. Setup your search view in each module to include this column so you can locate the offending item in the syncing error you received:<br> | ||
+ | Customer - CustID<br> | ||
+ | Invoice - InvoiceID<br> | ||
+ | Vendor - VendorID<br> | ||
+ | Inventory - InventoryID<br> | ||
+ | Service Item - ServiceID<br> | ||
+ | Employee - EmployeeID<br> | ||
+ | |||
+ | Usually for all SME modules there will be an item/column with <name>ID which holds the QB list UID. | ||
+ | |||
+ | '''To include the QuickBooks ID number in the search window:'''<br> | ||
+ | 1. In the search window, click '''Views''' > '''Add remove fields'''<br> | ||
+ | 2. In the window that opens, check the QuickBooks ID field for that module (list above)<br> | ||
+ | 3. Click '''OK'''.<br> | ||
+ | 4. Click '''View''' > '''Save View'''. Name the field and Click '''OK'''.<br> | ||
+ | For more information about search views, go to [[Search Window]]<br><br> | ||
+ | |||
+ | '''Example Error:'''<br> | ||
+ | Error adding Bill10506 | ||
+ | 807: Object "80000016-308248122" specified in the request cannot be found. QuickBooks error message: Invalid argument. The specified record does not exist in the list.<br> | ||
+ | '''Solution:'''<br> | ||
+ | The numbers “80000016-308248122” are referring to an inventory item that QB says no longer exists in QB. It may be inactive, deleted, or related to the inactive parent. You can research it as noted above and shown below in the screenshot. | ||
+ | |||
+ | [[File:InventoryID_SearchView.png]] | ||
+ | |||
== 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 | + | 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 string - ("800005BC-1267498278" | + | The string - ("800005BC-1267498278") - means that this customer used to be in QB but it now has a new CustID. We do not know how this happens and sometimes QB will accept it and sometimes you have to change the name to sync it. |
− | |||
− | |||
− | |||
− | |||
− | |||
== SQLink Error 805 == | == SQLink Error 805 == | ||
Line 25: | Line 45: | ||
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 60: | ||
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 | + | These issues are why I recommend 'only' reassigning customers in |
− | + | QuickBooks. | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Duplicate Customer == | == Duplicate Customer == | ||
Line 118: | Line 68: | ||
'''Customer : XYZ is skipped due to duplication''' | '''Customer : XYZ is skipped due to duplication''' | ||
− | You can follow the following steps to resolve the error or watch the | + | You can follow the following steps to resolve the error or watch the viceo below. |
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
<br>'''Find which customer record is the duplicate''' | <br>'''Find which customer record is the duplicate''' | ||
Line 155: | Line 105: | ||
# Go to the '''"DUP"''' customer. | # Go to the '''"DUP"''' customer. | ||
# Click '''Delete''' to delete the customer record. | # Click '''Delete''' to delete the customer record. | ||
+ | |||
== Customer Link ID not initialized == | == Customer Link ID not initialized == | ||
Line 164: | Line 115: | ||
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
Line 190: | Line 141: | ||
# 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 214: | Line 165: | ||
Both ListID and the Name are unique keys in QuickBooks. And you modified a customer which prompts to export that Customer with the ListID that matches an existing ListID in QB and the Item Name from another record or the Item Name matches, a more likely scenario, and the ListID is different. | Both ListID and the Name are unique keys in QuickBooks. And you modified a customer which prompts to export that Customer with the ListID that matches an existing ListID in QB and the Item Name from another record or the Item Name matches, a more likely scenario, and the ListID is different. | ||
− | This produces the "Cannot merge list elements" error message back from QuickBooks. | + | This produces the "Cannot merge list elements" error message back from QuickBooks. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
'''To resolve this issue:''' | '''To resolve this issue:''' | ||
Line 253: | Line 180: | ||
* 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. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |