Common SQLink Errors

From High5Wiki
Revision as of 18:24, 7 June 2011 by Moha (talk | contribs)
Jump to navigation Jump to search

Duplicates - Customer : XYZ Company is skipped due to duplication

-

If you get this error, there is a dupilcate customer in SME. Click Error SQLink Error-Duplicate Customer for video and more details.


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. -

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. -

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



- QB must be in Single user mode to allow the change. These changes should only be made in QB. (See below**)



- 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)


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. This error happens when the billing address is changed on a site customer record in SME. I do not recommend making these changes in SME. This specifically happens when you click the 'Select Billing Company' button or uncheck the 'Is Billable Flag' on the Billing Address and select a new parent/billing customer. Since QuickBooks has special limitations on moving customers between Parent/Billing companies it is always best to do this in QuickBooks. There are two issue that QuickBooks raises: - QB must be in Single User mode to make the change - If the change cannot be done due to QB rules you will be warned There are a couple of ways to move customers in QB. One is available from the following video link and one is by dragging the customer to a new parent.

Link to the Video:Move QB Customers to Job Sites

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.