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 15: Line 15:
 
* - Check SQLink defaults and make sure all accounts on the default tabs in SQLink are present and active in QB.
 
* - 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.
 
* - Open SQLink> File> Setup> check all tabs and make sure the listed items are active in QB.
 +
 +
== SQLink Error 807 ==
 +
<br>
 +
'''Error:'''
 +
807: Object "8000000D-1367935235" specified in the request cannot be found.  QuickBooks error message: Invalid argument.  The specified record does not exist in the list.
 +
Item 8000000D-1367935235 found in Classes:ClassID [Name=Tax Paid] UID = QB050813090849210478
 +
<br>
 +
'''To decipher the error message:'''
 +
<br>
 +
The error message can be broken out to reveal the exact item of information that is causing the SQLink Error.
 +
<br>
 +
‘807: Object "8000000D-1367935235" specified in the request cannot be found.  QuickBooks error message: Invalid argument.  The specified record does not exist in the list.’
 +
<br>
 +
* -  ‘807’ – a number used by QuickBooks to categorize errors for data causing the issue with QuickBooks – there are many different error codes and SQLink makes an attempt to return the exact information that is causing the issue.
 +
<br>
 +
* - Object – A piece of information that is read in the syncing process when exporting SME data to QuickBooks. In this case the ‘Object’ is the ‘QB UID’ that is represented as ‘8000000D-1367935235’.
 +
<br>
 +
* - ‘Specified in the request cannot be found’ – this means that the ‘Object’, the QB UID cannot be found in QuickBooks on the QuickBooks Master list.
 +
<br>
 +
* - ‘QuickBooks error message: Invalid argument.’ -  ‘Invalid Argument’ means the use of the QB UID is invalid since QuickBooks can no longer locate it on the Master List. This is usually due to one of the following issues:
 +
  The item is set as inactive in QuickBooks
 +
  The item has been deleted from QuickBooks
 +
  The item name has changed in QuickBooks
 +
<br>
 +
* - ‘The specified record does not exist in the list.’ – the ‘record’ in question is the ‘QB UID’  – ‘8000000D-1367935235’
 +
<br>
 +
This line contains the info required to locate the item in SME and QB:
 +
‘Item 8000000D-1367935235 found in Classes:ClassID [Name=Tax Paid] UID = QB050813090849210478’
 +
<br>
 +
* - Item – an item in SME that is returned from QB as an error and will almost always be represented as the QB UID – ‘8000000D-1367935235’
 +
<br>
 +
* - QB UID – string of numbers representing the QB UID ‘8000000D-1367935235’
 +
  SME Table/Module – found in: Table/Field – Classes:ClassID
 +
  Table = Classes – SME Table containing the Class Items - Classes
 +
  Field = ClassID – Field containing the QB UID - :ClassID
 +
  Field Name in SME Table – in this example – The Class is named ‘Tax Paid’ - [Name=Tax Paid]
 +
  SME Field UID for the offending record - UID = QB050813090849210478
 +
<br>
 +
Resolution: Based on the above info QB is returning the message that the ‘Class’ – named ‘Tax Paid’ that is referenced by the ‘QB-UID’ – ‘8000000D-1367935235’
 +
<br>
 +
<br>
 +
'''Error:'''
 +
<br>The following error references a Customer record. It is applicable to any error which returns the same error dialogue. The dialogue can reference any table that syncs records with QuickBooks. The error message can be broken out to reveal the exact item of information that is causing the SQLink error.
 +
<br>
 +
Error adding PETCO STORE 482 807:
 +
QuickBooks Messages: Returned to SQLink from QuickBooks.
 +
* - Object "80000005-1411076727" specified in the request cannot be found.  QuickBooks error message: Invalid argument.  The specified record does not exist in the list.
 +
* - The Object is QuickBooks terminology for a value that references a value in QuickBooks that is stored in SME for the record causing the error.
 +
* - The Object that QuickBooks is referring to is the QuickBooks UID or ID: "80000005-1411076727"
 +
* - The statement: The specified record does not exist in the list. Is telling us that QuickBooks no longer has the Object, "80000005-1411076727", in QuickBooks, or, the customer has been set as Inactive in QuickBooks.
 +
SME Messages: Returned to SQLink from SME.
 +
* -  Item 80000005-1411076727 found in Cust:CustID [Name=PETCO ANIMAL SUPPLIES, INC.] UID = CM201409164264A10AF4
 +
* - The Item = "80000005-1411076727" (Same as QuickBooks ‘Object’)
 +
* -  Found In Cust:CustID = [Name=Item Name causing the error and can reference any table with records that sync to QuickBooks]:{SME UID} – the record in SME with the UID causing the error
 +
* - ‘Found In Cust:CustID [Name=Item Name causing the error]
 +
* - UID =  CM201409164264A10AF4 – SME UID for the record causing the error
 +
* - Error Item 80000005-1411076727 found in Cust:ParentID in 1 records
 +
* - The number of records that reference the QB Object that is causing the error
 +
<br>
 +
'''Error Resolution: '''<br>
 +
Based on the above information for this error we can tell the following:
 +
* - That the record in SME is a customer record
 +
* - That the issue is the QuickBooks ID, object, is no longer in QuickBooks
 +
* - That the QuickBooks object exists in one record in SME
 +
The following information will be used to resolve the Issues. It is possible to clear the item/object that is causing the error and reconnect them using the following procedure.
 +
<br><br>
 +
'''To Resolve: '''
 +
<br>Open SQLink: (Must be version 8.1.5.## or later)
 +
'''Go to Help> Find Item'''
 +
<br>
 +
* - Go to SQLink> Find Item
 +
* - Paste the Object/Item from the error into the field in SQLink ("80000005-1411076727")
 +
* - Click Enter: this will display a list of the tables and records where the item/object causing the error is referenced in the SME database.
 +
If you wish to clear the QuickBooks object you can do the following:
 +
* - Go to Help> Clear Item
 +
* - Enter the QuickBooks object ("80000005-1411076727")     
 +
* - Click ‘Ok’ – the QuickBooks object will be removed from all tables where it exists.
 +
Once you’ve removed the QuickBooks object that was causing the error. Go into QuickBooks and locate the record causing the error. Make a small edit such as adding a period to an address, description, etc.  This action will reset the information QuickBooks uses to tell SME/SQLink that a QuickBooks record has been modified.
 +
<br>
 +
'''Run a ‘Full sync’ '''
 +
* - Open SME
 +
* - Open SQLink
 +
* - Open QB
 +
* - In SME> Tools> Sync QuickBooks
 +
* - In SQLink> Processes> Start Processes<br>
 +
The SME record will be reset with the QuickBooks ID/Object. Do not attempt to ‘Export’ the record to QuickBooks as it will cause an error because the record already exists in QuickBooks.
  
 
== SQLink Error 805 ==
 
== SQLink Error 805 ==

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)