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 7: | Line 7: | ||
== 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. The element (########-#########) is the | + | 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 element (########-#########) is QB the term for an item; Customer, Vendor, Employee, Inventory, Service, Account, etc... |
The string - ("800005BC-1267498278" - is the QB ID for an item in QB) - means that the item, a customer, invoice, account, service, etc... used to be in QB but it now has a new QB ID or has otherwise been modified in QB. Modifications can include setting the item as inactive, deleting or merging it with another item, etc... To resolve look at all items related to the error and make sure they exist in QB. | The string - ("800005BC-1267498278" - is the QB ID for an item in QB) - means that the item, a customer, invoice, account, service, etc... used to be in QB but it now has a new QB ID or has otherwise been modified in QB. Modifications can include setting the item as inactive, deleting or merging it with another item, etc... To resolve look at all items related to the error and make sure they exist in QB. | ||
Line 25: | Line 25: | ||
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 54: | Line 46: | ||
== SQLink Error 810 == | == SQLink Error 810 == | ||
− | + | 810: There was an error when saving a Invoice. QuickBooks error message: The transaction is empty.<br> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | In this case the invoice was a combined invoice and the order on the invoice was removed or deleted. Go to invoice in SME and either uncheck "export to QB" or delete invoice.<br> | |
− | |||
+ | This error can also come under PO as: 810: There was an error when saving a Bill. QuickBooks error message: This transaction action is not allowed for this user. - Probable causes are the user running SQLink does not have permission to modify bills in QuickBooks or the closing date has been set and a QB Admin would need to modify the restriction to export the PO/Bill. <br> | ||
== SQLink Error 201 == | == SQLink Error 201 == | ||
Line 104: | Line 70: | ||
- Check if the record should be tied to a specific customer. If the record has no information you can safely set it as inactive and delete it.<br> | - Check if the record should be tied to a specific customer. If the record has no information you can safely set it as inactive and delete it.<br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Duplicate Customer == | == Duplicate Customer == | ||
Line 120: | Line 78: | ||
You can follow the following steps to resolve the error or watch the video below. | You can follow the following steps to resolve the error or watch the video below. | ||
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
<br>'''Find which customer record is the duplicate''' | <br>'''Find which customer record is the duplicate''' | ||
Line 164: | Line 122: | ||
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
Line 190: | Line 148: | ||
# 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 268: | Line 226: | ||
[[File:QBFC_Not_Found.png]] | [[File:QBFC_Not_Found.png]] | ||
<br>The QBFC program is local to the logged on user. Download and run the installer from the following link. | <br>The QBFC program is local to the logged on user. Download and run the installer from the following link. | ||
− | <br>QBFC | + | <br>QBFC 8.0: http://high5software.com/downloads/QB/QBFC8_0Installer.exe |
− | |||
− | |||
− | + | == Error 819 == | |
− | + | This is part of the – ‘Unknown error’ returned from QB – seems sometimes it returns an error # and others it does not. Update the SQLink errors page and add it to the ‘Unknown Error’ message… | |
− | + | ||
− | + | <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) | |
− | + | <br>- Additional info to above… can also be reported as Error 819 | |
− | + | <br>- Error adding XYZ 819 – (The object may not be changed). Error adding XYZ 819: There was an error when modifying a Customers list, element "800009F6-1300911661". QuickBooks error message: Unknown Error. The Customer List Element is the QuickBooks UID for the customer you have flagged to move in SME. | |
− | |||
− | |||
− | |||
− | <br> | ||
− | |||
− | <br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <br> | + | <br>- To Resolve: Review QuickBooks for the XYZ company and reset the SME companies to match what they were before the ‘Is Billable’ flag was lifted or the Billing/Parent Company was changed. – I think we cover this… |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |