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: | ||
− | + | <h3>Duplicates - Customer : XYZ Company is skipped due to duplication</h3> - | |
− | |||
− | |||
− | |||
+ | If you get this error, there is a dupilcate customer in SME. Click Error [[SQLink Error-Duplicate Customer]] for video and more details. | ||
+ | |||
+ | |||
+ | <h3></h3>Invoice #XXX skipped - Customer link ID not initialized | ||
+ | |||
+ | If you receive this error, you are trying to sync an invoice to QuickBooks that didn't have a valid customer in QuickBooks. Click [[Customer Link ID Not Initialized]] for video and more information. | ||
+ | |||
+ | |||
− | + | '''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 use 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. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | ||
− | Error adding XYZ Company - 805: The name " XYZ Company " of the list element is already in use | + | '''Error adding XYZ Company - 805: The name " XYZ Company " of the list element is already in use.''' - |
This means that the name - "XYZ Company" - is already in QB on a list. User needs to locate it in QB and add something to the name. QB convention is (V) if on the vendor list, (E), if on the employee list, etc... If it's already on the customer list add (SME) and merge it in QB with the original. | This means that the name - "XYZ Company" - is already in QB on a list. User needs to locate it in QB and add something to the name. QB convention is (V) if on the vendor list, (E), if on the employee list, etc... If it's already on the customer list add (SME) and merge it in QB with the original. | ||
− | |||
− | |||
− | + | '''Error adding XYZ Company - 808: There is an invalid reference to a parent "800009F6-1274207539" in the Customers list. ''' | |
+ | QuickBooks error message: To change parent or type when the element or its descendants has been used in a transaction, you must switch to single-user mode. - Just that | ||
− | + | <br>- QB must be in Single user mode to allow the change. These changes should only be made in QB. (See below**) | |
− | |||
− | |||
− | |||
+ | <br>- If switched to Single user - they may get - XYZ Company - Unknown error returned from QuickBooks... this means QB cannot move the child to a new parent due to history on the child company like payments, invoices, etc.. - (See below) | ||
− | + | ||
− | SQLink Error 808: Error adding Customer XYZ 808: There is an invalid reference to a parent "80000004-1207320348" in the Customers list. | + | '''Error adding XYZ Company - 899: The string "ST. FRANCIS OF ASSISI CATH. CHURCH - VIDEO" in the field "Addr1" is too long.''' - |
+ | |||
+ | Need to shorten the address to less than 40 characters. (Put a link to an online character counter) | ||
+ | |||
+ | *''' SQLink Error 808: Error adding Customer XYZ 808: There is an invalid reference to a parent "80000004-1207320348" in the Customers list.''' | ||
QuickBooks error message: To change parent or type when the element or its descendants has been used in a transaction, you must switch to single-user mode. <- QuickBooks must be in single user mode. | QuickBooks error message: To change parent or type when the element or its descendants has been used in a transaction, you must switch to single-user mode. <- QuickBooks must be in single user mode. | ||
Line 48: | Line 48: | ||
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. | ||
− | + | == Duplicate Customer == | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
If you see the following error in SQLink, there is a duplicate customer in SME. | If you see the following error in SQLink, there is a duplicate customer in SME. | ||
'''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 94: | ||
# 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 == | ||
+ | |||
+ | == Headline text == | ||
If you receive the following SQLink error, you were trying to sync an invoice to QuickBooks that didn't have a valid customer in QuickBooks. | If you receive the following SQLink error, you were trying to sync an invoice to QuickBooks that didn't have a valid customer in QuickBooks. | ||
Line 164: | Line 106: | ||
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
Line 190: | Line 132: | ||
# 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 156: | ||
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 171: | ||
* 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. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |