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 54: | Line 54: | ||
== 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> | |
− | + | Can also come up as 'The transaction must be positive' | |
+ | Go to invoice in SME and either uncheck "export to QB" or delete invoice.<br> | ||
− | '' | + | Can also come up as 'Invoice ##### skipped - voided invoices cannot be exported' |
+ | 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> | |
− | |||
− | 810: There was an error when saving a Bill. QuickBooks error message: This transaction action is not allowed for this user. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | Error adding (Customer – but can be other types of records as well) 810: There was an error when saving a Customers list, element "Customer Name". QuickBooks error message: This list has been modified by another user. | |
− | Customer | ||
− | |||
− | |||
− | |||
− | |||
== SQLink Error 851 : Unable to find the QuickBooks Request Processor == | == SQLink Error 851 : Unable to find the QuickBooks Request Processor == | ||
− | 851 : Unable to find the QuickBooks Request | + | 851 : Unable to find the QuickBooks Request PRrocessor on your system. Please make sure that QuickBooks 2002 Pro or higher is installed on your system |
Download and run the installer from the following link. | Download and run the installer from the following link. | ||
Line 120: | Line 109: | ||
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 153: | ||
− | + | <videoflash>5EC0ZdD3I7I</videoflash> | |
Line 190: | Line 179: | ||
# 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 340: | Line 329: | ||
<br>4. This should clear up the issue. | <br>4. This should clear up the issue. | ||
− | <br>''' | + | <br>More info on the topic: |
+ | <br>http://ccrqblog.ccrsoftware.info/2010/02/stopping-the-windows-no-disk-error/ | ||
+ | |||
+ | |||
+ | <br>'''For more dire cases do the following:''' | ||
<br>1. Right click on '''My Computer''' | <br>1. Right click on '''My Computer''' | ||
<br>2. Click on '''Manage''' | <br>2. Click on '''Manage''' | ||
Line 350: | Line 343: | ||
<br>'''Note:''' On some computers you will see duplicate entries in your device manager. You will need to Disable the duplicates. | <br>'''Note:''' On some computers you will see duplicate entries in your device manager. You will need to Disable the duplicates. | ||
<br>[[File:DuplicateDiscs.png]] | <br>[[File:DuplicateDiscs.png]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== QuickBooks warning 550 == | == QuickBooks warning 550 == | ||
Line 367: | Line 352: | ||
==SQLink Error 511 - QBRequestID has been used previously for another request == | ==SQLink Error 511 - QBRequestID has been used previously for another request == | ||
− | This message is from QuickBooks. Usually closing and reopening QB will clear the message and reset the request processor | + | This message is from QuickBooks. Usually closing and reopening QB will clear the message and reset the request processor. We've noticed that the QB ID generator sometimes gets stuck, and when it does, this is the outcome. |
<br>[[File:Error511_QBRequestID.png]] | <br>[[File:Error511_QBRequestID.png]] | ||
− | <br>To resolve, close QuickBooks and reopen | + | <br>To resolve, close QuickBooks and reopen. This should reset the QuickBooks ID generation |
<br>May have to re-check Export Invoice to QB and Bill or PO | <br>May have to re-check Export Invoice to QB and Bill or PO |