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 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/
 
 
 
== SQLink Error 899 -  You cannot pay more than the amount due==
 
899: The "AppliedToTxnAdd payment amount" field has an invalid value "3353.98".  QuickBooks error message: You cannot pay more than the amount due.
 
 
This error occurs when QuickBooks cannot mark an invoice as paid because the invoice balance and the applied amount are in conflict.
 
They payment cannot be applied to the QuickBooks invoice because it has already been paid.
 
  
  
Line 54: Line 46:
 
== SQLink Error 810 ==
 
== SQLink Error 810 ==
  
'''Error:''' 810: There was an error when saving a Invoice.  QuickBooks error message: The transaction is empty.<br>
+
810: There was an error when saving a Invoice.  QuickBooks error message: The transaction is empty.<br>
 
 
'''Solution:''' 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>
 
 
 
'''May Appear as:''' <u>'The transaction must be positive'</u> or <u>'Invoice ##### skipped - voided invoices cannot be exported'</u><br>
 
 
 
'''Solution:''' For both cases go to invoice in SME and either uncheck "export to QB" or delete invoice.<br>
 
 
 
'''This error can also appear in PO as error:'''
 
<br>
 
810: There was an error when saving a Bill.  QuickBooks error message: This transaction action is not allowed for this user.
 
 
 
'''Probable causes:''' <br>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>
 
 
 
'''Error:''' 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.
 
  
'''Solution:''' Assure everyone is out of QuickBooks as a record is currently being locked by another user. <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>
  
'''Note''' - If you are syncing SME with QuickBooks and you checked the option '''To Be Emailed''' by default, if the Billing
+
Can also come up as 'The transaction must be positive'
Customer doesn't have a matching email address with QuickBooks, the invoice won't be able to sync over.
+
Go to invoice in SME and either uncheck "export to QB" or delete invoice.<br>
<br>
 
  
'''Error:''' 810: There was an error when saving a Invoice.  QuickBooks error message: The email address specified for this customer is invalid, and the transaction is marked 'To be e-mailed'.<br>
+
Can also come up as 'Invoice ##### skipped - voided invoices cannot be exported'
'''Solution:''' Apply correct email to Billing Customer or uncheck '''To Be Emailed'''.
+
Go to invoice in SME and either uncheck "export to QB" or delete invoice.<br>
 
 
== SQLink Error 851 : Unable to find the QuickBooks Request Processor ==
 
851 : Unable to find the QuickBooks Request Processor 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.  
 
QBFC 11.0: http://high5software.com/downloads/QB/QBFC11_0Installer.exe
 
  
 +
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 120: Line 92:
 
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.
  
{{#ev:youtube| 5EC0ZdD3I7I }}
+
<videoflash>5EC0ZdD3I7I</videoflash>
  
 
<br>'''Find which customer record is the duplicate'''
 
<br>'''Find which customer record is the duplicate'''
Line 164: Line 136:
  
  
{{#ev:youtube| 5EC0ZdD3I7I }}
+
<videoflash>5EC0ZdD3I7I</videoflash>
  
  
Line 190: Line 162:
 
#    Run the QBFC7_0Installer.
 
#    Run the QBFC7_0Installer.
  
Also, SQLink and QuickBooks must reference the same path to access the QuickBooks company file. You may see this error on SQLink: "602 Different File Open". To resolve this:
+
Also, SQLink and QuickBooks must reference the same path to access the QuickBooks company file. to check this:
  
 
#    Open QuickBooks.
 
#    Open QuickBooks.
Line 323: Line 295:
  
 
== There is no disk in the drive.  Please insert a disk into drive E. ==
 
== There is no disk in the drive.  Please insert a disk into drive E. ==
This happens when USB devises are removed without first ejecting the media. This can happen either from USB or DVD/CD devises. You may also need to put a readable DVD or CD in your removable drives. You can Download the following files for 64 and 32 bit machines:
+
This happens when USB devises are removed without first ejecting the media. This can happen either from USB or DVD/CD devises. You may also need to put a readable DVD or CD in your removable drives.  
 +
 
 +
<br>1. First look at the removable USB devises icon next to the system clock.
 +
<br>    [[File:RemovableDisc.png]]
 +
<br>2. When you put the mouse over the icon you’ll see the following:
 +
<br>    [[File:SafelyRemove.png]]
 +
<br>3. Click on the icon and you will see all USB related devises
 +
<br>    [[File:EjectFlash.png]]
 +
<br>4. Remove all drive related entries that are not currently plugged in.
 +
<br>5. Place a disk in all DVD/CD drives.
 +
<br>6. This should clear up the issue.
  
<br>64 bit:
+
<br>More info on the topic:
<br>link: [http://high5software.com\downloads\tools\usbtools\usbdeview-x64.zip 64-bit]
 
  
<br>32 bit:
+
<br>http://ccrqblog.ccrsoftware.info/2010/02/stopping-the-windows-no-disk-error/
<br>link: [http://high5software.com\downloads\tools\usbtools\usbdeview.zip 32-bit]
 
  
<br>'''Prevent the error from happening in the future:'''
+
<br>For more dire cases do the following:  
<br>1. Download, extract, and right click on USBDeview.exe and click 'Run as Administrator'.  If you get the following warning during this procedure you did not do that:
 
<br>    [[File:USBadmin.jpg]] <br>
 
<br>2. Sort by 'Safe to Unplug' by clicking on the top Header:
 
<br>    [[File:USBunplug.jpg]] <br>
 
<br>3. then Select all that are safe to unplug and NOT Connected and click on the RED X in the top left corner:
 
<br>    [[File:USBdissconnect.jpg]] <br>
 
<br>4. This should clear up the issue.
 
  
<br>'''Another solution:'''
 
 
<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 351: Line 323:
 
<br>[[File:DuplicateDiscs.png]]
 
<br>[[File:DuplicateDiscs.png]]
  
<br>'''For more dire cases do the following:'''
+
 
<br> 1. In Disk Management, find the drive letter or disk referenced in the error. Note, if the error says HardDisk2 or Harddisk3, find Disk 2 or Disk 3.
 
<br> 2. Right-click the disk and select “Change Drive Letter and Paths”.
 
<br> 3. Click the “Change” button in the dialog box
 
<br> 4. Click on the dropdown and select a new drive letter. We recommend changing this to a letter farther down in the alphabet.
 
<br> 5. Click OK
 
<br> 6. Run a sync to check if the error still exist.
 
  
 
== QuickBooks warning 550 ==
 
== QuickBooks warning 550 ==
Line 363: Line 329:
  
 
<br>This is a warning / bug from QuickBooks which High5 can't do anything about. The record should be updated with the sync, but to stop getting the error you must go to the record in QuickBooks and enter any character in the Notes.
 
<br>This is a warning / bug from QuickBooks which High5 can't do anything about. The record should be updated with the sync, but to stop getting the error you must go to the record in QuickBooks and enter any character in the Notes.
 
 
 
==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. You may also have to reboot the client computer. 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>To resolve, close QuickBooks and reopen or reboot the client computer that is experiencing the error. This should reset the QuickBooks ID generation
 
<br>May have to re-check Export Invoice to QB and Bill or PO
 

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)