Editing SQLink Error - List Element Error

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 15: Line 15:
 
'''To resolve this issue:'''
 
'''To resolve this issue:'''
  
−
<br>1.   Examine the SQLink log: Look at the error:
+
#   Examine the SQLink log: Look at the error:
 
*        Error adding Customer A 819: There was an error when modifying a Customers list, element "3170000-1189020798". QuickBooks error message: Cannot merge list elements.
 
*        Error adding Customer A 819: There was an error when modifying a Customers list, element "3170000-1189020798". QuickBooks error message: Cannot merge list elements.
−
<br>2.   In QuickBooks, locate and edit the name of the vendor/customer:
+
#   In QuickBooks, locate and edit the name of the vendor/customer:
 
*        Choose '''Lists''' > '''Customer''': '''Job List''' or '''Lists''' > '''Vendor''' List, or '''Lists'''> '''Item List, etc'''… as needs may require.
 
*        Choose '''Lists''' > '''Customer''': '''Job List''' or '''Lists''' > '''Vendor''' List, or '''Lists'''> '''Item List, etc'''… as needs may require.
 
*        Locate and double-click the name noted in the SQLink Log.
 
*        Locate and double-click the name noted in the SQLink Log.
 
*        Place a 1 at the end of the name and click OK. Leave QuickBooks and this list open.
 
*        Place a 1 at the end of the name and click OK. Leave QuickBooks and this list open.
−
<br>3.   In SQLink do '''Data Functions> Export New QuickBooks Data> (List Item)'''. In this case it will be Customers. There should be no error for the specific record and it will export to QuickBooks and sit right next to the QuickBooks Record.
+
#   In SQLink do '''Data Functions> Export New QuickBooks Data> (List Item)'''. In this case it will be Customers. There should be no error for the specific record and it will export to QuickBooks and sit right next to the QuickBooks Record.
−
<br>4.   In QuickBooks, merge the edited name with the name that has been created by the SQLink:
+
#   In QuickBooks, merge the edited name with the name that has been created by the SQLink:
 
*        In the open list in QuickBooks, double-click the name to which you added a 1.
 
*        In the open list in QuickBooks, double-click the name to which you added a 1.
 
*        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.       Do this for all items that have the issue from the SME log.
+
#       Do this for all items that have the issue from the SME log.

Please note that all contributions to High5Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see High5Wiki:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)
Retrieved from "https://www.high5software.com//mediawiki/index.php?title=SQLink_Error_-_List_Element_Error"